[Home] [Help]
218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
219: END IF;
220:
221: /*------ ----------------------------------------------+
222: Insert rows into the cst_item_cost_details table
223: +-----------------------------------------------------*/
224:
225: lStmtNumber := 230;
226:
223: +-----------------------------------------------------*/
224:
225: lStmtNumber := 230;
226:
227: insert into cst_item_cost_details
228: (inventory_item_id,
229: cost_type_id,
230: last_update_date,
231: last_updated_by,
316: from mtl_parameters mp
317: where mp.organization_id = p_organization_id ;
318:
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);
321:
322: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
323: END IF;
324:
318:
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);
321:
322: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
323: END IF;
324:
325:
326: exception
474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
475: END IF;
476:
477: /*------ ----------------------------------------------+
478: Insert rows into the cst_item_cost_details table
479: +-----------------------------------------------------*/
480:
481: lStmtNumber := 230;
482:
479: +-----------------------------------------------------*/
480:
481: lStmtNumber := 230;
482:
483: insert into cst_item_cost_details
484: (inventory_item_id,
485: cost_type_id,
486: last_update_date,
487: last_updated_by,
572: from mtl_parameters mp
573: where mp.organization_id = p_organization_id ;
574:
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);
577:
578: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
579: END IF;
580:
574:
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);
577:
578: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
579: END IF;
580:
581:
582: exception
727: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
728: END IF;
729:
730: /*------ ----------------------------------------------+
731: Insert rows into the cst_item_cost_details table
732: +-----------------------------------------------------*/
733:
734: lStmtNumber := 230;
735:
732: +-----------------------------------------------------*/
733:
734: lStmtNumber := 230;
735:
736: insert into cst_item_cost_details
737: (inventory_item_id,
738: cost_type_id,
739: last_update_date,
740: last_updated_by,
822: C.attribute13,
823: C.attribute14,
824: C.attribute15
825: from
826: cst_item_cost_details C
827: where C.inventory_item_id = p_config_item_id
828: and C.organization_id = p_organization_id
829: and C.cost_type_id = p_cto_cost_type_id ;
830:
828: and C.organization_id = p_organization_id
829: and C.cost_type_id = p_cto_cost_type_id ;
830:
831: IF PG_DEBUG <> 0 THEN
832: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:cst_item_cost_details' || sql%rowcount ,2);
833: END IF;
834:
835: --Begin Bugfix 6363308
836: lStmtNumber := 250;
862: -1,
863: SYSDATE,
864: NVL(SUM(item_cost),0)
865: FROM
866: cst_item_cost_details
867: WHERE organization_id = p_organization_id
868: AND inventory_item_id = p_config_item_id
869: AND cost_type_id = 1;
870:
897: -1,
898: -1,
899: NVL(SUM(item_cost),0)
900: FROM
901: cst_item_cost_details
902: WHERE organization_id = p_organization_id
903: AND inventory_item_id = p_config_item_id
904: AND cost_type_id = 1
905: GROUP BY cost_element_id;
1130: and msi.organization_id = mp.organization_id
1131: and mp.primary_cost_method = cic.cost_type_id
1132: and EXISTS /* check whether item has been rolled up */
1133: ( select NULL
1134: from cst_item_cost_details
1135: where rollup_source_type = 3
1136: and inventory_item_id = msi.inventory_item_id
1137: and cost_type_id = cic.cost_type_id
1138: and organization_id = msi.organization_id
1700: and inventory_item_id = msi.inventory_item_id
1701: and organization_id = mp.cost_organization_id) --3116778
1702: and NOT EXISTS /* check whether item has been rolled up */
1703: ( select NULL
1704: from cst_item_cost_details
1705: where rollup_source_type = 3
1706: and inventory_item_id = msi.inventory_item_id
1707: and cost_type_id = cic.cost_type_id
1708: and organization_id = mp.cost_organization_id) ; --3116778
1854: || ' in org ' || c_organization_id , 1);
1855: END IF;
1856:
1857:
1858: delete from cst_item_cost_details
1859: where inventory_item_id = c_config_item_id
1860: and organization_id = c_organization_id
1861: and cost_type_id = 1 ;
1862:
2058: cursor c1_cst (c_inventory_item_id number) is
2059: select cst.inventory_item_id, cst.organization_id, cst.cost_type_id,
2060: cst.item_cost , cst.material_cost, cst.material_overhead_cost,
2061: cicd.cost_element_id ,cicd.item_cost cicd_item_cost
2062: from cst_item_costs cst, cst_item_cost_details cicd
2063: where cst.inventory_item_id = cicd.inventory_item_id
2064: and cst.organization_id = cicd.organization_id
2065: and cst.cost_type_id = cicd.cost_type_id
2066: and cst.inventory_item_id = c_inventory_item_id ;
2781: || ' in org ' || c_organization_id , 1);
2782: END IF;
2783:
2784:
2785: delete from cst_item_cost_details
2786: where inventory_item_id = c_config_item_id
2787: and organization_id = c_organization_id
2788: and cost_type_id = 1 ;
2789: