APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_TRANSACTIONS

Line 5112: (SELECT 1 FROM csi_transactions

5108: AND msi.inventory_item_id = mut.inventory_item_id
5109: AND msi.organization_id = mmt.organization_id
5110: AND msi.comms_nl_trackable_flag = 'Y'
5111: AND NOT EXISTS
5112: (SELECT 1 FROM csi_transactions
5113: WHERE inv_material_transaction_id = mmt.transaction_id)
5114: UNION ALL
5115: SELECT mut.transaction_id,
5116: msi.lot_control_code,

Line 5146: (SELECT 1 FROM csi_transactions

5142: AND mmt.transaction_id = mtln.transaction_id
5143: AND msi.inventory_item_id = mut.inventory_item_id
5144: AND msi.comms_nl_trackable_flag = 'Y'
5145: AND NOT EXISTS
5146: (SELECT 1 FROM csi_transactions
5147: WHERE inv_material_transaction_id = mmt.transaction_id)
5148: ORDER BY 1 desc, 2 desc;
5149:
5150: l_ind binary_integer := 0;

Line 5247: from csi_transactions

5243: IF l_min_txn_id IS NOT NULL THEN
5244: Begin
5245: select source_transaction_date
5246: into l_src_txn_date
5247: from csi_transactions
5248: where transaction_id = l_min_txn_id;
5249: Exception
5250: when no_data_found then
5251: null;

Line 5264: select /*+ leading(CSI_INST_TRANSACTIONS_V.cii,CSI_INST_TRANSACTIONS_V.v) index(csi_inst_transactions_v.t CSI_TRANSACTIONS_U01) */ min(inv_material_transaction_id) INTO l_min_inv_mtl_txn_id

5260: -- Code added for bug 9198245, FP of bug 7294792 - Start
5261: BEGIN
5262: --Changed for Bug 13859378
5263: --Changed for Bug 15881410
5264: select /*+ leading(CSI_INST_TRANSACTIONS_V.cii,CSI_INST_TRANSACTIONS_V.v) index(csi_inst_transactions_v.t CSI_TRANSACTIONS_U01) */ min(inv_material_transaction_id) INTO l_min_inv_mtl_txn_id
5265: from CSI_INST_TRANSACTIONS_V
5266: where instance_id=p_instance_rec.instance_id
5267: AND inv_material_transaction_id is not NULL;
5268:

Line 5271: select /*+ leading(CSI_INST_TRANSACTIONS_V.cii,CSI_INST_TRANSACTIONS_V.v) index(csi_inst_transactions_v.t CSI_TRANSACTIONS_U01) */ max(inv_material_transaction_id) INTO l_max_inv_mtl_txn_id

5267: AND inv_material_transaction_id is not NULL;
5268:
5269: --Changed for Bug 13859378
5270: --Changed for Bug 15881410
5271: select /*+ leading(CSI_INST_TRANSACTIONS_V.cii,CSI_INST_TRANSACTIONS_V.v) index(csi_inst_transactions_v.t CSI_TRANSACTIONS_U01) */ max(inv_material_transaction_id) INTO l_max_inv_mtl_txn_id
5272: from CSI_INST_TRANSACTIONS_V
5273: where instance_id=p_instance_rec.instance_id
5274: AND inv_material_transaction_id is not NULL;
5275:

Line 5427: FROM csi_transactions

5423: AND l_min_inv_mtl_txn_id 5424: THEN
5425: SELECT 'Y'
5426: INTO l_txn_found
5427: FROM csi_transactions
5428: WHERE inv_material_transaction_id in (l_mtl_txn_tbl(l_ind).transaction_id, l_xfer_mtl_txn_id)
5429: AND rownum = 1;
5430:
5431: end if;