DBA Data[Home] [Help]

APPS.CST_PAC_WIP_VALUE_REPORT_PVT dependencies on MFG_LOOKUPS

Line 347: mfg_lookups m1

343: cst_pac_periods cpp,
344: cst_cost_types cct,
345: cst_le_cost_types clct,
346: cst_cost_groups ccg,
347: mfg_lookups m1
348: WHERE xle.legal_entity_id = p_legal_entity_id
349: AND clct.legal_entity = xle.legal_entity_id
350: AND clct.cost_type_id = cct.cost_type_id
351: AND cct.cost_type_id = p_cost_type_id

Line 899: mfg_lookups ml,

895: sum(round( wppb.ENDING_BALANCE * l_exchange_rate, l_precision )) EndingBalance,
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,

Line 903: mfg_lookups ml2,

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,
905: cst_cost_elements cce,
906: mtl_system_items_kfv msik
907: where

Line 957: mfg_lookups ml ,

953: sum(round( wppb.ENDING_BALANCE * l_exchange_rate, l_precision )) EndingBalance,
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 ,