APPS.CSTPACOV dependencies on CST_ITEM_COST_DETAILS

Line 54: DELETE FROM cst_item_cost_details

50: IF I_COST_TYPE_ID <> 1 THEN
51:
52: p_location := 12;
53:
54: DELETE FROM cst_item_cost_details
55: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
56: AND organization_id = I_ORGANIZATION_ID
57: AND cost_type_id = I_COST_TYPE_ID;
58:

Line 68: INSERT INTO cst_item_cost_details

64: END IF;
65:
66: p_location := 15;
67:
68: INSERT INTO cst_item_cost_details
69: (inventory_item_id,
70: organization_id,
71: cost_type_id,
72: last_update_date,

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

126: br.cost_element_id
127: FROM cst_item_overhead_defaults ciod,
128: bom_resources br
129: WHERE NOT EXISTS /* Don't insert if item already exists */
130: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
131: 'X'
132: FROM cst_item_cost_details cicd
133: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
134: AND organization_id = I_ORGANIZATION_ID

Line 132: FROM cst_item_cost_details cicd

128: bom_resources br
129: WHERE NOT EXISTS /* Don't insert if item already exists */
130: (SELECT /*+ INDEX(cicd CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
131: 'X'
132: FROM cst_item_cost_details cicd
133: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
134: AND organization_id = I_ORGANIZATION_ID
135: AND cost_type_id = I_COST_TYPE_ID)
136: AND ciod.organization_id = I_ORGANIZATION_ID

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

204:
205: /* Update CIC only if the item exists in CICD. */
206: p_location := 20;
207:
208: select /*+ INDEX (CICD CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
209: count(1)
210: into p_dummy
211: from cst_item_cost_details cicd
212: where inventory_item_id = I_INVENTORY_ITEM_ID

Line 211: from cst_item_cost_details cicd

207:
208: select /*+ INDEX (CICD CST_ITEM_COST_DETAILS_N1) */ -- Added for bug 6908147
209: count(1)
210: into p_dummy
211: from cst_item_cost_details cicd
212: where inventory_item_id = I_INVENTORY_ITEM_ID
213: AND organization_id = I_ORGANIZATION_ID
214: AND cost_type_id = I_COST_TYPE_ID
215: AND rownum <2; -- Added for bug 6908147