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_ITEM_INSTANCE_VLD_PVT dependencies on CSI_INST_TRANSACTIONS_V

Line 3802: FROM csi_inst_transactions_v

3798: ELSIF p_end_date < sysdate THEN -- srramakr
3799: BEGIN
3800: SELECT MAX(source_transaction_date)
3801: INTO l_txn_date
3802: FROM csi_inst_transactions_v
3803: WHERE instance_id=p_instance_id
3804: AND transaction_id <> p_transaction_id -- Bug 9081875
3805: AND source_transaction_date>p_end_date;
3806: csi_gen_utility_pvt.put_line('value of end date in ITEM_VLD_PVT after check for p_end_date < sysdate:'||to_char(p_end_date, 'DD-MON-YYYY HH24:MI:SS'));

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 5265: from CSI_INST_TRANSACTIONS_V

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:
5269: --Changed for Bug 13859378

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 5272: from CSI_INST_TRANSACTIONS_V

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:
5276: