DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY_TREND dependencies on PJI_PMV_ET_RT_DIM_TMP

Line 502: , pji_pmv_et_rt_dim_tmp ET

498: , 0 py_cost
499: FROM
500: pji_pmv_time_dim_tmp TIME
501: , pji_pmv_orgz_dim_tmp HORG
502: , pji_pmv_et_rt_dim_tmp ET
503: , PJI_FP_ORGO_ET_F_MV FCT
504: , pji_pmv_org_dim_tmp HOU
505: WHERE
506: FCT.org_id = HOU.id

Line 527: , pji_pmv_et_rt_dim_tmp ET

523: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
524: FROM
525: pji_pmv_time_dim_tmp TIME
526: , pji_pmv_orgz_dim_tmp HORG
527: , pji_pmv_et_rt_dim_tmp ET
528: , PJI_FP_ORGO_ET_F_MV FCT
529: , pji_pmv_org_dim_tmp HOU
530: WHERE
531: FCT.org_id = HOU.id

Line 664: , pji_pmv_et_rt_dim_tmp ET

660: FROM
661: pji_pmv_time_dim_tmp TIME
662: , pji_pmv_orgz_dim_tmp HORG
663: , pji_pmv_cls_dim_tmp CLS
664: , pji_pmv_et_rt_dim_tmp ET
665: , PJI_FP_CLSO_ET_F_MV FCT
666: , pji_pmv_org_dim_tmp HOU
667: WHERE
668: FCT.project_org_id = HOU.id

Line 690: , pji_pmv_et_rt_dim_tmp ET

686: FROM
687: pji_pmv_time_dim_tmp TIME
688: , pji_pmv_orgz_dim_tmp HORG
689: , pji_pmv_cls_dim_tmp CLS
690: , pji_pmv_et_rt_dim_tmp ET
691: , PJI_FP_CLSO_ET_F_MV FCT
692: , pji_pmv_org_dim_tmp HOU
693: WHERE
694: FCT.project_org_id = HOU.id

Line 748: , pji_pmv_et_rt_dim_tmp ET

744: , 0 py_cost
745: FROM
746: pji_pmv_time_dim_tmp TIME
747: , pji_pmv_orgz_dim_tmp HORG
748: , pji_pmv_et_rt_dim_tmp ET
749: , pji_pmv_wt_dim_tmp WT
750: , PJI_FP_ORGO_ET_WT_F_MV FCT
751: , pji_pmv_org_dim_tmp HOU
752: WHERE

Line 774: , pji_pmv_et_rt_dim_tmp ET

770: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
771: FROM
772: pji_pmv_time_dim_tmp TIME
773: , pji_pmv_orgz_dim_tmp HORG
774: , pji_pmv_et_rt_dim_tmp ET
775: , pji_pmv_wt_dim_tmp WT
776: , PJI_FP_ORGO_ET_WT_F_MV FCT
777: , pji_pmv_org_dim_tmp HOU
778: WHERE

Line 916: , pji_pmv_et_rt_dim_tmp ET

912: FROM
913: pji_pmv_time_dim_tmp TIME
914: , pji_pmv_orgz_dim_tmp HORG
915: , pji_pmv_cls_dim_tmp CLS
916: , pji_pmv_et_rt_dim_tmp ET
917: , pji_pmv_wt_dim_tmp WT
918: , PJI_FP_CLSO_ET_WT_F_MV FCT
919: , pji_pmv_org_dim_tmp HOU
920: WHERE

Line 944: , pji_pmv_et_rt_dim_tmp ET

940: FROM
941: pji_pmv_time_dim_tmp TIME
942: , pji_pmv_orgz_dim_tmp HORG
943: , pji_pmv_cls_dim_tmp CLS
944: , pji_pmv_et_rt_dim_tmp ET
945: , pji_pmv_wt_dim_tmp WT
946: , PJI_FP_CLSO_ET_WT_F_MV FCT
947: , pji_pmv_org_dim_tmp HOU
948: WHERE