eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 22: FROM mtl_unit_transactions mut

18: IS
19: SELECT mut.serial_number serial_number,
20: mut.inventory_item_id item_id,
21: mut.organization_id organization_id
22: FROM mtl_unit_transactions mut
23: WHERE mut.transaction_id = p_mtl_txn_id
24: UNION
25: SELECT mut.serial_number serial_number,
26: mut.inventory_item_id item_id,

Line 29: mtl_unit_transactions mut

25: SELECT mut.serial_number serial_number,
26: mut.inventory_item_id item_id,
27: mut.organization_id organization_id
28: FROM mtl_transaction_lot_numbers mtln,
29: mtl_unit_transactions mut
30: WHERE mtln.transaction_id = p_mtl_txn_id
31: AND mut.transaction_id = mtln.serial_transaction_id;
32:
33: CURSOR all_txn_cur(

Line 54: FROM mtl_unit_transactions mut,

50: mmt.transfer_transaction_id mtl_xfer_txn_id,
51: mmt.revision mtl_revision,
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

Line 79: FROM mtl_unit_transactions mut,

75: mmt.transfer_transaction_id mtl_xfer_txn_id,
76: mmt.revision mtl_revision,
77: mtln.lot_number lot_number,
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

Line 260: mtl_unit_transactions mut

256: IS
257: CURSOR lot_cur(cp_mtl_txn_id IN number, cp_serial_number IN varchar2) IS
258: SELECT mtln.lot_number
259: FROM mtl_transaction_lot_numbers mtln,
260: mtl_unit_transactions mut
261: WHERE mtln.transaction_id = cp_mtl_txn_id
262: AND mut.transaction_id = mtln.serial_transaction_id
263: AND mut.serial_number = cp_serial_number;
264: BEGIN

Line 8719: FROM mtl_unit_transactions mut,

8715: SELECT mmt.creation_date mtl_creation_date,
8716: mut.transaction_id mtl_txn_id,
8717: mut.transaction_date mtl_txn_date,
8718: mmt.trx_source_line_id rma_line_id
8719: FROM mtl_unit_transactions mut,
8720: mtl_material_transactions mmt
8721: WHERE mut.serial_number = p_serial
8722: AND mut.inventory_item_id = p_item_id
8723: AND mut.transaction_date > p_freeze_date

Line 8731: FROM mtl_unit_transactions mut,

8727: SELECT mmt.creation_date mtl_creation_date,
8728: mtln.transaction_id mtl_txn_id,
8729: mtln.transaction_date mtl_txn_date,
8730: mmt.trx_source_line_id rma_line_id
8731: FROM mtl_unit_transactions mut,
8732: mtl_transaction_lot_numbers mtln,
8733: mtl_material_transactions mmt
8734: WHERE mut.serial_number = p_serial
8735: AND mut.inventory_item_id = p_item_id

Line 9545: from MTL_UNIT_TRANSACTIONS

9541: select mmt.subinventory_code,mmt.locator_id,mmt.organization_id,mmt.revision
9542: into v_subinv,v_locator_id,v_org_id,v_revision
9543: from MTL_MATERIAL_TRANSACTIONS mmt
9544: where mmt.transaction_id = (select max(transaction_id)
9545: from MTL_UNIT_TRANSACTIONS
9546: where serial_number = csi_rec.serial_number
9547: and inventory_item_id = csi_rec.inventory_item_id
9548: and last_update_date <= csi_rec.last_update_date);
9549: Exception