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_BOOKINGS_BACKLOG dependencies on PJI_PMV_ITD_DIM_TMP

Line 457: FROM pji_pmv_itd_dim_tmp TIME

453: , 0 btb_revenue
454: , 0
455: , 0 prior_btb_total_bookings
456: , 0 prior_btb_revenue
457: FROM pji_pmv_itd_dim_tmp TIME
458: , pji_pmv_orgz_dim_tmp HORG
459: , pji_ac_orgo_f_mv FCT
460: , pji_pmv_org_dim_tmp HOU
461: WHERE

Line 488: FROM pji_pmv_itd_dim_tmp TIME

484: , 0 btb_revenue
485: , 0
486: , 0 prior_btb_total_bookings
487: , 0 prior_btb_revenue
488: FROM pji_pmv_itd_dim_tmp TIME
489: , pji_pmv_orgz_dim_tmp HORG
490: , pji_ac_orgo_f_mv FCT
491: , pji_pmv_org_dim_tmp HOU
492: WHERE

Line 737: FROM pji_pmv_itd_dim_tmp TIME

733: , 0 btb_revenue
734: , 0
735: , 0 prior_btb_total_bookings
736: , 0 prior_btb_revenue
737: FROM pji_pmv_itd_dim_tmp TIME
738: , pji_pmv_orgz_dim_tmp HORG
739: , pji_pmv_cls_dim_tmp CLS
740: , pji_ac_clso_f_mv FCT
741: , pji_pmv_org_dim_tmp HOU

Line 770: FROM pji_pmv_itd_dim_tmp TIME

766: , 0 btb_revenue
767: , 0
768: , 0 prior_btb_total_bookings
769: , 0 prior_btb_revenue
770: FROM pji_pmv_itd_dim_tmp TIME
771: , pji_pmv_orgz_dim_tmp HORG
772: , pji_pmv_cls_dim_tmp CLS
773: , pji_ac_clso_f_mv FCT
774: , pji_pmv_org_dim_tmp HOU

Line 1481: FROM PJI_PMV_ITD_DIM_TMP TIME,

1477: 0,
1478: 0,
1479: 0,
1480: 0
1481: FROM PJI_PMV_ITD_DIM_TMP TIME,
1482: PJI_PMV_ORGZ_DIM_TMP TORG,
1483: PJI_AC_PROJ_F FCT,
1484: PJI_PMV_ORG_DIM_TMP TOU
1485: WHERE FCT.PROJECT_ORG_ID = TOU.ID

Line 1698: FROM PJI_PMV_ITD_DIM_TMP TIME,

1694: 0,
1695: 0,
1696: 0,
1697: 0
1698: FROM PJI_PMV_ITD_DIM_TMP TIME,
1699: PJI_PMV_PRJ_DIM_TMP TPRJ,
1700: PJI_AC_PROJ_F FCT,
1701: PJI_PMV_ORG_DIM_TMP TOU
1702: WHERE FCT.PROJECT_ORG_ID = TOU.ID

Line 2074: FROM PJI_PMV_ITD_DIM_TMP TIME,

2070: 0,
2071: 0,
2072: 0,
2073: 0
2074: FROM PJI_PMV_ITD_DIM_TMP TIME,
2075: PJI_PMV_ORGZ_DIM_TMP HORG,
2076: PJI_AC_ORGO_F_MV FCT,
2077: PJI_PMV_ORG_DIM_TMP HOU
2078: WHERE FCT.ORG_ID = HOU.ID

Line 2227: FROM PJI_PMV_ITD_DIM_TMP TIME,

2223: 0,
2224: 0,
2225: 0,
2226: 0
2227: FROM PJI_PMV_ITD_DIM_TMP TIME,
2228: PJI_PMV_ORGZ_DIM_TMP HORG,
2229: PJI_PMV_CLS_DIM_TMP CLS,
2230: PJI_AC_CLSO_F_MV FCT,
2231: PJI_PMV_ORG_DIM_TMP HOU