VIEW: APPS.AST_RS_CAMPAIGN_SCHEDS_V

Source

View Text - Preformatted

SELECT assg.RS_CAMPAIGN_ID, sch.SCHEDULE_ID, sch.SCHEDULE_NAME, assg.RESOURCE_ID, assg.START_DATE, assg.END_DATE, assg.STATUS, assg.ENABLED_FLAG, sch.STATUS_CODE, sch.SOURCE_CODE, rs.RESOURCE_NUMBER, rs.FULL_NAME, rs.EFFECTIVE_START_DATE, rs.EFFECTIVE_END_DATE, sch.ACTIVITY_ATTRIBUTE4 FROM jtf_rs_emp_dtls_vl rs, ams_campaign_schedules_vl sch, ast_rs_campaigns assg WHERE rs.resource_id = assg.resource_id AND assg.campaign_id = sch.schedule_id AND TRUNC(SYSDATE) BETWEEN NVL(rs.effective_start_date,trunc(SYSDATE)) AND nvl(rs.effective_end_date,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.RS_CAMPAIGN_ID
, SCH.SCHEDULE_ID
, SCH.SCHEDULE_NAME
, ASSG.RESOURCE_ID
, ASSG.START_DATE
, ASSG.END_DATE
, ASSG.STATUS
, ASSG.ENABLED_FLAG
, SCH.STATUS_CODE
, SCH.SOURCE_CODE
, RS.RESOURCE_NUMBER
, RS.FULL_NAME
, RS.EFFECTIVE_START_DATE
, RS.EFFECTIVE_END_DATE
, SCH.ACTIVITY_ATTRIBUTE4
FROM JTF_RS_EMP_DTLS_VL RS
, AMS_CAMPAIGN_SCHEDULES_VL SCH
, AST_RS_CAMPAIGNS ASSG
WHERE RS.RESOURCE_ID = ASSG.RESOURCE_ID
AND ASSG.CAMPAIGN_ID = SCH.SCHEDULE_ID
AND TRUNC(SYSDATE) BETWEEN NVL(RS.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(RS.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))
AND SCH.ACTIVITY_ID = 460
AND SCH.ACTIVE_FLAG = 'Y'
AND TRUNC(SYSDATE) < TRUNC(NVL(SCH.END_DATE_TIME
, SYSDATE)+1)