APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 5043: from MTL_MATERIAL_TRANSACTIONS

5039: IF l_cur_mtl_txn_id <> FND_API.G_MISS_NUM THEN
5040: Begin
5041: select creation_date
5042: into l_cur_mtl_txn_date
5043: from MTL_MATERIAL_TRANSACTIONS
5044: where transaction_id = l_cur_mtl_txn_id;
5045: Exception
5046: when no_data_found then
5047: l_cur_mtl_txn_date := sysdate;

Line 5149: FROM mtl_material_transactions

5145: AND l_err_mtl_txn_id <> l_cur_mtl_txn_id THEN -- The errorred transaction is not the transaction currently being reprocessed
5146: BEGIN
5147: SELECT creation_date
5148: INTO l_err_mtl_txn_date
5149: FROM mtl_material_transactions
5150: WHERE transaction_id = l_err_mtl_txn_id;
5151: EXCEPTION
5152: WHEN NO_DATA_FOUND THEN
5153: NULL;

Line 5276: from MTL_MATERIAL_TRANSACTIONS

5272: IF l_mtl_txn_id <> fnd_api.g_miss_num THEN
5273: Begin
5274: select creation_date
5275: into l_mtl_txn_cr_date
5276: from MTL_MATERIAL_TRANSACTIONS
5277: where transaction_id = l_mtl_txn_id;
5278: Exception
5279: when no_data_found then
5280: l_mtl_txn_cr_date := sysdate;

Line 5937: mtl_material_transactions mmt

5933: --
5934: CURSOR ALL_TXN_CUR(p_item_id IN NUMBER,p_srl_num IN VARCHAR2,p_curr_txn_id IN NUMBER) IS
5935: select '1'
5936: FROM mtl_unit_transactions mut,
5937: mtl_material_transactions mmt
5938: WHERE mut.inventory_item_id = p_item_id
5939: AND mut.serial_number = p_srl_num
5940: AND mmt.transaction_id = mut.transaction_id
5941: AND mmt.transaction_id <> p_curr_txn_id

Line 5947: mtl_material_transactions mmt

5943: UNION --uncommented code for 6965008
5944: select '1'
5945: FROM mtl_unit_transactions mut,
5946: mtl_transaction_lot_numbers mtln,
5947: mtl_material_transactions mmt
5948: WHERE mut.inventory_item_id = p_item_id
5949: AND mut.serial_number = p_srl_num
5950: AND mtln.organization_id = mut.organization_id
5951: AND mtln.serial_transaction_id = mut.transaction_id

Line 6229: FROM mtl_material_transactions

6225: l_mtl_txn_tbl(l_ind).transaction_uom,
6226: l_mtl_txn_tbl(l_ind).primary_quantity,
6227: l_mtl_txn_tbl(l_ind).transaction_source_id,
6228: l_mtl_txn_tbl(l_ind).trx_source_line_id
6229: FROM mtl_material_transactions
6230: WHERE transaction_id = l_mtl_txn_id;
6231:
6232: l_mtl_txn_tbl(l_ind).serial_control_code := unit_txn_rec.serial_number_control_code;
6233: l_mtl_txn_tbl(l_ind).lot_control_code := unit_txn_rec.lot_control_code;