DBA Data[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'