VIEW: APPS.AST_SOURCE_CODES_LOV_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'