APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_TRANSACTION_TYPES

Line 56: mtl_transaction_types mtt

52: to_char(null) lot_number,
53: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
54: FROM mtl_unit_transactions mut,
55: mtl_material_transactions mmt,
56: mtl_transaction_types mtt
57: WHERE mut.serial_number = p_serial_number
58: AND mut.inventory_item_id = p_item_id
59: AND mmt.transaction_id = mut.transaction_id
60: AND mtt.transaction_type_id = mmt.transaction_type_id

Line 82: mtl_transaction_types mtt

78: to_char(mmt.transaction_date,'dd-mm-yy hh24:mi:ss') mtl_txn_char_date
79: FROM mtl_unit_transactions mut,
80: mtl_transaction_lot_numbers mtln,
81: mtl_material_transactions mmt,
82: mtl_transaction_types mtt
83: WHERE mut.serial_number = p_serial_number
84: AND mut.inventory_item_id = p_item_id
85: AND mtln.organization_id = mut.organization_id
86: AND mtln.transaction_date = mut.transaction_date

Line 3341: mtl_transaction_types mtt

3337: l_mtl_source_type_id,
3338: l_mtl_type_class,
3339: l_mtl_txn_qty
3340: FROM mtl_material_transactions mmt,
3341: mtl_transaction_types mtt
3342: WHERE mmt.transaction_id = q_rec.source_id
3343: AND mtt.transaction_type_id = mmt.transaction_type_id;
3344:
3345: EXCEPTION

Line 3389: mtl_transaction_types mtt,

3385: mmt.transaction_type_id mtl_type_id,
3386: mtt.type_class mtl_type_class,
3387: mmt.transaction_quantity mtl_txn_qty
3388: FROM mtl_system_items msi,
3389: mtl_transaction_types mtt,
3390: mtl_material_transactions mmt
3391: WHERE mmt.transaction_source_type_id = 5
3392: AND mmt.transaction_action_id IN (1, 27, 31, 32, 33, 34)
3393: AND mmt.transaction_date > p_freeze_date

Line 15713: mtl_transaction_types mtt

15709: l_mtl_source_type_id,
15710: l_mtl_type_class,
15711: l_mtl_txn_qty
15712: FROM mtl_material_transactions mmt,
15713: mtl_transaction_types mtt
15714: WHERE mmt.transaction_id = err_rec.inv_material_transaction_id
15715: AND mtt.transaction_type_id = mmt.transaction_type_id;
15716:
15717: get_source_type(