APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 28: FROM mtl_transaction_lot_numbers mtln,

24: UNION
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:

Line 80: mtl_transaction_lot_numbers mtln,

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
84: AND mut.inventory_item_id = p_item_id

Line 141: mtl_transaction_lot_numbers mtln

137: mmt.transaction_date mtl_txn_date,
138: mmt.transaction_id mtl_txn_id,
139: mmt.trx_source_line_id trx_source_line_id
140: FROM mtl_material_transactions mmt,
141: mtl_transaction_lot_numbers mtln
142: WHERE (mmt.transaction_id = p_mtl_txn_id
143: OR
144: mmt.transaction_id = p_mtl_xfer_txn_id)
145: AND mmt.transaction_quantity < 0

Line 259: FROM mtl_transaction_lot_numbers mtln,

255: x_lot_number OUT nocopy varchar2)
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;

Line 6497: mtl_transaction_lot_numbers mtln

6493: mmt.transaction_date mtl_txn_date,
6494: mmt.transaction_id mtl_txn_id,
6495: mmt.trx_source_line_id trx_source_line_id
6496: FROM mtl_material_transactions mmt,
6497: mtl_transaction_lot_numbers mtln
6498: WHERE mmt.transaction_id = p_mtl_txn_id
6499: AND mtln.transaction_id = mmt.transaction_id
6500: AND p_lot_code <> 1;
6501:

Line 8161: mtl_transaction_lot_numbers mtln

8157: mmt.transaction_date mtl_txn_date,
8158: mmt.transaction_id mtl_txn_id,
8159: mmt.trx_source_line_id trx_source_line_id
8160: FROM mtl_material_transactions mmt,
8161: mtl_transaction_lot_numbers mtln
8162: WHERE mmt.transaction_id = p_mtl_txn_id
8163: AND mtln.transaction_id = mmt.transaction_id
8164: AND p_lot_code <> 1;
8165:

Line 8732: mtl_transaction_lot_numbers mtln,

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
8736: AND mtln.serial_transaction_id = mut.transaction_id

Line 12175: from mtl_transaction_lot_numbers

12171: and cii.inv_material_transaction_id is not null;
12172: --
12173: CURSOR LOT_CUR(p_txn_id in number) IS
12174: select lot_number,ABS(primary_quantity) transaction_quantity
12175: from mtl_transaction_lot_numbers
12176: where transaction_id = p_txn_id;
12177: --
12178: v_txn_id NUMBER;
12179: l_upg_profile VARCHAR2(30) := fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE');

Line 15004: FROM mtl_transaction_lot_numbers

15000:
15001: --
15002: CURSOR lot_cur(p_txn_id in number) IS
15003: SELECT lot_number,transaction_quantity
15004: FROM mtl_transaction_lot_numbers
15005: WHERE transaction_id = p_txn_id;
15006:
15007: --
15008: CURSOR csi_cur(