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_PUB dependencies on CSI_ITEM_INSTANCES

Line 87: FROM csi_item_instances

83: -- End Add Code for Siebel Genesis Project
84: -- end addition
85: CURSOR instance_csr (p_ins_id IN NUMBER) IS
86: SELECT *
87: FROM csi_item_instances
88: WHERE instance_id = p_ins_id;
89: l_instance_csr instance_csr%ROWTYPE;
90:
91:

Line 108: FROM csi_item_instances

104: CURSOR instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
105: SELECT instance_id
106: ,object_version_number
107: ,config_valid_status
108: FROM csi_item_instances
109: WHERE config_inst_hdr_id=p_config_inst_hdr_id
110: AND config_inst_item_id=p_config_inst_item_id;
111:
112: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is

Line 127: FROM csi_item_instances

123: CURSOR new_instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
124: SELECT instance_id
125: ,object_version_number
126: ,config_valid_status
127: FROM csi_item_instances
128: WHERE config_inst_hdr_id=p_config_inst_hdr_id
129: AND config_inst_item_id=p_config_inst_item_id;
130:
131: l_config_instance_rec csi_datastructures_pub.instance_rec ;

Line 1043: FROM csi_item_instances_h

1039: --for the same instance_id
1040: BEGIN
1041: SELECT 'Y'
1042: INTO l_create_event_called
1043: FROM csi_item_instances_h
1044: WHERE instance_id = p_instance_rec.instance_id
1045: AND new_accounting_class_code = 'CUST_PROD'
1046: AND transaction_id <> p_txn_rec.transaction_id
1047: AND ROWNUM = 1;

Line 1329: FROM csi_item_instances

1325: -- End Add Code for Siebel Genesis Project
1326: -- end addition
1327: CURSOR instance_csr (p_ins_id IN NUMBER) IS
1328: SELECT *
1329: FROM csi_item_instances
1330: WHERE instance_id = p_ins_id;
1331: l_instance_csr instance_csr%ROWTYPE;
1332:
1333: CURSOR old_ins_csr (p_ins_id IN NUMBER) IS

Line 1335: FROM csi_item_instances

1331: l_instance_csr instance_csr%ROWTYPE;
1332:
1333: CURSOR old_ins_csr (p_ins_id IN NUMBER) IS
1334: SELECT *
1335: FROM csi_item_instances
1336: WHERE instance_id=p_ins_id;
1337:
1338: l_old_ins_csr old_ins_csr%ROWTYPE;
1339: -- Start of defining variables for bug 2172968

Line 1372: FROM csi_item_instances

1368: CURSOR instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
1369: SELECT instance_id
1370: ,object_version_number
1371: ,config_valid_status
1372: FROM csi_item_instances
1373: WHERE config_inst_hdr_id=p_config_inst_hdr_id
1374: AND config_inst_item_id=p_config_inst_item_id;
1375:
1376: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is

Line 1391: FROM csi_item_instances

1387: CURSOR new_instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
1388: SELECT instance_id
1389: ,object_version_number
1390: ,config_valid_status
1391: FROM csi_item_instances
1392: WHERE config_inst_hdr_id=p_config_inst_hdr_id
1393: AND config_inst_item_id=p_config_inst_item_id;
1394: ------------------------------------------added-----------
1395: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS

Line 1537: FROM csi_item_instances_h

1533: IF l_inst_id is not null THEN
1534: csi_gen_utility_pvt.put_line('l_inst_id is not null');
1535: SELECT 'Y'
1536: INTO l_create_event_called
1537: FROM csi_item_instances_h
1538: WHERE instance_id = l_inst_id
1539: AND new_accounting_class_code = 'CUST_PROD'
1540: AND ROWNUM = 1;
1541: ELSE

Line 1544: FROM csi_item_instances_h

1540: AND ROWNUM = 1;
1541: ELSE
1542: SELECT 'Y'
1543: INTO l_create_event_called
1544: FROM csi_item_instances_h
1545: WHERE instance_id = p_instance_rec.instance_id
1546: AND new_accounting_class_code = 'CUST_PROD'
1547: AND ROWNUM = 1;
1548: END IF;

Line 2965: FROM csi_item_instances

2961: l_instance_rec.call_contracts := l_new_instance_rec.call_contracts; -- added for avoiding multiple OKS calls
2962: BEGIN
2963: SELECT object_version_number
2964: INTO l_instance_rec.object_version_number
2965: FROM csi_item_instances
2966: WHERE instance_id=p_instance_rec.instance_id;
2967: EXCEPTION
2968: WHEN NO_DATA_FOUND THEN
2969: NULL;

Line 3019: FROM csi_item_instances

3015: THEN
3016: BEGIN
3017: SELECT active_end_date
3018: INTO l_active_end_date
3019: FROM csi_item_instances
3020: WHERE instance_id = p_instance_rec.instance_id;
3021: EXCEPTION
3022: WHEN OTHERS THEN
3023: NULL;

Line 3375: FROM csi_item_instances

3371:
3372: BEGIN
3373: SELECT source_code, owner_party_id
3374: INTO l_source_code, l_owner_party_id
3375: FROM csi_item_instances
3376: WHERE instance_id = l_instance_id;
3377: EXCEPTION
3378: WHEN OTHERS THEN NULL;
3379: END;

Line 3535: FROM csi_item_instances

3531: CURSOR instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
3532: SELECT instance_id
3533: ,object_version_number
3534: ,config_valid_status
3535: FROM csi_item_instances
3536: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3537: AND config_inst_item_id=p_config_inst_item_id;
3538:
3539: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is

Line 3554: FROM csi_item_instances

3550: CURSOR new_instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
3551: SELECT instance_id
3552: ,object_version_number
3553: ,config_valid_status
3554: FROM csi_item_instances
3555: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3556: AND config_inst_item_id=p_config_inst_item_id;
3557:
3558: l_config_instance_rec csi_datastructures_pub.instance_rec ;

Line 4492: 'from csi_item_instances where instance_id = :instance_id ';

4488: -- Addition of columns for FA Integration
4489: 'purchase_unit_price, purchase_currency_code, payables_unit_price, payables_currency_code, '||
4490: 'sales_unit_price, sales_currency_code, operational_status_code '||
4491: -- End addition of columns for FA Integration
4492: 'from csi_item_instances where instance_id = :instance_id ';
4493: l_last_purge_date DATE;
4494: l_time_stamp DATE;
4495:
4496: BEGIN

Line 4578: -- Get the last purge date from csi_item_instances table

4574: -- Close the cursor
4575: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4576:
4577: --
4578: -- Get the last purge date from csi_item_instances table
4579: --
4580: BEGIN
4581: SELECT last_purge_date
4582: INTO l_last_purge_date

Line 4583: FROM CSI_ITEM_INSTANCES

4579: --
4580: BEGIN
4581: SELECT last_purge_date
4582: INTO l_last_purge_date
4583: FROM CSI_ITEM_INSTANCES
4584: WHERE instance_id = p_instance_rec.instance_id;
4585: EXCEPTION
4586: WHEN no_data_found THEN
4587: null;

Line 5709: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)

5705: FROM csi_i_extended_attribs iea
5706: WHERE attribute_level = 'INSTANCE'
5707: AND instance_id = p_instance_id
5708: UNION ALL
5709: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5710: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5711: */ -- Added by sguthiva for bug 2367664
5712: iea.attribute_id attribute_id
5713: ,iea.attribute_level attribute_level

Line 5741: FROM csi_i_extended_attribs iea, csi_item_instances ia

5737: ,iea.attribute13 attribute13
5738: ,iea.attribute14 attribute14
5739: ,iea.attribute15 attribute15
5740: ,iea.object_version_number object_version_number
5741: FROM csi_i_extended_attribs iea, csi_item_instances ia
5742: WHERE iea.attribute_level = 'ITEM'
5743: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5744: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5745: AND ia.instance_id = p_instance_id

Line 5747: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)

5743: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5744: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5745: AND ia.instance_id = p_instance_id
5746: UNION ALL
5747: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5748: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5749: INDEX(ic MTL_ITEM_CATEGORIES_U1)
5750: */ -- Added by sguthiva for bug 2367664
5751: iea.attribute_id attribute_id

Line 5781: ,csi_item_instances ia

5777: ,iea.attribute14 attribute14
5778: ,iea.attribute15 attribute15
5779: ,iea.object_version_number object_version_number
5780: FROM csi_i_extended_attribs iea
5781: ,csi_item_instances ia
5782: ,mtl_item_categories ic
5783: WHERE iea.attribute_level = 'CATEGORY'
5784: -- AND iea.inventory_item_id = ia.inventory_item_id -- commented for Bug # 3189494
5785: -- AND iea.master_organization_id = ia.inv_master_organization_id -- commented for Bug # 3189494

Line 6825: FROM csi_item_instances

6821: ) IS
6822:
6823: CURSOR old_instance_rec ( cp_instance_id NUMBER) is
6824: SELECT quantity, install_date, active_end_date
6825: FROM csi_item_instances
6826: WHERE instance_id = cp_instance_id;
6827:
6828: l_curr_instance_rec old_instance_rec%ROWTYPE;
6829: l_row_index NUMBER := 0;