DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 1379: mtl_transaction_lot_numbers mtln

1375:
1376: select count(*)
1377: into l_rows
1378: from rcv_shipment_lines rsl, rcv_transactions rt,
1379: mtl_transaction_lot_numbers mtln
1380: where rsl.shipment_line_id = rt.shipment_line_id
1381: and rt.transaction_type = 'RECEIVE'
1382: and rt.transaction_id = mtln.PRODUCT_TRANSACTION_ID
1383: and mtln.PRODUCT_CODE = 'RCV'