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
566: AND mmt.transaction_id = mut.transaction_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
597: AND mmt.subinventory_code = msi.secondary_inventory_name