DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_TXN_REQUEST_HEADERS

Line 914: FROM mtl_txn_request_headers mtrh,

910: */
911: --Resolve move_order_type from l_transaction_temp_id
912: SELECT mtrh.move_order_type
913: INTO l_move_order_type
914: FROM mtl_txn_request_headers mtrh,
915: mtl_txn_request_lines mtrl,
916: mtl_material_transactions_temp mmtt
917: WHERE mmtt.move_order_line_id = mtrl.line_id
918: AND mtrl.header_id = mtrh.header_id

Line 1365: , mtl_txn_request_headers mtrh

1361: , inv_globals.g_move_order_mfg_pick, 'MFG'
1362: , 'OTHERS')
1363: FROM mtl_material_transactions_temp mmtt
1364: , mtl_txn_request_lines mtrl
1365: , mtl_txn_request_headers mtrh
1366: WHERE mmtt.organization_id = p_org_id
1367: AND mmtt.transfer_lpn_id = p_lpn_id
1368: AND mtrl.line_id = mmtt.move_order_line_id
1369: AND mtrh.header_id = mtrl.header_id