VIEW: APPS.AST_RS_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT assg.ROWID, assg.RS_CAMPAIGN_ID, assg.RESOURCE_ID, assg.CAMPAIGN_ID, assg.START_DATE, assg.END_DATE, assg.STATUS, assg.ENABLED_FLAG, camp.CAMPAIGN_NAME, camp.DESCRIPTION, camp.STATUS_CODE, camp.SOURCE_CODE, camp.INBOUND_SCRIPT_NAME, camp.CHANNEL_OUTBOUND_FLAG, camp.CHANNEL_INBOUND_FLAG, camp.INBOUND_EMAIL_ID, camp.INBOUND_PHONE_NO, rs.RESOURCE_NUMBER, rs.SOURCE_ID, rs.START_DATE_ACTIVE, rs.END_DATE_ACTIVE, rs.PRIMARY_LANGUAGE, rs.SECONDARY_LANGUAGE, rs.FIRST_NAME, rs.LAST_NAME, rs.MIDDLE_NAME, rs.FULL_NAME, rs.EFFECTIVE_START_DATE, rs.EFFECTIVE_END_DATE FROM jtf_rs_emp_dtls_vl rs, ams_p_campaigns_v camp, ast_rs_campaigns assg WHERE rs.resource_id = assg.resource_id and assg.campaign_id = camp.campaign_id and assg.enabled_flag = 'Y' and trunc(SYSDATE) BETWEEN nvl(assg.start_date,trunc(SYSDATE)) and nvl(assg.end_date,trunc(SYSDATE))

View Text - HTML Formatted

SELECT ASSG.ROWID
, ASSG.RS_CAMPAIGN_ID
, ASSG.RESOURCE_ID
, ASSG.CAMPAIGN_ID
, ASSG.START_DATE
, ASSG.END_DATE
, ASSG.STATUS
, ASSG.ENABLED_FLAG
, CAMP.CAMPAIGN_NAME
, CAMP.DESCRIPTION
, CAMP.STATUS_CODE
, CAMP.SOURCE_CODE
, CAMP.INBOUND_SCRIPT_NAME
, CAMP.CHANNEL_OUTBOUND_FLAG
, CAMP.CHANNEL_INBOUND_FLAG
, CAMP.INBOUND_EMAIL_ID
, CAMP.INBOUND_PHONE_NO
, RS.RESOURCE_NUMBER
, RS.SOURCE_ID
, RS.START_DATE_ACTIVE
, RS.END_DATE_ACTIVE
, RS.PRIMARY_LANGUAGE
, RS.SECONDARY_LANGUAGE
, RS.FIRST_NAME
, RS.LAST_NAME
, RS.MIDDLE_NAME
, RS.FULL_NAME
, RS.EFFECTIVE_START_DATE
, RS.EFFECTIVE_END_DATE
FROM JTF_RS_EMP_DTLS_VL RS
, AMS_P_CAMPAIGNS_V CAMP
, AST_RS_CAMPAIGNS ASSG
WHERE RS.RESOURCE_ID = ASSG.RESOURCE_ID
AND ASSG.CAMPAIGN_ID = CAMP.CAMPAIGN_ID
AND ASSG.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(ASSG.START_DATE
, TRUNC(SYSDATE))
AND NVL(ASSG.END_DATE
, TRUNC(SYSDATE))