APPS.INVPCOII dependencies on CST_ITEM_COST_DETAILS

Line 186: /* cst_item_cost_details */

182: /* Procedure: CSTPIICD */
183: /* */
184: /* Description : */
185: /* Insert material and material overhead cost into */
186: /* cst_item_cost_details */
187: /* */
188: /* */
189: /* Note : */
190: /* The basis type will default to the following if one is not define */

Line 228: delete from cst_item_cost_details cicd

224: l_location := 200;
225:
226: /* Added delete st for bug 3219632 */
227:
228: delete from cst_item_cost_details cicd
229: where cicd.ORGANIZATION_ID = I_ORGANIZATION_ID
230: AND cicd.INVENTORY_ITEM_ID = I_INVENTORY_ITEM_ID
231: AND cicd.COST_ELEMENT_ID = I_COST_ELEMENT_ID;
232:

Line 235: insert into cst_item_cost_details

231: AND cicd.COST_ELEMENT_ID = I_COST_ELEMENT_ID;
232:
233: /* End of bug fix 3219632 */
234:
235: insert into cst_item_cost_details
236: ( inventory_item_id
237: , organization_id
238: , cost_type_id
239: , last_update_date

Line 350: FROM cst_item_cost_details cicd, mtl_parameters mp

346: I_INVENTORY_ITEM_ID,
347: SYSDATE, I_USER_ID,
348: SYSDATE, I_USER_ID, I_LOGIN_ID,
349: SYSDATE, NVL(SUM(cicd.item_cost),0)
350: FROM cst_item_cost_details cicd, mtl_parameters mp
351: WHERE cicd.ORGANIZATION_ID = I_ORGANIZATION_ID
352: AND cicd.INVENTORY_ITEM_ID = I_INVENTORY_ITEM_ID
353: AND cicd.COST_TYPE_ID = mp.primary_cost_method
354: AND mp.ORGANIZATION_ID = I_ORGANIZATION_ID;

Line 366: FROM cst_item_cost_details cicd, mtl_parameters mp

362: I_INVENTORY_ITEM_ID, cicd.cost_element_id,
363: SYSDATE, I_USER_ID,
364: SYSDATE, I_USER_ID, I_LOGIN_ID,
365: NVL(SUM(cicd.item_cost),0)
366: FROM cst_item_cost_details cicd, mtl_parameters mp
367: WHERE cicd.ORGANIZATION_ID = I_ORGANIZATION_ID
368: AND cicd.INVENTORY_ITEM_ID = I_INVENTORY_ITEM_ID
369: AND cicd.COST_TYPE_ID = mp.primary_cost_method
370: AND mp.ORGANIZATION_ID = I_ORGANIZATION_ID