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.

VIEW: APPS.IEC_AGENT_WORK_ASSIGNMENTS_V

Source

View Text - Preformatted


SELECT astcamp.resource_id RESOURCE_ID, camp_names.campaign_id CAMPAIGN_ID, astcamp.schedule_id SCHEDULE_ID, camp_names.campaign_name CAMPAIGN_NAME, NVL(availrecs.RECORD_AVAILABLE, 0) QUEUE_COUNT FROM (select amscamp.campaign_id, amscamp.campaign_name, amssched.schedule_id from AMS_CAMPAIGNS_VL amscamp, AMS_CAMPAIGN_SCHEDULES_VL amssched where amssched.campaign_id = amscamp.campaign_id) camp_names, AST_RS_CAMPAIGN_SCHEDS_V astcamp, IEC_AVAILABLE_RECORDS_V availrecs WHERE astcamp.schedule_id = availrecs.schedule_id(+) and camp_names.schedule_id = astcamp.schedule_id

View Text - HTML Formatted

SELECT ASTCAMP.RESOURCE_ID RESOURCE_ID
, CAMP_NAMES.CAMPAIGN_ID CAMPAIGN_ID
, ASTCAMP.SCHEDULE_ID SCHEDULE_ID
, CAMP_NAMES.CAMPAIGN_NAME CAMPAIGN_NAME
, NVL(AVAILRECS.RECORD_AVAILABLE
, 0) QUEUE_COUNT
FROM (SELECT AMSCAMP.CAMPAIGN_ID
, AMSCAMP.CAMPAIGN_NAME
, AMSSCHED.SCHEDULE_ID
FROM AMS_CAMPAIGNS_VL AMSCAMP
, AMS_CAMPAIGN_SCHEDULES_VL AMSSCHED
WHERE AMSSCHED.CAMPAIGN_ID = AMSCAMP.CAMPAIGN_ID) CAMP_NAMES
, AST_RS_CAMPAIGN_SCHEDS_V ASTCAMP
, IEC_AVAILABLE_RECORDS_V AVAILRECS
WHERE ASTCAMP.SCHEDULE_ID = AVAILRECS.SCHEDULE_ID(+)
AND CAMP_NAMES.SCHEDULE_ID = ASTCAMP.SCHEDULE_ID