DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 561: mtl_transaction_lot_numbers mtln,

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

Line 592: mtl_transaction_lot_numbers mtln,

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

Line 623: mtl_transaction_lot_numbers mtln,

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