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.

APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_CYCLE_COUNT_HEADERS

Line 347: --Bug 3808770- Added the table mtl_cycle_count_headers in the from clause

343: AND wdt.status <= 3
344: AND ((wdt.task_type = 3
345: AND exists
346: (SELECT NVL(cycle_count_entry_id,-1)
347: --Bug 3808770- Added the table mtl_cycle_count_headers in the from clause
348: FROM mtl_cycle_count_entries mcce,mtl_cycle_count_headers mcch
349: WHERE mcce.cycle_count_entry_id = wdt.transaction_temp_id
350: AND mcce.organization_id = wdt.organization_id
351: AND mcce.subinventory = nvl(p_sign_on_zone,mcce.subinventory) --Added bug3771517

Line 348: FROM mtl_cycle_count_entries mcce,mtl_cycle_count_headers mcch

344: AND ((wdt.task_type = 3
345: AND exists
346: (SELECT NVL(cycle_count_entry_id,-1)
347: --Bug 3808770- Added the table mtl_cycle_count_headers in the from clause
348: FROM mtl_cycle_count_entries mcce,mtl_cycle_count_headers mcch
349: WHERE mcce.cycle_count_entry_id = wdt.transaction_temp_id
350: AND mcce.organization_id = wdt.organization_id
351: AND mcce.subinventory = nvl(p_sign_on_zone,mcce.subinventory) --Added bug3771517
352: AND mcce.entry_status_code in (1,3)

Line 380: FROM mtl_cycle_count_entries mcce ,mtl_cycle_count_headers mcch

376: AND wdt.status <= 3
377: AND ((wdt.task_type = 3
378: AND exists
379: (SELECT NVL(cycle_count_entry_id,-1)
380: FROM mtl_cycle_count_entries mcce ,mtl_cycle_count_headers mcch
381: WHERE mcce.cycle_count_entry_id = wdt.transaction_temp_id
382: AND mcce.subinventory = nvl(p_sign_on_zone,mcce.subinventory) --Added bug3771517
383: AND mcce.organization_id = wdt.organization_id
384: and mcce.entry_status_code in (1,3)

Line 443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause

439: , wdt.priority
440: , wdt.task_id task_id
441: , sub.picking_order sub_picking_order
442: , loc.picking_order loc_picking_order
443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
445: ,mtl_cycle_count_headers mcch
446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id

Line 445: ,mtl_cycle_count_headers mcch

441: , sub.picking_order sub_picking_order
442: , loc.picking_order loc_picking_order
443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
445: ,mtl_cycle_count_headers mcch
446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id
448: AND wdt.status <= 3
449: AND wdt.task_type = 3

Line 489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause

485: , wdt.priority
486: , wdt.task_id task_id
487: , sub.picking_order sub_picking_order
488: , loc.picking_order loc_picking_order
489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
491: , mtl_cycle_count_headers mcch
492: WHERE wdt.person_id = l_user_id
493: AND wdt.organization_id = l_org_id

Line 491: , mtl_cycle_count_headers mcch

487: , sub.picking_order sub_picking_order
488: , loc.picking_order loc_picking_order
489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
491: , mtl_cycle_count_headers mcch
492: WHERE wdt.person_id = l_user_id
493: AND wdt.organization_id = l_org_id
494: AND wdt.status <= 3
495: AND wdt.task_type = 3

Line 728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause

724: , mcce.standard_operation_id
725: INTO l_per_res_id
726: , l_wms_task_type
727: , l_std_op_id
728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause
729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch
730: WHERE mcce.cycle_count_entry_id = task_rec.task_id
731: AND mcce.standard_operation_id = bsor.standard_operation_id
732: AND bsor.resource_id = bremp.resource_id

Line 729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch

725: INTO l_per_res_id
726: , l_wms_task_type
727: , l_std_op_id
728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause
729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch
730: WHERE mcce.cycle_count_entry_id = task_rec.task_id
731: AND mcce.standard_operation_id = bsor.standard_operation_id
732: AND bsor.resource_id = bremp.resource_id
733: AND bremp.resource_type = 2