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 86: FROM csi_item_instances

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

Line 107: FROM csi_item_instances

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

Line 126: FROM csi_item_instances

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

Line 1309: FROM csi_item_instances

1305: -- End Add Code for Siebel Genesis Project
1306: -- end addition
1307: CURSOR instance_csr (p_ins_id IN NUMBER) IS
1308: SELECT *
1309: FROM csi_item_instances
1310: WHERE instance_id = p_ins_id;
1311: l_instance_csr instance_csr%ROWTYPE;
1312:
1313: CURSOR old_ins_csr (p_ins_id IN NUMBER) IS

Line 1315: FROM csi_item_instances

1311: l_instance_csr instance_csr%ROWTYPE;
1312:
1313: CURSOR old_ins_csr (p_ins_id IN NUMBER) IS
1314: SELECT *
1315: FROM csi_item_instances
1316: WHERE instance_id=p_ins_id;
1317:
1318: l_old_ins_csr old_ins_csr%ROWTYPE;
1319: -- Start of defining variables for bug 2172968

Line 1352: FROM csi_item_instances

1348: CURSOR instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
1349: SELECT instance_id
1350: ,object_version_number
1351: ,config_valid_status
1352: FROM csi_item_instances
1353: WHERE config_inst_hdr_id=p_config_inst_hdr_id
1354: AND config_inst_item_id=p_config_inst_item_id;
1355:
1356: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is

Line 1371: FROM csi_item_instances

1367: CURSOR new_instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
1368: SELECT instance_id
1369: ,object_version_number
1370: ,config_valid_status
1371: FROM csi_item_instances
1372: WHERE config_inst_hdr_id=p_config_inst_hdr_id
1373: AND config_inst_item_id=p_config_inst_item_id;
1374: ------------------------------------------added-----------
1375: CURSOR non_owner_csr (p_ins_pty_id NUMBER) IS

Line 2882: FROM csi_item_instances

2878: l_instance_rec.call_contracts := l_new_instance_rec.call_contracts; -- added for avoiding multiple OKS calls
2879: BEGIN
2880: SELECT object_version_number
2881: INTO l_instance_rec.object_version_number
2882: FROM csi_item_instances
2883: WHERE instance_id=p_instance_rec.instance_id;
2884: EXCEPTION
2885: WHEN NO_DATA_FOUND THEN
2886: NULL;

Line 2936: FROM csi_item_instances

2932: THEN
2933: BEGIN
2934: SELECT active_end_date
2935: INTO l_active_end_date
2936: FROM csi_item_instances
2937: WHERE instance_id = p_instance_rec.instance_id;
2938: EXCEPTION
2939: WHEN OTHERS THEN
2940: NULL;

Line 3267: FROM csi_item_instances

3263:
3264: BEGIN
3265: SELECT source_code, owner_party_id
3266: INTO l_source_code, l_owner_party_id
3267: FROM csi_item_instances
3268: WHERE instance_id = l_instance_id;
3269: EXCEPTION
3270: WHEN OTHERS THEN NULL;
3271: END;

Line 3498: FROM csi_item_instances

3494: CURSOR instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
3495: SELECT instance_id
3496: ,object_version_number
3497: ,config_valid_status
3498: FROM csi_item_instances
3499: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3500: AND config_inst_item_id=p_config_inst_item_id;
3501:
3502: CURSOR new_config_ins_key (p_config_ins_hdr_id NUMBER, p_config_ins_rev_nbr NUMBER) is

Line 3517: FROM csi_item_instances

3513: CURSOR new_instance_key (p_config_inst_hdr_id NUMBER, p_config_inst_item_id NUMBER)is
3514: SELECT instance_id
3515: ,object_version_number
3516: ,config_valid_status
3517: FROM csi_item_instances
3518: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3519: AND config_inst_item_id=p_config_inst_item_id;
3520:
3521: l_config_instance_rec csi_datastructures_pub.instance_rec ;

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

4442: -- Addition of columns for FA Integration
4443: 'purchase_unit_price, purchase_currency_code, payables_unit_price, payables_currency_code, '||
4444: 'sales_unit_price, sales_currency_code, operational_status_code '||
4445: -- End addition of columns for FA Integration
4446: 'from csi_item_instances where instance_id = :instance_id ';
4447: l_last_purge_date DATE;
4448: l_time_stamp DATE;
4449:
4450: BEGIN

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

4528: -- Close the cursor
4529: DBMS_SQL.CLOSE_CURSOR(l_cur_get_instance_rel);
4530:
4531: --
4532: -- Get the last purge date from csi_item_instances table
4533: --
4534: BEGIN
4535: SELECT last_purge_date
4536: INTO l_last_purge_date

Line 4537: FROM CSI_ITEM_INSTANCES

4533: --
4534: BEGIN
4535: SELECT last_purge_date
4536: INTO l_last_purge_date
4537: FROM CSI_ITEM_INSTANCES
4538: WHERE instance_id = p_instance_rec.instance_id;
4539: EXCEPTION
4540: WHEN no_data_found THEN
4541: null;

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

5637: FROM csi_i_extended_attribs iea
5638: WHERE attribute_level = 'INSTANCE'
5639: AND instance_id = p_instance_id
5640: UNION ALL
5641: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5642: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5643: */ -- Added by sguthiva for bug 2367664
5644: iea.attribute_id attribute_id
5645: ,iea.attribute_level attribute_level

Line 5673: FROM csi_i_extended_attribs iea, csi_item_instances ia

5669: ,iea.attribute13 attribute13
5670: ,iea.attribute14 attribute14
5671: ,iea.attribute15 attribute15
5672: ,iea.object_version_number object_version_number
5673: FROM csi_i_extended_attribs iea, csi_item_instances ia
5674: WHERE iea.attribute_level = 'ITEM'
5675: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5676: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5677: AND ia.instance_id = p_instance_id

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

5675: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5676: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5677: AND ia.instance_id = p_instance_id
5678: UNION ALL
5679: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5680: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5681: INDEX(ic MTL_ITEM_CATEGORIES_U1)
5682: */ -- Added by sguthiva for bug 2367664
5683: iea.attribute_id attribute_id

Line 5713: ,csi_item_instances ia

5709: ,iea.attribute14 attribute14
5710: ,iea.attribute15 attribute15
5711: ,iea.object_version_number object_version_number
5712: FROM csi_i_extended_attribs iea
5713: ,csi_item_instances ia
5714: ,mtl_item_categories ic
5715: WHERE iea.attribute_level = 'CATEGORY'
5716: -- AND iea.inventory_item_id = ia.inventory_item_id -- commented for Bug # 3189494
5717: -- AND iea.master_organization_id = ia.inv_master_organization_id -- commented for Bug # 3189494

Line 6737: FROM csi_item_instances

6733: ) IS
6734:
6735: CURSOR old_instance_rec ( cp_instance_id NUMBER) is
6736: SELECT quantity, install_date, active_end_date
6737: FROM csi_item_instances
6738: WHERE instance_id = cp_instance_id;
6739:
6740: l_curr_instance_rec old_instance_rec%ROWTYPE;
6741: l_row_index NUMBER := 0;