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_ENGINE dependencies on MTL_TXN_REQUEST_HEADERS

Line 507: mtl_txn_request_headers moh

503: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
504: mtl_item_locations loc,
505: mtl_secondary_inventories sub,
506: mtl_txn_request_lines mol,
507: mtl_txn_request_headers moh
508: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
509: AND wdtv.organization_id = p_sign_on_org_id
510: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
511: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133

Line 856: mtl_txn_request_headers moh

852: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
853: mtl_item_locations loc,
854: mtl_secondary_inventories sub,
855: mtl_txn_request_lines mol,
856: mtl_txn_request_headers moh
857: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
858: AND wdtv.organization_id = p_sign_on_org_id
859: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
860: AND wdtv.zone = p_sign_on_zone -- removed NVL, bug 2648133

Line 1414: mtl_txn_request_headers moh

1410: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1411: mtl_item_locations loc,
1412: mtl_secondary_inventories sub,
1413: mtl_txn_request_lines mol,
1414: mtl_txn_request_headers moh
1415: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1416: AND wdtv.organization_id = p_sign_on_org_id
1417: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1418: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))

Line 1761: mtl_txn_request_headers moh

1757: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
1758: mtl_item_locations loc,
1759: mtl_secondary_inventories sub,
1760: mtl_txn_request_lines mol,
1761: mtl_txn_request_headers moh
1762: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
1763: AND wdtv.organization_id = p_sign_on_org_id
1764: AND wdtv.user_task_type_id = v.standard_operation_id -- join task to resource view, check if user defined task type match
1765: AND NVL(wdtv.cartonization_id, -999) = NVL(l_cartonization_id, NVL(wdtv.cartonization_id, -999))

Line 2373: mtl_txn_request_headers moh

2369: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
2370: mtl_item_locations loc,
2371: mtl_secondary_inventories sub,
2372: mtl_txn_request_lines mol,
2373: mtl_txn_request_headers moh
2374: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2375: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2376: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')
2377: AND wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)

Line 2794: mtl_txn_request_headers moh

2790: WHERE utt_emp.standard_operation_id = utt_eqp.standard_operation_id(+)) v,
2791: mtl_item_locations loc,
2792: mtl_secondary_inventories sub,
2793: mtl_txn_request_lines mol,
2794: mtl_txn_request_headers moh
2795: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
2796: AND ((wdtv.pick_slip_number = v_pick_slip_number AND p_task_method = 'DISCRETE')
2797: OR (p_task_method IN ('MANUAL', 'WAVE', 'BULK', 'DISCRETE')
2798: AND wdtv.task_id = v_task_id AND wdtv.wms_task_type_id = v_task_type)

Line 7402: , mtl_txn_request_headers moh

7398: mtl_item_locations_kfv loc
7399: , --changed to kfv bug#2742611
7400: mtl_secondary_inventories sub
7401: , mtl_txn_request_lines mol
7402: , mtl_txn_request_headers moh
7403: , -- mtl_system_items msi -- bug 2648133
7404: wsh_delivery_details_ob_grp_v wdd
7405: , -- added
7406: wsh_delivery_assignments_v wda --added

Line 7563: , mtl_txn_request_headers moh

7559: mtl_item_locations_kfv loc
7560: , --changed to kfv bug#2742611
7561: mtl_secondary_inventories sub
7562: , mtl_txn_request_lines mol
7563: , mtl_txn_request_headers moh
7564: -- mtl_system_items msi -- bug 2648133
7565: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7566: AND wdtv.organization_id = p_sign_on_org_id
7567: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 7723: , mtl_txn_request_headers moh

7719: mtl_item_locations_kfv loc
7720: , --changed to kfv bug#2742611
7721: mtl_secondary_inventories sub
7722: , mtl_txn_request_lines mol
7723: , mtl_txn_request_headers moh
7724: , -- mtl_system_items msi -- bug 2648133
7725: wsh_delivery_details_ob_grp_v wdd
7726: , -- added
7727: wsh_delivery_assignments_v wda --added

Line 7883: , mtl_txn_request_headers moh

7879: mtl_item_locations_kfv loc
7880: , --changed to kfv bug#2742611
7881: mtl_secondary_inventories sub
7882: , mtl_txn_request_lines mol
7883: , mtl_txn_request_headers moh
7884: -- mtl_system_items msi -- bug 2648133
7885: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
7886: AND wdtv.organization_id = p_sign_on_org_id
7887: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 8012: , mtl_txn_request_headers moh

8008: , mtl_item_locations_kfv loc
8009: , --changed to kfv bug#2742611
8010: mtl_secondary_inventories sub
8011: , mtl_txn_request_lines mol
8012: , mtl_txn_request_headers moh
8013: , -- mtl_system_items msi -- bug 2648133
8014: wsh_delivery_details_ob_grp_v wdd
8015: , -- added
8016: wsh_delivery_assignments_v wda --added

Line 8119: , mtl_txn_request_headers moh

8115: mtl_item_locations_kfv loc
8116: , --changed to kfv bug#2742611
8117: mtl_secondary_inventories sub
8118: , mtl_txn_request_lines mol
8119: , mtl_txn_request_headers moh
8120: , -- mtl_system_items msi -- bug 2648133
8121: wsh_delivery_details_ob_grp_v wdd
8122: , -- added
8123: wsh_delivery_assignments_v wda --added

Line 8254: , mtl_txn_request_headers moh

8250: , mtl_item_locations_kfv loc
8251: , --changed to kfv bug#2742611
8252: mtl_secondary_inventories sub
8253: , mtl_txn_request_lines mol
8254: , mtl_txn_request_headers moh
8255: -- mtl_system_items msi -- bug 2648133
8256: WHERE wdt.transaction_temp_id = wdtv.task_id
8257: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
8258: AND wdt.person_id = p_sign_on_emp_id

Line 8351: , mtl_txn_request_headers moh

8347: mtl_item_locations_kfv loc
8348: , --changed to kfv bug#2742611
8349: mtl_secondary_inventories sub
8350: , mtl_txn_request_lines mol
8351: , mtl_txn_request_headers moh
8352: -- mtl_system_items msi -- bug 2648133
8353: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8354: AND wdtv.organization_id = p_sign_on_org_id
8355: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 8484: , mtl_txn_request_headers moh

8480: , mtl_item_locations_kfv loc
8481: , --changed to kfv bug#2742611
8482: mtl_secondary_inventories sub
8483: , mtl_txn_request_lines mol
8484: , mtl_txn_request_headers moh
8485: , -- mtl_system_items msi -- bug 2648133
8486: wsh_delivery_details_ob_grp_v wdd
8487: , -- added
8488: wsh_delivery_assignments_v wda --added

Line 8591: , mtl_txn_request_headers moh

8587: mtl_item_locations_kfv loc
8588: , --changed to kfv bug#2742611
8589: mtl_secondary_inventories sub
8590: , mtl_txn_request_lines mol
8591: , mtl_txn_request_headers moh
8592: , -- mtl_system_items msi -- bug 2648133
8593: wsh_delivery_details_ob_grp_v wdd
8594: , -- added
8595: wsh_delivery_assignments_v wda --added

Line 8716: , mtl_txn_request_headers moh

8712: , mtl_item_locations_kfv loc
8713: , --changed to kfv bug#2742611
8714: mtl_secondary_inventories sub
8715: , mtl_txn_request_lines mol
8716: , mtl_txn_request_headers moh
8717: -- mtl_system_items msi -- bug 2648133
8718: WHERE wdt.transaction_temp_id = wdtv.task_id
8719: AND wdt.status = 2 -- Queued tasks only
8720: AND wdt.person_id = p_sign_on_emp_id

Line 8815: , mtl_txn_request_headers moh

8811: mtl_item_locations_kfv loc
8812: , --changed to kfv bug#2742611
8813: mtl_secondary_inventories sub
8814: , mtl_txn_request_lines mol
8815: , mtl_txn_request_headers moh
8816: -- mtl_system_items msi -- bug 2648133
8817: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
8818: AND wdtv.organization_id = p_sign_on_org_id
8819: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 8948: , mtl_txn_request_headers moh

8944: , mtl_item_locations_kfv loc
8945: , --changed to kfv bug#2742611
8946: mtl_secondary_inventories sub
8947: , mtl_txn_request_lines mol
8948: , mtl_txn_request_headers moh
8949: , -- mtl_system_items msi -- bug 2648133
8950: wsh_delivery_details_ob_grp_v wdd
8951: , -- added
8952: wsh_delivery_assignments_v wda --added

Line 9053: , mtl_txn_request_headers moh

9049: mtl_item_locations_kfv loc
9050: , --changed to kfv bug#2742611
9051: mtl_secondary_inventories sub
9052: , mtl_txn_request_lines mol
9053: , mtl_txn_request_headers moh
9054: , -- mtl_system_items msi -- bug 2648133
9055: wsh_delivery_details_ob_grp_v wdd
9056: , -- added
9057: wsh_delivery_assignments_v wda --added

Line 9185: , mtl_txn_request_headers moh

9181: , mtl_item_locations_kfv loc
9182: , --changed to kfv bug#2742611
9183: mtl_secondary_inventories sub
9184: , mtl_txn_request_lines mol
9185: , mtl_txn_request_headers moh
9186: -- mtl_system_items msi -- bug 2648133
9187: WHERE wdt.transaction_temp_id = wdtv.task_id
9188: AND wdt.status in ( 2,3) -- Queued and dispatched tasks only bug 4310093
9189: AND wdt.person_id = p_sign_on_emp_id

Line 9283: , mtl_txn_request_headers moh

9279: mtl_item_locations_kfv loc
9280: , --changed to kfv bug#2742611
9281: mtl_secondary_inventories sub
9282: , mtl_txn_request_lines mol
9283: , mtl_txn_request_headers moh
9284: -- mtl_system_items msi -- bug 2648133
9285: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9286: AND wdtv.organization_id = p_sign_on_org_id
9287: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 9412: , mtl_txn_request_headers moh

9408: , mtl_item_locations_kfv loc
9409: , --changed to kfv bug#2742611
9410: mtl_secondary_inventories sub
9411: , mtl_txn_request_lines mol
9412: , mtl_txn_request_headers moh
9413: , -- mtl_system_items msi -- bug 2648133
9414: wsh_delivery_details_ob_grp_v wdd
9415: , -- added
9416: wsh_delivery_assignments_v wda --added

Line 9517: , mtl_txn_request_headers moh

9513: mtl_item_locations_kfv loc
9514: , --changed to kfv bug#2742611
9515: mtl_secondary_inventories sub
9516: , mtl_txn_request_lines mol
9517: , mtl_txn_request_headers moh
9518: , -- mtl_system_items msi -- bug 2648133
9519: wsh_delivery_details_ob_grp_v wdd
9520: , -- added
9521: wsh_delivery_assignments_v wda --added

Line 9641: , mtl_txn_request_headers moh

9637: , mtl_item_locations_kfv loc
9638: , --changed to kfv bug#2742611
9639: mtl_secondary_inventories sub
9640: , mtl_txn_request_lines mol
9641: , mtl_txn_request_headers moh
9642: -- mtl_system_items msi -- bug 2648133
9643: WHERE wdt.transaction_temp_id = wdtv.task_id
9644: AND wdt.status = 2 -- Queued tasks only
9645: AND wdt.person_id = p_sign_on_emp_id

Line 9739: , mtl_txn_request_headers moh

9735: mtl_item_locations_kfv loc
9736: , --changed to kfv bug#2742611
9737: mtl_secondary_inventories sub
9738: , mtl_txn_request_lines mol
9739: , mtl_txn_request_headers moh
9740: -- mtl_system_items msi -- bug 2648133
9741: WHERE v.emp_id = p_sign_on_emp_id -- restrict to sign on employee
9742: AND wdtv.organization_id = p_sign_on_org_id
9743: AND wdtv.wms_task_type_id = 1 -- restrict to picking tasks

Line 10785: FROM mtl_txn_request_headers

10781: -- changed for patchset J bulk picking -----------
10782: IF p_move_order_header_id <> -1 THEN
10783: SELECT move_order_type
10784: INTO l_move_order_type
10785: FROM mtl_txn_request_headers
10786: WHERE header_id = p_move_order_header_id;
10787:
10788: if (l_debug = 1) then print_debug('Move order type:'||l_move_order_type,4);
10789: end if;

Line 11185: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11181: AND mol.header_id = p_move_order_header_id
11182: AND mmtt.wms_task_type NOT IN(5, 6)
11183: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11184: AND( EXISTS(SELECT 1
11185: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11186: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11187: AND spg.pick_method = '4'
11188: AND moh.header_id = mol.header_id)
11189: OR EXISTS(SELECT 1

Line 11280: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg

11276: AND mol.header_id = p_move_order_header_id
11277: AND mmtt.wms_task_type NOT IN(5, 6)
11278: AND mmtt.allocated_lpn_id IS NULL -- if lpn allocated, no need to do consolidation
11279: AND( EXISTS(SELECT 1
11280: FROM mtl_txn_request_headers moh, wsh_pick_grouping_rules spg
11281: WHERE spg.pick_grouping_rule_id = moh.grouping_rule_id
11282: AND spg.pick_method = '4'
11283: AND moh.header_id = mol.header_id)
11284: OR EXISTS(SELECT 1

Line 11340: FROM mtl_txn_request_headers

11336: x_return_status := fnd_api.g_ret_sts_success;
11337:
11338: SELECT move_order_type
11339: INTO l_move_order_type
11340: FROM mtl_txn_request_headers
11341: WHERE header_id = p_move_order_header_id;
11342:
11343: IF l_move_order_type = g_move_order_mfg_pick THEN
11344: OPEN task_list_wip;