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_GROUP_WORK_ASSIGNMENTS_V

Source

View Text - Preformatted


SELECT grpmem.resource_id RESOURCE_ID, camp_names.campaign_id CAMPAIGN_ID, grpcamp.campaign_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, IEC_AVAILABLE_RECORDS_V availrecs, AST_GRP_CAMPAIGNS grpcamp, JTF_RS_GROUP_MEMBERS grpmem, JTF_RS_GROUPS_DENORM grpdenorm WHERE grpmem.group_id = grpdenorm.group_id and grpcamp.group_id = grpdenorm.parent_group_id and grpcamp.campaign_id = availrecs.schedule_id(+) and camp_names.schedule_id = grpcamp.campaign_id

View Text - HTML Formatted

SELECT GRPMEM.RESOURCE_ID RESOURCE_ID
, CAMP_NAMES.CAMPAIGN_ID CAMPAIGN_ID
, GRPCAMP.CAMPAIGN_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
, IEC_AVAILABLE_RECORDS_V AVAILRECS
, AST_GRP_CAMPAIGNS GRPCAMP
, JTF_RS_GROUP_MEMBERS GRPMEM
, JTF_RS_GROUPS_DENORM GRPDENORM
WHERE GRPMEM.GROUP_ID = GRPDENORM.GROUP_ID
AND GRPCAMP.GROUP_ID = GRPDENORM.PARENT_GROUP_ID
AND GRPCAMP.CAMPAIGN_ID = AVAILRECS.SCHEDULE_ID(+)
AND CAMP_NAMES.SCHEDULE_ID = GRPCAMP.CAMPAIGN_ID