  SELECT DI.VALN_FIELD_FORCE_ID
       , FF.NAME__V                          AS FIELD_FORCE_NAME
       , DI.VCRM_SURVEY_ID
       , DI.ANSWER_CHOICE
       , DI.VCRM_PRODUCT_ID
       , PC.NAME                             AS PRODUCT_NAME
       , TO_CHAR( SYSDATE, 'YYYY-MM-DD' )    AS EXTRACT_DATE
    FROM MEDLKPADM.IE_DOCUMENTED_INTEREST_DTL DI
       , MEDLKPADM.VA_NA_FIELD_FORCE__ALN    FF
       , MEDLKPADM.VCRM_PRODUCT_VOD__C       PC
   WHERE FF.ID = DI.VALN_FIELD_FORCE_ID
     AND PC.ID = DI.VCRM_PRODUCT_ID
     AND PC.CORE_GSK_MEDICAL_PRODUCT__C = '1'        --Limit to Medical Products
     AND PC.NO_DETAILS_VOD__C = '0'                     --Limit to Call Products
     AND PC.CORE_GSK_COUNTRY__C = 'US'                    --Limit to US Products
     AND PC.CORE_GSK_INACTIVE__C = '0'                --Limit to Active Products
     -- Verify Mapping is still Active
     AND (DI.AUDT_DEL_DT IS NULL
       OR DI.AUDT_DEL_DT > SYSDATE)
ORDER BY FF.NAME__V
       , DI.VCRM_SURVEY_ID
       , DI.ANSWER_CHOICE
       , PC.NAME;