DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on MTL_TXN_REQUEST_HEADERS

Line 1131: FROM mtl_txn_request_headers mtrh,

1127: */
1128: --Resolve move_order_type from l_transaction_temp_id
1129: SELECT mtrh.move_order_type
1130: INTO l_move_order_type
1131: FROM mtl_txn_request_headers mtrh,
1132: mtl_txn_request_lines mtrl,
1133: mtl_material_transactions_temp mmtt
1134: WHERE mmtt.move_order_line_id = mtrl.line_id
1135: AND mtrl.header_id = mtrh.header_id

Line 1625: , mtl_txn_request_headers mtrh

1621: , inv_globals.g_move_order_mfg_pick, 'MFG'
1622: , 'OTHERS')
1623: FROM mtl_material_transactions_temp mmtt
1624: , mtl_txn_request_lines mtrl
1625: , mtl_txn_request_headers mtrh
1626: WHERE mmtt.organization_id = p_org_id
1627: AND mmtt.transfer_lpn_id = p_lpn_id
1628: AND mtrl.line_id = mmtt.move_order_line_id
1629: AND mtrh.header_id = mtrl.header_id