VIEW: APPS.AST_GRP_CAMPAIGN_SCHEDS_V

Source

View Text - Preformatted

SELECT assg.group_campaign_id, sch.SCHEDULE_ID, sch.SCHEDULE_NAME, assg.GROUP_ID, assg.START_DATE, assg.END_DATE, NULL, assg.ENABLED_FLAG, sch.STATUS_CODE, sch.SOURCE_CODE, grp.GROUP_NUMBER, grp.GROUP_NAME, grp.START_DATE_ACTIVE, grp.END_DATE_ACTIVE FROM jtf_rs_groups_vl grp, ams_campaign_schedules_vl sch, ast_grp_campaigns assg WHERE grp.group_id = assg.group_id AND assg.campaign_id = sch.schedule_id AND TRUNC(SYSDATE) BETWEEN NVL(grp.start_date_active,trunc(SYSDATE)) AND nvl(grp.end_date_active,trunc(SYSDATE)) AND sch.activity_id = 460 AND sch.active_flag = 'Y' AND TRUNC(SYSDATE) < TRUNC(nvl(sch.END_DATE_TIME,SYSDATE)+1)

View Text - HTML Formatted

SELECT ASSG.GROUP_CAMPAIGN_ID
, SCH.SCHEDULE_ID
, SCH.SCHEDULE_NAME
, ASSG.GROUP_ID
, ASSG.START_DATE
, ASSG.END_DATE
, NULL
, ASSG.ENABLED_FLAG
, SCH.STATUS_CODE
, SCH.SOURCE_CODE
, GRP.GROUP_NUMBER
, GRP.GROUP_NAME
, GRP.START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE
FROM JTF_RS_GROUPS_VL GRP
, AMS_CAMPAIGN_SCHEDULES_VL SCH
, AST_GRP_CAMPAIGNS ASSG
WHERE GRP.GROUP_ID = ASSG.GROUP_ID
AND ASSG.CAMPAIGN_ID = SCH.SCHEDULE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(GRP.START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(GRP.END_DATE_ACTIVE
, TRUNC(SYSDATE))
AND SCH.ACTIVITY_ID = 460
AND SCH.ACTIVE_FLAG = 'Y'
AND TRUNC(SYSDATE) < TRUNC(NVL(SCH.END_DATE_TIME
, SYSDATE)+1)