APPS.CSTPCOIC dependencies on CST_ITEM_COSTS

Line 85: FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic

81: INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)
82: SELECT src.inventory_item_id,
83: inv_convert.inv_um_convert(src.inventory_item_id, 30, NULL, src.primary_uom_code, dst.primary_uom_code, NULL, NULL),
84: substr(src.concatenated_segments,1,50)
85: FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic
86: WHERE cic.cost_type_id = from_cst_type_id
87: AND (
88: /* -- ALL ITEMS -- */
89: (range_option = 1)

Line 119: FROM CST_ITEM_COSTS CIC2

115: AND ( -- This is necessary because you could incorrectly abort the program
116: ( (copy_option = 2) AND -- for items you're not trying to copy (based on copy option of
117: ( NOT EXISTS ( -- "New Cost Information Only")
118: SELECT NULL
119: FROM CST_ITEM_COSTS CIC2
120: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
121: AND CIC2.ORGANIZATION_ID = to_org_id
122: AND CIC2.COST_TYPE_ID = to_cst_type_id
123: )

Line 149: DELETE FROM CST_ITEM_COSTS CIC

145: if (copy_option = 3) then
146:
147: location := 1;
148:
149: DELETE FROM CST_ITEM_COSTS CIC
150: WHERE CIC.ORGANIZATION_ID = to_org_id
151: AND CIC.COST_TYPE_ID = to_cst_type_id
152: AND (
153: /* -- ALL ITEMS -- */

Line 209: DELETE FROM CST_ITEM_COSTS CIC

205: if ( copy_option = 1 ) then
206:
207: location := 3;
208:
209: DELETE FROM CST_ITEM_COSTS CIC
210: WHERE EXISTS (
211: SELECT 'Item exists in from org'
212: FROM CST_ITEM_COST_DETAILS CIC2
213: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID

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 286: * from CST_ITEM_COSTS

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: */
290:

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 415: FROM CST_ITEM_COSTS CIC,

411: CIC.PROGRAM_APPLICATION_ID,
412: CIC.PROGRAM_ID,
413: CIC.PROGRAM_UPDATE_DATE,
414: grp_id
415: FROM CST_ITEM_COSTS CIC,
416: MTL_ITEM_FLEXFIELDS MIF,
417: CST_COST_TYPES CCT,
418: MTL_PARAMETERS MP
419: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 430: FROM CST_ITEM_COSTS CIC2

426: AND (
427: ( (copy_option = 2 or copy_option = 1) AND
428: ( NOT EXISTS (
429: SELECT NULL
430: FROM CST_ITEM_COSTS CIC2
431: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
432: AND CIC2.ORGANIZATION_ID = to_org_id
433: AND CIC2.COST_TYPE_ID = to_cst_type_id
434: )

Line 444: SELECT COUNT(*) INTO l_no_of_rows FROM CST_ITEM_COSTS CIC

440: elsif (range_option = 2) then
441:
442: /* ---- Specific Item ---- */
443:
444: SELECT COUNT(*) INTO l_no_of_rows FROM CST_ITEM_COSTS CIC
445: WHERE CIC.ORGANIZATION_ID = from_org_id
446: AND CIC.COST_TYPE_ID = from_cst_type_id
447: AND CIC.INVENTORY_ITEM_ID = spec_item_id;
448:

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 572: FROM CST_ITEM_COSTS CIC,

568: CIC.PROGRAM_APPLICATION_ID,
569: CIC.PROGRAM_ID,
570: CIC.PROGRAM_UPDATE_DATE,
571: grp_id
572: FROM CST_ITEM_COSTS CIC,
573: MTL_ITEM_FLEXFIELDS MIF,
574: CST_COST_TYPES CCT,
575: MTL_PARAMETERS MP
576: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 588: FROM CST_ITEM_COSTS CIC2

584: AND (
585: ( (copy_option = 2 or copy_option = 1) AND
586: ( NOT EXISTS (
587: SELECT NULL
588: FROM CST_ITEM_COSTS CIC2
589: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
590: AND CIC2.ORGANIZATION_ID = to_org_id
591: AND CIC2.COST_TYPE_ID = to_cst_type_id
592: )

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 720: FROM CST_ITEM_COSTS CIC,

716: CIC.PROGRAM_APPLICATION_ID,
717: CIC.PROGRAM_ID,
718: CIC.PROGRAM_UPDATE_DATE,
719: grp_id
720: FROM CST_ITEM_COSTS CIC,
721: MTL_ITEM_FLEXFIELDS MIF,
722: CST_COST_TYPES CCT,
723: MTL_PARAMETERS MP
724: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 742: FROM CST_ITEM_COSTS CIC2

738: AND (
739: ( (copy_option = 2 or copy_option = 1) AND
740: ( NOT EXISTS (
741: SELECT NULL
742: FROM CST_ITEM_COSTS CIC2
743: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
744: AND CIC2.ORGANIZATION_ID = to_org_id
745: AND CIC2.COST_TYPE_ID = to_cst_type_id
746: )

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,