eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AST_RS_CAMPAIGN_SCHEDS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_RS_CAMPAIGN_SCHEDS_V

View Text

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) BETWEEN NVL(SCH.START_DATE_TIME
, TRUNC(SYSDATE))
AND NVL(SCH.END_DATE_TIME
, TRUNC(SYSDATE))

Columns

Name
RS_CAMPAIGN_ID
SCHEDULE_ID
SCHEDULE_NAME
RESOURCE_ID
RESOURCE_START_DATE
RESOURCE_END_DATE
RESOURCE_STATUS
RESOURCE_ENABLED_FLAG
SCHEDULE_STATUS_CODE
SCHEDULE_SOURCE_CODE
RESOURCE_NUMBER
RESOURCE_FULL_NAME
RESOURCE_EFFECTIVE_START_DATE
RESOURCE_EFFECTIVE_END_DATE
ACTIVITY_ATTRIBUTE4