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
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