557: mtln.primary_quantity lot_primary_quantity,
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
588: mtln.primary_quantity lot_primary_quantity,
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
619: mtln.primary_quantity lot_primary_quantity,
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