APPS.CSTPCOIC dependencies on CST_ITEM_COSTS_INTERFACE

Line 285: * Copy over non-code columns into CST_ITEM_COSTS_INTERFACE

281: end if;
282:
283:
284: /*
285: * Copy over non-code columns into CST_ITEM_COSTS_INTERFACE
286: * from CST_ITEM_COSTS
287: *
288: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE
289: */

Line 288: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE

284: /*
285: * Copy over non-code columns into CST_ITEM_COSTS_INTERFACE
286: * from CST_ITEM_COSTS
287: *
288: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE
289: */
290:
291: location := 5;
292:

Line 297: INSERT INTO CST_ITEM_COSTS_INTERFACE (

293: if (range_option = 1) then
294:
295: /* ---- All Items ---- */
296:
297: INSERT INTO CST_ITEM_COSTS_INTERFACE (
298: INVENTORY_ITEM_ID,
299: ORGANIZATION_ID,
300: COST_TYPE_ID,
301: INVENTORY_ITEM,

Line 454: INSERT INTO CST_ITEM_COSTS_INTERFACE (

450: commit;
451: RETURN(2);
452: end if;
453:
454: INSERT INTO CST_ITEM_COSTS_INTERFACE (
455: INVENTORY_ITEM_ID,
456: ORGANIZATION_ID,
457: COST_TYPE_ID,
458: INVENTORY_ITEM,

Line 602: INSERT INTO CST_ITEM_COSTS_INTERFACE (

598: elsif (range_option = 5) then
599:
600: /* ---- Specific Category ---- */
601:
602: INSERT INTO CST_ITEM_COSTS_INTERFACE (
603: INVENTORY_ITEM_ID,
604: ORGANIZATION_ID,
605: COST_TYPE_ID,
606: INVENTORY_ITEM,

Line 904: FROM CST_ITEM_COSTS_INTERFACE CICI,

900: CICD.ATTRIBUTE14,
901: CICD.ATTRIBUTE15,
902: --bug5839929
903: CICD.yielded_cost*NVL(l_conversion_rate,1)
904: FROM CST_ITEM_COSTS_INTERFACE CICI,
905: BOM_DEPARTMENTS BD,
906: CST_ACTIVITIES CA,
907: BOM_RESOURCES BR,
908: CST_COST_ELEMENTS CCE,

Line 952: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr

948: UNBURDENED_COST,
949: BURDEN_COST,
950: LOT_SIZE,
951: uom_conversion_rate
952: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr
953: WHERE cici.inventory_item_id = cucr.inventory_item_id
954: AND cici.group_id = grp_id)
955: SET PL_MATERIAL = PL_MATERIAL / uom_conversion_rate,
956: PL_MATERIAL_OVERHEAD = PL_MATERIAL_OVERHEAD / uom_conversion_rate,