APPS.CSTPCOIC dependencies on CST_ITEM_COSTS_INTERFACE

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

293: end if;
294:
295:
296: /*
297: * Copy over non-code columns into CST_ITEM_COSTS_INTERFACE
298: * from CST_ITEM_COSTS
299: *
300: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE
301: */

Line 300: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE

296: /*
297: * Copy over non-code columns into CST_ITEM_COSTS_INTERFACE
298: * from CST_ITEM_COSTS
299: *
300: * CST_ITEM_COSTS ==> CST_ITEM_COSTS_INTERFACE
301: */
302:
303: location := 5;
304:

Line 309: INSERT INTO CST_ITEM_COSTS_INTERFACE (

305: if (range_option = 1) then
306:
307: /* ---- All Items ---- */
308:
309: INSERT INTO CST_ITEM_COSTS_INTERFACE (
310: INVENTORY_ITEM_ID,
311: ORGANIZATION_ID,
312: COST_TYPE_ID,
313: INVENTORY_ITEM,

Line 466: INSERT INTO CST_ITEM_COSTS_INTERFACE (

462: commit;
463: RETURN(2);
464: end if;
465:
466: INSERT INTO CST_ITEM_COSTS_INTERFACE (
467: INVENTORY_ITEM_ID,
468: ORGANIZATION_ID,
469: COST_TYPE_ID,
470: INVENTORY_ITEM,

Line 614: INSERT INTO CST_ITEM_COSTS_INTERFACE (

610: elsif (range_option = 5) then
611:
612: /* ---- Specific Category ---- */
613:
614: INSERT INTO CST_ITEM_COSTS_INTERFACE (
615: INVENTORY_ITEM_ID,
616: ORGANIZATION_ID,
617: COST_TYPE_ID,
618: INVENTORY_ITEM,

Line 916: FROM CST_ITEM_COSTS_INTERFACE CICI,

912: CICD.ATTRIBUTE14,
913: CICD.ATTRIBUTE15,
914: --bug5839929
915: CICD.yielded_cost*NVL(l_conversion_rate,1)
916: FROM CST_ITEM_COSTS_INTERFACE CICI,
917: BOM_DEPARTMENTS BD,
918: CST_ACTIVITIES CA,
919: BOM_RESOURCES BR,
920: CST_COST_ELEMENTS CCE,

Line 964: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr

960: UNBURDENED_COST,
961: BURDEN_COST,
962: LOT_SIZE,
963: uom_conversion_rate
964: FROM cst_item_costs_interface cici, cst_uom_conv_rates_temp cucr
965: WHERE cici.inventory_item_id = cucr.inventory_item_id
966: AND cici.group_id = grp_id)
967: SET PL_MATERIAL = PL_MATERIAL / uom_conversion_rate,
968: PL_MATERIAL_OVERHEAD = PL_MATERIAL_OVERHEAD / uom_conversion_rate,