[Home] [Help]
APPS.POS_ASN_CREATE_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS
Line 1378: mtl_transaction_lot_numbers mtln
1374:
1375: select count(*)
1376: into l_rows
1377: from rcv_shipment_lines rsl, rcv_transactions rt,
1378: mtl_transaction_lot_numbers mtln
1379: where rsl.shipment_line_id = rt.shipment_line_id
1380: and rt.transaction_type = 'RECEIVE'
1381: and rt.transaction_id = mtln.PRODUCT_TRANSACTION_ID
1382: and mtln.PRODUCT_CODE = 'RCV'