DBA Data[Home] [Help]

APPS.CSTPACOV dependencies on CST_ITEM_COSTS

Line 59: DELETE FROM cst_item_costs

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:
59: DELETE FROM cst_item_costs
60: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
61: AND organization_id = I_ORGANIZATION_ID
62: AND cost_type_id = I_COST_TYPE_ID;
63:

Line 225: INSERT INTO cst_item_costs

221: IF I_COST_TYPE_ID <> 1 THEN
222:
223: p_location := 40;
224:
225: INSERT INTO cst_item_costs
226: (
227: inventory_item_id,
228: organization_id,
229: cost_type_id,

Line 254: UPDATE cst_item_costs

250: 1);
251:
252: END IF;
253:
254: UPDATE cst_item_costs
255: SET (
256: tl_material, tl_material_overhead,
257: tl_resource, tl_outside_processing,
258: tl_overhead,

Line 281: FROM cst_item_costs_view

277: unburdened_cost,
278: burden_cost,
279: sysdate,
280: I_LAST_UPDATED_BY
281: FROM cst_item_costs_view
282: WHERE inventory_item_id = I_INVENTORY_ITEM_ID
283: AND organization_id = I_ORGANIZATION_ID
284: AND cost_type_id = I_COST_TYPE_ID
285: )