DBA Data[Home] [Help]

APPS.CSI_INV_DISCREPANCY_PKG dependencies on MTL_TRANSACTION_TYPES

Line 625: mtl_transaction_types mtt

621: to_char(null) lot_number,
622: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
623: FROM mtl_unit_transactions mut,
624: mtl_material_transactions mmt,
625: mtl_transaction_types mtt
626: WHERE p_lot_code = g_no_lot
627: AND mut.serial_number = p_serial_number
628: AND mut.inventory_item_id = p_item_id
629: AND mmt.transaction_id = mut.transaction_id

Line 651: mtl_transaction_types mtt

647: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
648: FROM mtl_unit_transactions mut,
649: mtl_transaction_lot_numbers mtln,
650: mtl_material_transactions mmt,
651: mtl_transaction_types mtt
652: WHERE p_lot_code = g_lot
653: AND mut.serial_number = p_serial_number
654: AND mut.inventory_item_id = p_item_id
655: AND mtln.serial_transaction_id = mut.transaction_id