DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 562: mtl_transaction_lot_numbers mtln,

558: mmt.trx_source_line_id oe_line_id,
559: mmt.transaction_type_id transaction_type_id,
560: mmt.creation_date creation_date -- bug 4026148
561: FROM hr_all_organization_units haou,
562: mtl_transaction_lot_numbers mtln,
563: mtl_unit_transactions mut,
564: mtl_secondary_inventories msi,
565: mtl_material_transactions mmt
566: WHERE mmt.transaction_id = p_mtl_txn_id

Line 593: mtl_transaction_lot_numbers mtln,

589: mmt.trx_source_line_id oe_line_id,
590: mmt.transaction_type_id transaction_type_id,
591: mmt.creation_date creation_date -- bug 4026148
592: FROM hr_all_organization_units haou,
593: mtl_transaction_lot_numbers mtln,
594: mtl_unit_transactions mut,
595: mtl_secondary_inventories msi,
596: mtl_material_transactions mmt
597: WHERE mmt.transaction_id = p_mtl_txn_id

Line 624: mtl_transaction_lot_numbers mtln,

620: mmt.trx_source_line_id oe_line_id,
621: mmt.transaction_type_id transaction_type_id,
622: mmt.creation_date creation_date -- bug 4026148
623: FROM hr_all_organization_units haou,
624: mtl_transaction_lot_numbers mtln,
625: mtl_secondary_inventories msi,
626: mtl_material_transactions mmt
627: WHERE mmt.transaction_id = p_mtl_txn_id
628: AND mmt.transaction_id = mtln.transaction_id(+)