APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 5103: mtl_material_transactions mmt,

5099: mmt.transaction_source_id,
5100: mmt.trx_source_line_id,
5101: NULL lot_number
5102: FROM mtl_unit_transactions mut,
5103: mtl_material_transactions mmt,
5104: mtl_system_items msi
5105: WHERE mut.serial_number = p_serial_number
5106: AND mut.inventory_item_id = p_inventory_item_id
5107: AND mmt.transaction_id = mut.transaction_id

Line 5135: mtl_material_transactions mmt,

5131: mmt.trx_source_line_id,
5132: mtln.lot_number
5133: FROM mtl_unit_transactions mut,
5134: mtl_transaction_lot_numbers mtln,
5135: mtl_material_transactions mmt,
5136: mtl_system_items msi
5137: WHERE mut.serial_number = p_serial_number
5138: AND mut.inventory_item_id = p_inventory_item_id
5139: AND mtln.organization_id = mut.organization_id

Line 5214: from MTL_MATERIAL_TRANSACTIONS

5210: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5211: Begin
5212: select creation_date
5213: into l_cur_mtl_txn_date
5214: from MTL_MATERIAL_TRANSACTIONS
5215: where transaction_id = l_cur_mtl_txn_id;
5216: Exception
5217: when no_data_found then
5218: l_cur_mtl_txn_date := sysdate;

Line 5392: FROM mtl_material_transactions

5388: AND l_err_mtl_txn_id <> l_cur_mtl_txn_id THEN -- The errorred transaction is not the transaction currently being reprocessed
5389: BEGIN
5390: SELECT creation_date
5391: INTO l_err_mtl_txn_date
5392: FROM mtl_material_transactions
5393: WHERE transaction_id = l_err_mtl_txn_id;
5394: EXCEPTION
5395: WHEN NO_DATA_FOUND THEN
5396: NULL;

Line 5529: from MTL_MATERIAL_TRANSACTIONS

5525: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5526: Begin
5527: select creation_date
5528: into l_mtl_txn_cr_date
5529: from MTL_MATERIAL_TRANSACTIONS
5530: where transaction_id = l_mtl_txn_id;
5531: Exception
5532: when no_data_found then
5533: l_mtl_txn_cr_date := sysdate;

Line 6221: mtl_material_transactions mmt

6217: --
6218: CURSOR ALL_TXN_CUR(p_item_id IN NUMBER,p_srl_num IN VARCHAR2,p_curr_txn_id IN NUMBER) IS
6219: select '1'
6220: FROM mtl_unit_transactions mut,
6221: mtl_material_transactions mmt
6222: WHERE mut.inventory_item_id = p_item_id
6223: AND mut.serial_number = p_srl_num
6224: AND mmt.transaction_id = mut.transaction_id
6225: AND mmt.transaction_id <> p_curr_txn_id

Line 6231: mtl_material_transactions mmt

6227: UNION --uncommented code for 6965008
6228: select '1'
6229: FROM mtl_unit_transactions mut,
6230: mtl_transaction_lot_numbers mtln,
6231: mtl_material_transactions mmt
6232: WHERE mut.inventory_item_id = p_item_id
6233: AND mut.serial_number = p_srl_num
6234: AND mtln.organization_id = mut.organization_id
6235: AND mtln.serial_transaction_id = mut.transaction_id

Line 6517: FROM mtl_material_transactions

6513: l_mtl_txn_tbl(l_ind).transaction_uom,
6514: l_mtl_txn_tbl(l_ind).primary_quantity,
6515: l_mtl_txn_tbl(l_ind).transaction_source_id,
6516: l_mtl_txn_tbl(l_ind).trx_source_line_id
6517: FROM mtl_material_transactions
6518: WHERE transaction_id = l_mtl_txn_id;
6519: -- Added for bug 8549651 (FP of 8507649)
6520: EXCEPTION
6521: WHEN NO_DATA_FOUND THEN