eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_PROFITABILITY_TREND dependencies on PJI_PMV_ORG_DIM_TMP

Line 344: , pji_pmv_org_dim_tmp HOU

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
347: AND FCT.organization_id = HORG.id
348: AND FCT.time_id = TIME.id

Line 365: , pji_pmv_org_dim_tmp HOU

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
368: AND FCT.organization_id = HORG.id
369: AND FCT.time_id = TIME.prior_id

Line 425: , pji_pmv_org_dim_tmp HOU

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
428: AND FCT.project_organization_id = HORG.id
429: AND FCT.time_id = TIME.id

Line 448: , pji_pmv_org_dim_tmp HOU

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
451: AND FCT.project_organization_id = HORG.id
452: AND FCT.time_id = TIME.prior_id

Line 504: , pji_pmv_org_dim_tmp HOU

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
507: AND FCT.organization_id = HORG.id
508: AND FCT.time_id = TIME.id

Line 529: , pji_pmv_org_dim_tmp HOU

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
532: AND FCT.organization_id = HORG.id
533: AND FCT.time_id = TIME.prior_id

Line 587: , pji_pmv_org_dim_tmp HOU

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
590: AND FCT.organization_id = HORG.id
591: AND FCT.time_id = TIME.id

Line 610: , pji_pmv_org_dim_tmp HOU

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
613: AND FCT.organization_id = HORG.id
614: AND FCT.time_id = TIME.prior_id

Line 666: , pji_pmv_org_dim_tmp HOU

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
669: AND FCT.project_organization_id = HORG.id
670: AND FCT.time_id = TIME.id

Line 692: , pji_pmv_org_dim_tmp HOU

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
695: AND FCT.project_organization_id = HORG.id
696: AND FCT.time_id = TIME.prior_id

Line 751: , pji_pmv_org_dim_tmp HOU

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
754: AND FCT.organization_id = HORG.id
755: AND FCT.time_id = TIME.id

Line 777: , pji_pmv_org_dim_tmp HOU

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
780: AND FCT.organization_id = HORG.id
781: AND FCT.time_id = TIME.prior_id

Line 837: , pji_pmv_org_dim_tmp HOU

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
840: AND FCT.project_organization_id = HORG.id
841: AND FCT.time_id = TIME.id

Line 862: , pji_pmv_org_dim_tmp HOU

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
865: AND FCT.project_organization_id = HORG.id
866: AND FCT.time_id = TIME.prior_id

Line 919: , pji_pmv_org_dim_tmp HOU

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
922: AND FCT.project_organization_id = HORG.id
923: AND FCT.time_id = TIME.id

Line 947: , pji_pmv_org_dim_tmp HOU

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
950: AND FCT.project_organization_id = HORG.id
951: AND FCT.time_id = TIME.prior_id