[Home] [Help]
442: END Display_Parameters;
443:
444: -----------------------------------------------------------------------------
445: -- PROCEDURE : Periodic_WIP_Value_Rpt_Details
446: -- DESCRIPTION : Procedure for to populate the table cst_wip_pac_period_bal_tmp
447: -- For a given pac period, pac cost type and pac cost group
448: -----------------------------------------------------------------------------
449:
450: PROCEDURE Periodic_WIP_Value_Rpt_Details( p_api_version IN NUMBER,
668:
669: FOR i IN 1..5 LOOP
670:
671: --------------------------------------------------------------------
672: -- Insert the values into Temporary table cst_wip_pac_period_bal_tmp
673: --------------------------------------------------------------------
674: l_stmt_num := 40;
675: INSERT INTO cst_wip_pac_period_bal_tmp (cost_group_id,
676: pac_period_id,
671: --------------------------------------------------------------------
672: -- Insert the values into Temporary table cst_wip_pac_period_bal_tmp
673: --------------------------------------------------------------------
674: l_stmt_num := 40;
675: INSERT INTO cst_wip_pac_period_bal_tmp (cost_group_id,
676: pac_period_id,
677: cost_type_id,
678: wip_entity_id,
679: organization_id,
896: sum(round( wppb.VARIANCE_AMOUNT * l_exchange_rate, l_precision )) VarianceAmount
897: from
898: wip_entities we,
899: mfg_lookups ml,
900: cst_wip_pac_period_bal_tmp wppb,
901: wip_discrete_jobs wdj,
902: wip_accounting_classes wac,
903: mfg_lookups ml2,
904: mtl_parameters mp,
954: sum(round( wppb.VARIANCE_AMOUNT * l_exchange_rate, l_precision )) VarianceAmount
955: FROM
956: wip_lines wl ,
957: mfg_lookups ml ,
958: cst_wip_pac_period_bal_tmp wppb ,
959: wip_repetitive_items wri ,
960: mtl_system_items_kfv msik ,
961: wip_accounting_classes wac ,
962: wip_entities we ,