APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 4617: FROM csi_ctr_item_associations

4613: FROM CS_CTR_ASSOCIATIONS
4614: WHERE source_object_id = p_src_object_id;
4615: */
4616: SELECT group_id
4617: FROM csi_ctr_item_associations
4618: WHERE inventory_item_id = p_src_object_id;
4619: BEGIN
4620: -- Standard Start of API savepoint
4621: SAVEPOINT create_item_instance_pvt;

Line 6124: FROM csi_ctr_item_associations

6120: --l_counter_group_id := NULL;
6121: BEGIN
6122: SELECT count(*)
6123: INTO l_counter_group_id
6124: FROM csi_ctr_item_associations
6125: WHERE inventory_item_id = p_instance_rec.inventory_item_id
6126: AND ROWNUM = 1;
6127: EXCEPTION
6128: WHEN NO_DATA_FOUND THEN

Line 6132: -- csi_ctr_item_associations with a particular inv_id.

6128: WHEN NO_DATA_FOUND THEN
6129: NULL;
6130: -- Too many rows exception will not arise
6131: -- as ctr API will make sure there will be only one record in
6132: -- csi_ctr_item_associations with a particular inv_id.
6133: END;
6134: -- R12 Changes ...
6135: /* IF CS_Counters_PUB.Ctr_Grp_Template_Exists(p_instance_rec.inventory_item_id) THEN
6136: CS_Counters_PUB.AutoInstantiate_Counters */

Line 11452: FROM csi_ctr_item_associations

11448: --
11449: l_mtl_txn_tbl CSI_DATASTRUCTURES_PUB.MTL_TXN_TBL; -- Added for the bug 6875664, base bug 6531599
11450: CURSOR CTR_GROUP(p_src_object_id IN NUMBER) IS
11451: SELECT group_id
11452: FROM csi_ctr_item_associations
11453: WHERE inventory_item_id = p_src_object_id;
11454:
11455: CURSOR party_owner_rec (p_instance_id NUMBER) is
11456: SELECT

Line 14381: FROM csi_ctr_item_associations

14377: --l_counter_group_id := NULL;
14378: BEGIN
14379: SELECT COUNT(*)
14380: INTO l_counter_group_id
14381: FROM csi_ctr_item_associations
14382: WHERE inventory_item_id = l_get_instance_rec.inventory_item_id
14383: AND ROWNUM=1;
14384: EXCEPTION
14385: WHEN NO_DATA_FOUND THEN