View: AST_SOURCE_CODES_LOV_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_SOURCE_CODES_LOV_V

View Text

SELECT DISTINCT SC.NAME
, SC.SOURCE_CODE
, SC.SOURCE_TYPE
, TO_CHAR(SC.SOURCE_CODE_ID) IEU_LOV_COL4
FROM AMS_P_SOURCE_CODES_V SC
, AMS_ACT_OFFERS F
, AMS_P_SOURCE_CODES_V OFR
, AMS_LOOKUPS LKUP
WHERE SC.OBJECT_ID = F.ACT_OFFER_USED_BY_ID(+)
AND F.QP_LIST_HEADER_ID = OFR.OBJECT_ID(+)
AND OFR.SOURCE_TYPE (+) = 'OFFR'
AND OFR.STATUS (+) = 'ACTIVE'
AND SC.STATUS IN ('ACTIVE'
, 'ONHOLD'
, 'COMPLETED')
AND SC.SOURCE_TYPE IN ('EVEH'
, 'EVEO'
, 'CAMP'
, 'CSCH'
, 'EONE')
AND SYSDATE BETWEEN NVL(OFR.START_DATE
, SYSDATE -1)
AND NVL(OFR.END_DATE
, SYSDATE+1)
AND SC.SOURCE_TYPE = LKUP.LOOKUP_CODE(+)
AND LKUP.LOOKUP_TYPE(+) = 'AMS_SYS_ARC_QUALIFIER'

Columns