APPS.CSTPCOIC dependencies on CST_ITEM_COSTS

Line 83: ' substr(src.concatenated_segments,1,50) FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic'||

79: * where the from UOM <> to UOM *
80: */
81: l_sql_stmnt := 'INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)'||
82: ' SELECT src.inventory_item_id,inv_convert.inv_um_convert(src.inventory_item_id, 30, NULL, src.primary_uom_code, dst.primary_uom_code, NULL, NULL),'||
83: ' substr(src.concatenated_segments,1,50) FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic'||
84: ' WHERE cic.cost_type_id = :from_cst_type_id'||
85: ' AND cic.organization_id = :from_org_id'||
86: ' AND src.organization_id = cic.organization_id'||
87: ' AND dst.organization_id = :to_org_id'||

Line 95: ' FROM CST_ITEM_COSTS CIC2'||

91: ' AND src.primary_uom_code <> dst.primary_uom_code';
92: IF ( copy_option = 2 ) THEN
93: l_sql_stmnt := l_sql_stmnt||
94: ' AND NOT EXISTS ( SELECT NULL'||
95: ' FROM CST_ITEM_COSTS CIC2'||
96: ' WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID'||
97: ' AND CIC2.ORGANIZATION_ID = :to_org_id2'||
98: ' AND CIC2.COST_TYPE_ID = :to_cst_type_id'||
99: ')';

Line 161: DELETE FROM CST_ITEM_COSTS CIC

157: if (copy_option = 3) then
158:
159: location := 1;
160:
161: DELETE FROM CST_ITEM_COSTS CIC
162: WHERE CIC.ORGANIZATION_ID = to_org_id
163: AND CIC.COST_TYPE_ID = to_cst_type_id
164: AND (
165: /* -- ALL ITEMS -- */

Line 221: DELETE FROM CST_ITEM_COSTS CIC

217: if ( copy_option = 1 ) then
218:
219: location := 3;
220:
221: DELETE FROM CST_ITEM_COSTS CIC
222: WHERE EXISTS (
223: SELECT 'Item exists in from org'
224: FROM CST_ITEM_COST_DETAILS CIC2
225: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID

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

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

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

423: CIC.PROGRAM_APPLICATION_ID,
424: CIC.PROGRAM_ID,
425: CIC.PROGRAM_UPDATE_DATE,
426: grp_id
427: FROM CST_ITEM_COSTS CIC,
428: MTL_ITEM_FLEXFIELDS MIF,
429: CST_COST_TYPES CCT,
430: MTL_PARAMETERS MP
431: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 442: FROM CST_ITEM_COSTS CIC2

438: AND (
439: ( (copy_option = 2 or copy_option = 1) AND
440: ( NOT EXISTS (
441: SELECT NULL
442: FROM CST_ITEM_COSTS CIC2
443: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
444: AND CIC2.ORGANIZATION_ID = to_org_id
445: AND CIC2.COST_TYPE_ID = to_cst_type_id
446: )

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

452: elsif (range_option = 2) then
453:
454: /* ---- Specific Item ---- */
455:
456: SELECT COUNT(*) INTO l_no_of_rows FROM CST_ITEM_COSTS CIC
457: WHERE CIC.ORGANIZATION_ID = from_org_id
458: AND CIC.COST_TYPE_ID = from_cst_type_id
459: AND CIC.INVENTORY_ITEM_ID = spec_item_id;
460:

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

580: CIC.PROGRAM_APPLICATION_ID,
581: CIC.PROGRAM_ID,
582: CIC.PROGRAM_UPDATE_DATE,
583: grp_id
584: FROM CST_ITEM_COSTS CIC,
585: MTL_ITEM_FLEXFIELDS MIF,
586: CST_COST_TYPES CCT,
587: MTL_PARAMETERS MP
588: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 600: FROM CST_ITEM_COSTS CIC2

596: AND (
597: ( (copy_option = 2 or copy_option = 1) AND
598: ( NOT EXISTS (
599: SELECT NULL
600: FROM CST_ITEM_COSTS CIC2
601: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
602: AND CIC2.ORGANIZATION_ID = to_org_id
603: AND CIC2.COST_TYPE_ID = to_cst_type_id
604: )

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

728: CIC.PROGRAM_APPLICATION_ID,
729: CIC.PROGRAM_ID,
730: CIC.PROGRAM_UPDATE_DATE,
731: grp_id
732: FROM CST_ITEM_COSTS CIC,
733: MTL_ITEM_FLEXFIELDS MIF,
734: CST_COST_TYPES CCT,
735: MTL_PARAMETERS MP
736: WHERE CIC.ORGANIZATION_ID = from_org_id

Line 754: FROM CST_ITEM_COSTS CIC2

750: AND (
751: ( (copy_option = 2 or copy_option = 1) AND
752: ( NOT EXISTS (
753: SELECT NULL
754: FROM CST_ITEM_COSTS CIC2
755: WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
756: AND CIC2.ORGANIZATION_ID = to_org_id
757: AND CIC2.COST_TYPE_ID = to_cst_type_id
758: )

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,