View: AST_TARGET_CAMPAIGNS_V

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

View Text

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'
, 'COMPLETED')
AND LE.PARTY_ID IS NOT NULL

Columns