APPS.WMS_PUTAWAY_UTILS dependencies on MTL_TXN_REQUEST_HEADERS

Line 684: ,mtl_txn_request_headers mtrh

680: ,mtl_txn_request_lines mtrl
681: ,wms_dispatched_tasks wdt
682: --,mtl_item_locations milk
683: ,mtl_system_items_kfv msik
684: ,mtl_txn_request_headers mtrh
685: WHERE wdt.organization_id = p_organization_id
686: AND wdt.person_id = Decode(p_drop_type, g_dt_drop_all,p_emp_id,wdt.person_id)
687: AND wdt.status = 4
688: AND wdt.task_type = 2

Line 2660: ,mtl_txn_request_headers mtrh

2656: FROM dual
2657: WHERE EXISTS (
2658: SELECT mtrl.line_id
2659: FROM mtl_txn_request_lines mtrl
2660: ,mtl_txn_request_headers mtrh
2661: WHERE 1 = 1
2662: AND mtrl.header_id = mtrh.header_id
2663: AND mtrh.move_order_type = 6
2664: AND mtrl.lpn_id = l_lpn_id_tab(i)

Line 3135: ,mtl_txn_request_headers mtrh

3131: SELECT DISTINCT wln2.outermost_lpn_id
3132: FROM wms_dispatched_tasks wdt
3133: ,mtl_txn_request_lines mtrl
3134: ,mtl_material_transactions_temp mmtt
3135: ,mtl_txn_request_headers mtrh
3136: ,wms_license_plate_numbers wln2
3137: WHERE mtrh.header_id = mtrl.header_id
3138: AND mtrh.move_order_type = 6
3139: AND mtrl.line_status = 7

Line 3411: ,mtl_txn_request_headers mtrh

3407: ,mtl_txn_request_lines mtrl
3408: ,wms_dispatched_tasks wdt
3409: --,mtl_item_locations milk
3410: ,mtl_system_items_kfv msik
3411: ,mtl_txn_request_headers mtrh
3412: ,wms_license_plate_numbers wln
3413: --,mtl_secondary_inventories msi
3414: WHERE wdt.organization_id = p_org_id
3415: -- kajain

Line 5828: ,mtl_txn_request_headers mtrh

5824: SELECT mmtt.transaction_temp_id
5825: FROM wms_dispatched_tasks wdt
5826: ,mtl_txn_request_lines mtrl
5827: ,mtl_material_transactions_temp mmtt
5828: ,mtl_txn_request_headers mtrh
5829: WHERE mtrh.header_id = mtrl.header_id
5830: AND mtrh.move_order_type = 6
5831: AND mtrl.line_status = 7
5832: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 5861: ,mtl_txn_request_headers mtrh

5857: SELECT mmtt.transaction_temp_id
5858: FROM wms_dispatched_tasks wdt
5859: ,mtl_txn_request_lines mtrl
5860: ,mtl_material_transactions_temp mmtt
5861: ,mtl_txn_request_headers mtrh
5862: WHERE mtrh.header_id = mtrl.header_id
5863: AND mtrh.move_order_type = 6
5864: AND mtrl.line_status = 7
5865: AND wdt.transaction_temp_id = mmtt.transaction_temp_id

Line 10274: , mtl_txn_request_headers mtrh

10270: , mtrl.inspection_status
10271: , msi.primary_uom_code
10272: FROM mtl_material_transactions_temp mmtt
10273: , mtl_txn_request_lines mtrl
10274: , mtl_txn_request_headers mtrh
10275: , mtl_system_items_kfv msi
10276: , ( /*5723418*/
10277: SELECT wlpn.lpn_id
10278: FROM wms_license_plate_numbers wlpn