View: AST_CAMPAIGN_LOV_V

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

View Text

SELECT SC.SOURCE_CODE_ID
, SC.SOURCE_CODE
, SC.NAME
, SC.OBJECT_ID
, SC.STATUS
, SC.SOURCE_TYPE
FROM AMS_P_SOURCE_CODES_V SC
WHERE SC.STATUS IN ('ACTIVE'
, 'ONHOLD'
, 'COMPLETED')
AND SC.SOURCE_TYPE IN ('EVEH'
, 'EVEO'
, 'CAMP'
, 'CSCH'
, 'OFFR'
, 'EONE')

Columns