[Home] [Help]
225: | Reduce CICD rows for the current org by weightage |
226: ***************************************************** */
227: l_stmt_num := 30;
228:
229: UPDATE CST_ITEM_COST_DETAILS CICD
230: SET ITEM_COST = (ITEM_COST * curr_org_make_weight),
231: /* Propagate changes for Bug 2347889
232: Scale the yielded cost also */
233: YIELDED_COST = DECODE(YIELDED_COST,NULL,NULL,(YIELDED_COST * curr_org_make_weight)),
293: l_stmt_num := 60;
294:
295: -- SCAPI: option to preserve the buy cost details
296: IF (p_buy_cost_detail <> 1 or p_buy_cost_detail is null) THEN
297: INSERT INTO CST_ITEM_COST_DETAILS
298: (
299: inventory_item_id,
300: organization_id,
301: cost_type_id,
379: CSSR.rollup_id = p_rollup_id AND
380: CSSR.ROWID = vendor_cur.ROWID;
381:
382: ELSE
383: INSERT INTO CST_ITEM_COST_DETAILS
384: (
385: inventory_item_id,
386: organization_id,
387: cost_type_id,
457: NVL(vendor_cur.vendor_id, -1), -- SCAPI: use -1 if no vendor name
458: NVL(vendor_cur.vendor_site_id, -1),
459: curr_vendor_buy_weight*100
460: FROM
461: CST_ITEM_COST_DETAILS CICD2,
462: MTL_PARAMETERS MP
463: WHERE
464: -- If buy cost type equals destination cost type, do not include rolled-up costs.
465: -- This is to get consistent results with the no-buy-cost-detail option.
522: l_stmt_num := 80;
523: l_counter := l_counter + 1;
524:
525:
526: INSERT INTO CST_ITEM_COST_DETAILS
527: (
528: inventory_item_id,
529: organization_id,
530: cost_type_id,
605: NULL,
606: src_org.allocation_factor*100,
607: src_org.ship_method
608: FROM
609: CST_ITEM_COST_DETAILS CICD2,
610: MTL_PARAMETERS MP
611: WHERE
612: CICD2.inventory_item_id = p_inventory_item_id
613: AND CICD2.organization_id = src_org.source_organization_id
646: /***************************************************************************
647: | Insert rows into CICD for Markup and Shipping costs as MOH |
648: ***************************************************************************/
649:
650: INSERT INTO CST_ITEM_COST_DETAILS
651: (
652: inventory_item_id,
653: organization_id,
654: cost_type_id,
735: NULL,
736: src_org.allocation_factor * 100,
737: src_org.ship_method
738: FROM
739: CST_ITEM_COST_DETAILS CICD2,
740: MTL_PARAMETERS MP
741: WHERE
742: CICD2.inventory_item_id = p_inventory_item_id
743: AND CICD2.organization_id = p_dest_organization_id
798: NULL,
799: src_org.allocation_factor * 100,
800: src_org.ship_method
801: FROM
802: CST_ITEM_COST_DETAILS CICD2,
803: MTL_PARAMETERS MP
804: WHERE
805: CICD2.inventory_item_id = p_inventory_item_id
806: AND CICD2.organization_id = p_dest_organization_id