DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on RCV_SHIPMENT_LINES

Line 2344: rcv_shipment_lines rsl

2340: into l_default_status_id from
2341: (SELECT mtln.transaction_id, mtln.status_id
2342: FROM mtl_transaction_lot_numbers mtln,
2343: mtl_material_transactions mmt,
2344: rcv_shipment_lines rsl
2345: WHERE mmt.transaction_id = mtln.transaction_id
2346: AND mtln.inventory_item_id = p_inventory_item_id
2347: AND mmt.inventory_item_id = p_inventory_item_id
2348: AND rsl.shipment_line_id = p_txn_source_id