DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY_TREND dependencies on PJI_PMV_CLS_DIM_TMP

Line 423: , pji_pmv_cls_dim_tmp CLS

419: , 0 py_cost
420: FROM
421: pji_pmv_time_dim_tmp TIME
422: , pji_pmv_orgz_dim_tmp HORG
423: , pji_pmv_cls_dim_tmp CLS
424: , pji_fp_clso_f_mv FCT
425: , pji_pmv_org_dim_tmp HOU
426: WHERE
427: FCT.project_org_id = HOU.id

Line 446: , pji_pmv_cls_dim_tmp CLS

442: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
443: FROM
444: pji_pmv_time_dim_tmp TIME
445: , pji_pmv_orgz_dim_tmp HORG
446: , pji_pmv_cls_dim_tmp CLS
447: , pji_fp_clso_f_mv FCT
448: , pji_pmv_org_dim_tmp HOU
449: WHERE
450: FCT.project_org_id = HOU.id

Line 663: , pji_pmv_cls_dim_tmp CLS

659: , 0 py_cost
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

Line 689: , pji_pmv_cls_dim_tmp CLS

685: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
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

Line 834: , pji_pmv_cls_dim_tmp CLS

830: , 0 py_cost
831: FROM
832: pji_pmv_time_dim_tmp TIME
833: , pji_pmv_orgz_dim_tmp HORG
834: , pji_pmv_cls_dim_tmp CLS
835: , pji_pmv_wt_dim_tmp WT
836: , PJI_FP_CLSO_ET_WT_F_MV FCT
837: , pji_pmv_org_dim_tmp HOU
838: WHERE

Line 859: , pji_pmv_cls_dim_tmp CLS

855: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
856: FROM
857: pji_pmv_time_dim_tmp TIME
858: , pji_pmv_orgz_dim_tmp HORG
859: , pji_pmv_cls_dim_tmp CLS
860: , pji_pmv_wt_dim_tmp WT
861: , PJI_FP_CLSO_ET_WT_F_MV FCT
862: , pji_pmv_org_dim_tmp HOU
863: WHERE

Line 915: , pji_pmv_cls_dim_tmp CLS

911: , 0 py_cost
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

Line 943: , pji_pmv_cls_dim_tmp CLS

939: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
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