APPS.CSTPACOV dependencies on CST_ITEM_COST_DETAILS

Line 49: INSERT INTO cst_item_cost_details

45: END;
46:
47: p_location := 10;
48:
49: INSERT INTO cst_item_cost_details
50: (inventory_item_id,
51: organization_id,
52: cost_type_id,
53: last_update_date,

Line 111: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147

107: br.cost_element_id
108: FROM cst_item_overhead_defaults ciod,
109: bom_resources br
110: WHERE NOT EXISTS /* Don't insert if item already exists */
111: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
112: 'X'
113: FROM cst_item_cost_details cicd
114: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
115: AND organization_id = I_ORGANIZATION_ID

Line 113: FROM cst_item_cost_details cicd

109: bom_resources br
110: WHERE NOT EXISTS /* Don't insert if item already exists */
111: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
112: 'X'
113: FROM cst_item_cost_details cicd
114: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
115: AND organization_id = I_ORGANIZATION_ID
116: AND cost_type_id = I_COST_TYPE_ID)
117: AND ciod.organization_id = I_ORGANIZATION_ID

Line 189: select /*+ INDEX (CICD CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147

185:
186: /* Update CIC only if the item exists in CICD. */
187: p_location := 20;
188:
189: select /*+ INDEX (CICD CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
190: count(1)
191: into p_dummy
192: from cst_item_cost_details cicd
193: where inventory_item_id = I_INVENTORY_ITEM_ID

Line 192: from cst_item_cost_details cicd

188:
189: select /*+ INDEX (CICD CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
190: count(1)
191: into p_dummy
192: from cst_item_cost_details cicd
193: where inventory_item_id = I_INVENTORY_ITEM_ID
194: AND organization_id = I_ORGANIZATION_ID
195: AND cost_type_id = I_COST_TYPE_ID
196: AND rownum <2; -- Added for bug 6908147