VIEW: APPS.IEC_G_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT A.CAMPAIGN_ID , B.CAMPAIGN_NAME , B.DESCRIPTION , A.USER_STATUS_ID , A.STATUS_CODE , C.CALL_CENTER_READY_FLAG , C.CTI_DISABLED_FLAG , C.AGENTLESS_FLAG , C.AGENTLESS_EXEC_MODE , C.NUM_VDU_PORTS , C.EXECUTION_STATUS , A.ACTIVE_FLAG , A.SOURCE_CODE , A.LAST_UPDATE_DATE , A.LAST_UPDATED_BY , A.CREATION_DATE , A.CREATED_BY , A.LAST_UPDATE_LOGIN , A.OBJECT_VERSION_NUMBER , A.OWNER_USER_ID , B.LANGUAGE , D.NAME , A.ACTUAL_EXEC_START_DATE START_DATE_TIME , A.ACTUAL_EXEC_END_DATE END_DATE_TIME FROM AMS_CAMPAIGNS_ALL_B A , AMS_CAMPAIGNS_ALL_TL B , IEC_G_CPN_RT_INFO C , AMS_USER_STATUSES_TL D WHERE EXISTS( SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B E WHERE E.ACTIVITY_ID = 460 AND A.CAMPAIGN_ID = E.CAMPAIGN_ID ) AND B.CAMPAIGN_ID =A.CAMPAIGN_ID AND A.CAMPAIGN_ID =C.CAMPAIGN_ID(+) AND A.USER_STATUS_ID = D.USER_STATUS_ID AND D.LANGUAGE = B.LANGUAGE

View Text - HTML Formatted

SELECT A.CAMPAIGN_ID
, B.CAMPAIGN_NAME
, B.DESCRIPTION
, A.USER_STATUS_ID
, A.STATUS_CODE
, C.CALL_CENTER_READY_FLAG
, C.CTI_DISABLED_FLAG
, C.AGENTLESS_FLAG
, C.AGENTLESS_EXEC_MODE
, C.NUM_VDU_PORTS
, C.EXECUTION_STATUS
, A.ACTIVE_FLAG
, A.SOURCE_CODE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.OWNER_USER_ID
, B.LANGUAGE
, D.NAME
, A.ACTUAL_EXEC_START_DATE START_DATE_TIME
, A.ACTUAL_EXEC_END_DATE END_DATE_TIME
FROM AMS_CAMPAIGNS_ALL_B A
, AMS_CAMPAIGNS_ALL_TL B
, IEC_G_CPN_RT_INFO C
, AMS_USER_STATUSES_TL D
WHERE EXISTS( SELECT 1
FROM AMS_CAMPAIGN_SCHEDULES_B E
WHERE E.ACTIVITY_ID = 460
AND A.CAMPAIGN_ID = E.CAMPAIGN_ID )
AND B.CAMPAIGN_ID =A.CAMPAIGN_ID
AND A.CAMPAIGN_ID =C.CAMPAIGN_ID(+)
AND A.USER_STATUS_ID = D.USER_STATUS_ID
AND D.LANGUAGE = B.LANGUAGE