APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on CSI_ITEM_INSTANCES

Line 7652: FROM csi_item_instances

7648: IF x_relationship_tbl.exists(i) THEN
7649: --null; -- type of data not known
7650: SELECT inventory_item_id
7651: INTO l_mapped_item_id
7652: FROM csi_item_instances
7653: WHERE instance_id = x_relationship_tbl(i).subject_id
7654: AND inv_master_organization_id = l_org_id;
7655:
7656: --IF l_mapped_item_id = ctr_formula_bvars_cur_rec.mapped_inv_item_id then

Line 8555: FROM csi_item_instances

8551: IF x_relationship_tbl.exists(i) THEN
8552: --null; -- type of data not known
8553: SELECT inventory_item_id
8554: INTO l_mapped_item_id
8555: FROM csi_item_instances
8556: WHERE instance_id = x_relationship_tbl(i).subject_id
8557: AND inv_master_organization_id = l_org_id;
8558:
8559: --IF l_mapped_item_id = ctr_formula_bvars_cur_rec.mapped_inv_item_id then

Line 8765: FROM csi_counter_associations cca,csi_item_instances cii

8761: /* Verify if counter association exists */
8762: BEGIN
8763: SELECT 'x'
8764: INTO l_associations_exists
8765: FROM csi_counter_associations cca,csi_item_instances cii
8766: WHERE cca.counter_id = get_ctr_rec.instantiated_counter_id
8767: AND cca.SOURCE_OBJECT_ID=cii.instance_id
8768: AND cii.inventory_item_id=l_inventory_item_id;
8769:

Line 8807: FROM csi_counter_associations cca,csi_item_instances cii

8803: /* Verify if counter association exists */
8804: BEGIN
8805: SELECT 'x'
8806: INTO l_associations_exists
8807: FROM csi_counter_associations cca,csi_item_instances cii
8808: WHERE cca.counter_id = get_ctr_rec.instantiated_counter_id
8809: AND cca.SOURCE_OBJECT_ID=cii.instance_id
8810: AND cii.inventory_item_id=l_inventory_item_id;
8811: CSI_CTR_GEN_UTILITY_PVT.ExitWithErrMsg('CSI_API_CTR_ITEM_DEL_NOTALLOW');