APPS.PJI_PMV_PROFITABILITY_TREND dependencies on PJI_PMV_ORGZ_DIM_TMP

Line 342: , pji_pmv_orgz_dim_tmp HORG

338: , 0 py_revenue
339: , 0 py_cost
340: FROM
341: pji_pmv_time_dim_tmp TIME
342: , pji_pmv_orgz_dim_tmp HORG
343: , pji_fp_orgo_f_mv FCT
344: , pji_pmv_org_dim_tmp HOU
345: WHERE
346: FCT.org_id = HOU.id

Line 363: , pji_pmv_orgz_dim_tmp HORG

359: , revenue py_revenue
360: , DECODE(l_Report_Cost_Type,'RC', raw_cost,'BC', burdened_cost) py_cost
361: FROM
362: pji_pmv_time_dim_tmp TIME
363: , pji_pmv_orgz_dim_tmp HORG
364: , pji_fp_orgo_f_mv FCT
365: , pji_pmv_org_dim_tmp HOU
366: WHERE
367: FCT.org_id = HOU.id

Line 422: , pji_pmv_orgz_dim_tmp HORG

418: , 0 py_revenue
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

Line 445: , pji_pmv_orgz_dim_tmp HORG

441: , revenue py_revenue
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

Line 501: , pji_pmv_orgz_dim_tmp HORG

497: , 0 py_revenue
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

Line 526: , pji_pmv_orgz_dim_tmp HORG

522: , revenue py_revenue
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

Line 584: , pji_pmv_orgz_dim_tmp HORG

580: , 0 py_revenue
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

Line 607: , pji_pmv_orgz_dim_tmp HORG

603: , null py_revenue
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

Line 662: , pji_pmv_orgz_dim_tmp HORG

658: , 0 py_revenue
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

Line 688: , pji_pmv_orgz_dim_tmp HORG

684: , revenue py_revenue
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

Line 747: , pji_pmv_orgz_dim_tmp HORG

743: , 0 py_revenue
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

Line 773: , pji_pmv_orgz_dim_tmp HORG

769: , null py_revenue
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

Line 833: , pji_pmv_orgz_dim_tmp HORG

829: , 0 py_revenue
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

Line 858: , pji_pmv_orgz_dim_tmp HORG

854: , null py_revenue
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

Line 914: , pji_pmv_orgz_dim_tmp HORG

910: , 0 py_revenue
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

Line 942: , pji_pmv_orgz_dim_tmp HORG

938: , null py_revenue
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