VIEW: APPS.AST_TARGET_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT LE.party_id, SC.source_code_id, SC.source_code, SC.object_id, SC.SOURCE_TYPE, AL.meaning, 'Y' active_flag FROM ams_p_source_codes_v SC, ams_list_entries LE, ams_lookups AL WHERE SC.source_code = LE.source_code AND LE.enabled_flag = 'Y' AND SC.SOURCE_TYPE = AL.lookup_code AND AL.ENABLED_FLAG = 'Y' AND AL.lookup_type = 'AMS_SYS_ARC_QUALIFIER' AND AL.lookup_code in ('CAMP', 'CSCH', 'EVEH', 'EVEO', 'OFFR', 'EONE') AND SC.status in ('ACTIVE', 'ONHOLD', 'ON_HOLD', 'COMPLETED') AND LE.party_id is not null

View Text - HTML Formatted

SELECT LE.PARTY_ID
, SC.SOURCE_CODE_ID
, SC.SOURCE_CODE
, SC.OBJECT_ID
, SC.SOURCE_TYPE
, AL.MEANING
, 'Y' ACTIVE_FLAG
FROM AMS_P_SOURCE_CODES_V SC
, AMS_LIST_ENTRIES LE
, AMS_LOOKUPS AL
WHERE SC.SOURCE_CODE = LE.SOURCE_CODE
AND LE.ENABLED_FLAG = 'Y'
AND SC.SOURCE_TYPE = AL.LOOKUP_CODE
AND AL.ENABLED_FLAG = 'Y'
AND AL.LOOKUP_TYPE = 'AMS_SYS_ARC_QUALIFIER'
AND AL.LOOKUP_CODE IN ('CAMP'
, 'CSCH'
, 'EVEH'
, 'EVEO'
, 'OFFR'
, 'EONE')
AND SC.STATUS IN ('ACTIVE'
, 'ONHOLD'
, 'ON_HOLD'
, 'COMPLETED')
AND LE.PARTY_ID IS NOT NULL