DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY_TREND dependencies on PJI_PMV_WT_DIM_TMP

Line 585: , pji_pmv_wt_dim_tmp WT

581: , 0 py_cost
582: FROM
583: pji_pmv_time_dim_tmp TIME
584: , pji_pmv_orgz_dim_tmp HORG
585: , pji_pmv_wt_dim_tmp WT
586: , PJI_FP_ORGO_ET_WT_F_MV FCT
587: , pji_pmv_org_dim_tmp HOU
588: WHERE
589: FCT.org_id = HOU.id

Line 608: , pji_pmv_wt_dim_tmp WT

604: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
605: FROM
606: pji_pmv_time_dim_tmp TIME
607: , pji_pmv_orgz_dim_tmp HORG
608: , pji_pmv_wt_dim_tmp WT
609: , PJI_FP_ORGO_ET_WT_F_MV FCT
610: , pji_pmv_org_dim_tmp HOU
611: WHERE
612: FCT.org_id = HOU.id

Line 749: , pji_pmv_wt_dim_tmp WT

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
753: FCT.org_id = HOU.id

Line 775: , pji_pmv_wt_dim_tmp WT

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
779: FCT.org_id = HOU.id

Line 835: , pji_pmv_wt_dim_tmp WT

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
839: FCT.project_org_id = HOU.id

Line 860: , pji_pmv_wt_dim_tmp WT

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
864: FCT.project_org_id = HOU.id

Line 917: , pji_pmv_wt_dim_tmp WT

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
921: FCT.project_org_id = HOU.id

Line 945: , pji_pmv_wt_dim_tmp WT

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
949: FCT.project_org_id = HOU.id