VIEW: APPS.AST_GRP_CAMPAIGNS_V

Source

View Text - Preformatted

SELECT grp.ROWID, grp.GROUP_CAMPAIGN_ID, grp.GROUP_ID, grp.CAMPAIGN_ID, grp.START_DATE, grp.END_DATE, grp.ENABLED_FLAG, grp.LAST_UPDATE_DATE, grp.LAST_UPDATED_BY, grp.CREATION_DATE, grp.CREATED_BY, grp.LAST_UPDATE_LOGIN, 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, jtfrs.GROUP_NUMBER, jtfrs.START_DATE_ACTIVE, jtfrs.END_DATE_ACTIVE, jtfrs.GROUP_NAME, jtfrs.GROUP_DESC FROM jtf_rs_groups_vl jtfrs, ams_p_campaigns_v camp, ast_grp_campaigns grp WHERE jtfrs.group_id = grp.group_id and grp.campaign_id = camp.campaign_id and grp.enabled_flag = 'Y' and trunc(SYSDATE) between nvl(grp.start_date,trunc(SYSDATE)) and nvl(grp.end_date, trunc(SYSDATE))

View Text - HTML Formatted

SELECT GRP.ROWID
, GRP.GROUP_CAMPAIGN_ID
, GRP.GROUP_ID
, GRP.CAMPAIGN_ID
, GRP.START_DATE
, GRP.END_DATE
, GRP.ENABLED_FLAG
, GRP.LAST_UPDATE_DATE
, GRP.LAST_UPDATED_BY
, GRP.CREATION_DATE
, GRP.CREATED_BY
, GRP.LAST_UPDATE_LOGIN
, 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
, JTFRS.GROUP_NUMBER
, JTFRS.START_DATE_ACTIVE
, JTFRS.END_DATE_ACTIVE
, JTFRS.GROUP_NAME
, JTFRS.GROUP_DESC
FROM JTF_RS_GROUPS_VL JTFRS
, AMS_P_CAMPAIGNS_V CAMP
, AST_GRP_CAMPAIGNS GRP
WHERE JTFRS.GROUP_ID = GRP.GROUP_ID
AND GRP.CAMPAIGN_ID = CAMP.CAMPAIGN_ID
AND GRP.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(GRP.START_DATE
, TRUNC(SYSDATE))
AND NVL(GRP.END_DATE
, TRUNC(SYSDATE))