DBA Data[Home] [Help]

VIEW: APPS.IEC_G_EXECUTING_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT B.CAMPAIGN_ID , B.CALL_CENTER_READY_FLAG , B.CTI_DISABLED_FLAG , B.AGENTLESS_FLAG , B.AGENTLESS_EXEC_MODE , B.NUM_VDU_PORTS , B.EXECUTION_STATUS FROM IEC_G_CAMPAIGNS_V B WHERE EXISTS ( SELECT 1 FROM IEC_G_EXECUTING_LISTS_V A WHERE A.CAMPAIGN_ID = B.CAMPAIGN_ID ) AND B.LANGUAGE = 'US'
View Text - HTML Formatted

SELECT B.CAMPAIGN_ID
, B.CALL_CENTER_READY_FLAG
, B.CTI_DISABLED_FLAG
, B.AGENTLESS_FLAG
, B.AGENTLESS_EXEC_MODE
, B.NUM_VDU_PORTS
, B.EXECUTION_STATUS
FROM IEC_G_CAMPAIGNS_V B
WHERE EXISTS ( SELECT 1
FROM IEC_G_EXECUTING_LISTS_V A
WHERE A.CAMPAIGN_ID = B.CAMPAIGN_ID )
AND B.LANGUAGE = 'US'