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_ORGZ_DIM_TMP

Line 398: , pji_pmv_orgz_dim_tmp HORG

394: , 0
395: , 0 prior_btb_total_bookings
396: , 0 prior_btb_revenue
397: FROM pji_pmv_time_dim_tmp TIME
398: , pji_pmv_orgz_dim_tmp HORG
399: , pji_ac_orgo_f_mv FCT
400: , pji_pmv_org_dim_tmp HOU
401: WHERE
402: FCT.org_id = HOU.id

Line 428: , pji_pmv_orgz_dim_tmp HORG

424: , 0
425: , 0 prior_btb_total_bookings
426: , 0 prior_btb_revenue
427: FROM pji_pmv_tcmp_dim_tmp TIME
428: , pji_pmv_orgz_dim_tmp HORG
429: , pji_ac_orgo_f_mv FCT
430: , pji_pmv_org_dim_tmp HOU
431: WHERE
432: FCT.org_id = HOU.id

Line 458: , pji_pmv_orgz_dim_tmp HORG

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

Line 489: , pji_pmv_orgz_dim_tmp HORG

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

Line 519: FROM pji_pmv_orgz_dim_tmp HORG

515: , FCT.revenue btb_revenue
516: , 0
517: , 0 prior_btb_total_bookings
518: , 0 prior_btb_revenue
519: FROM pji_pmv_orgz_dim_tmp HORG
520: , pji_ac_orgo_f_mv FCT
521: , pji_pmv_org_dim_tmp HOU
522: WHERE
523: FCT.org_id = HOU.id

Line 547: FROM pji_pmv_orgz_dim_tmp HORG

543: , 0 btb_revenue
544: , 0
545: , FCT.initial_funding_amount+FCT.additional_funding_amount+FCT.funding_adjustment_amount+FCT.cancelled_funding_amount prior_btb_total_bookings
546: , FCT.revenue prior_btb_revenue
547: FROM pji_pmv_orgz_dim_tmp HORG
548: , pji_ac_orgo_f_mv FCT
549: , pji_pmv_org_dim_tmp HOU
550:
551: WHERE

Line 594: FROM pji_pmv_orgz_dim_tmp

590: , 0 btb_revenue
591: , 0
592: , 0 prior_btb_total_bookings
593: , 0 prior_btb_revenue
594: FROM pji_pmv_orgz_dim_tmp
595: WHERE name <> '-1'
596: UNION ALL
597: SELECT '-1' org_id
598: , '-1' organization_id

Line 674: , pji_pmv_orgz_dim_tmp HORG

670: , 0
671: , 0 prior_btb_total_bookings
672: , 0 prior_btb_revenue
673: FROM pji_pmv_time_dim_tmp TIME
674: , pji_pmv_orgz_dim_tmp HORG
675: , pji_pmv_cls_dim_tmp CLS
676: , pji_ac_clso_f_mv FCT
677: , pji_pmv_org_dim_tmp HOU
678: WHERE

Line 706: , pji_pmv_orgz_dim_tmp HORG

702: , 0
703: , 0 prior_btb_total_bookings
704: , 0 prior_btb_revenue
705: FROM pji_pmv_tcmp_dim_tmp TIME
706: , pji_pmv_orgz_dim_tmp HORG
707: , pji_pmv_cls_dim_tmp CLS
708: , pji_ac_clso_f_mv FCT
709: , pji_pmv_org_dim_tmp HOU
710: WHERE

Line 738: , pji_pmv_orgz_dim_tmp HORG

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
742: WHERE

Line 771: , pji_pmv_orgz_dim_tmp HORG

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
775: WHERE

Line 803: FROM pji_pmv_orgz_dim_tmp HORG

799: , FCT.revenue btb_revenue
800: , 0
801: , 0 prior_btb_total_bookings
802: , 0 prior_btb_revenue
803: FROM pji_pmv_orgz_dim_tmp HORG
804: , pji_pmv_cls_dim_tmp CLS
805: , pji_ac_clso_f_mv FCT
806: , pji_pmv_org_dim_tmp HOU
807: WHERE

Line 833: FROM pji_pmv_orgz_dim_tmp HORG

829: , 0 btb_revenue
830: , 0
831: , FCT.initial_funding_amount+FCT.additional_funding_amount+FCT.funding_adjustment_amount+FCT.cancelled_funding_amount prior_btb_total_bookings
832: , FCT.revenue prior_btb_revenue
833: FROM pji_pmv_orgz_dim_tmp HORG
834: , pji_pmv_cls_dim_tmp CLS
835: , pji_ac_clso_f_mv FCT
836: , pji_pmv_org_dim_tmp HOU
837: WHERE

Line 881: FROM pji_pmv_orgz_dim_tmp

877: , 0 btb_revenue
878: , 0
879: , 0 prior_btb_total_bookings
880: , 0 prior_btb_revenue
881: FROM pji_pmv_orgz_dim_tmp
882: WHERE name <> '-1'
883: UNION ALL
884: SELECT '-1' org_id
885: , '-1' organization_id

Line 1433: PJI_PMV_ORGZ_DIM_TMP TORG,

1429: 0,
1430: 0,
1431: 0
1432: FROM PJI_PMV_TIME_DIM_TMP TIME,
1433: PJI_PMV_ORGZ_DIM_TMP TORG,
1434: PJI_AC_PROJ_F FCT,
1435: PJI_PMV_ORG_DIM_TMP TOU
1436: WHERE FCT.PROJECT_ORG_ID = TOU.ID
1437: AND FCT.TIME_ID = TIME.ID

Line 1482: PJI_PMV_ORGZ_DIM_TMP TORG,

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
1486: AND FCT.TIME_ID = TIME.ID

Line 1510: , pji_pmv_orgz_dim_tmp org

1506: SELECT DISTINCT prj.project_id, '-1' name
1507: FROM
1508: pji_project_classes PJM
1509: , pji_pmv_cls_dim_tmp PTM
1510: , pji_pmv_orgz_dim_tmp org
1511: , pa_projects_all prj
1512: WHERE
1513: pjm.project_class_id = ptm.id
1514: AND prj.project_id = pjm.project_id

Line 2039: PJI_PMV_ORGZ_DIM_TMP HORG,

2035: 0,
2036: 0,
2037: 0
2038: FROM PJI_PMV_TIME_DIM_TMP TIME,
2039: PJI_PMV_ORGZ_DIM_TMP HORG,
2040: PJI_AC_ORGO_F_MV FCT,
2041: PJI_PMV_ORG_DIM_TMP HOU
2042: WHERE FCT.ORG_ID = HOU.ID
2043: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2075: PJI_PMV_ORGZ_DIM_TMP HORG,

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
2079: AND FCT.ORGANIZATION_ID = HORG.ID

Line 2107: FROM PJI_PMV_ORGZ_DIM_TMP

2103: 0 LOST_BACKLOG, 0 LOST_BACKLOG_ITD, 0 BACKLOG,
2104: 0 BACKLOG_ITD, 0 REVENUE_AT_RISK,
2105: 0 REVENUE_AT_RISK_ITD,
2106: 0,0,0,0,0,0,0,0,0,0
2107: FROM PJI_PMV_ORGZ_DIM_TMP
2108: WHERE NAME <> '-1'
2109: UNION ALL
2110: SELECT '-1' ORG_ID, '-1' ORGANIZATION_ID, NAME TIME_ID,
2111: ID TIME_KEY, '-1' PROJECT_CLASS_ID,

Line 2190: PJI_PMV_ORGZ_DIM_TMP HORG,

2186: 0,
2187: 0,
2188: 0
2189: FROM PJI_PMV_TIME_DIM_TMP TIME,
2190: PJI_PMV_ORGZ_DIM_TMP HORG,
2191: PJI_PMV_CLS_DIM_TMP CLS,
2192: PJI_AC_CLSO_F_MV FCT,
2193: PJI_PMV_ORG_DIM_TMP HOU
2194: WHERE FCT.PROJECT_ORG_ID = HOU.ID

Line 2228: PJI_PMV_ORGZ_DIM_TMP HORG,

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
2232: WHERE FCT.PROJECT_ORG_ID = HOU.ID

Line 2280: FROM PJI_PMV_ORGZ_DIM_TMP

2276: 0,
2277: 0,
2278: 0,
2279: 0
2280: FROM PJI_PMV_ORGZ_DIM_TMP
2281: WHERE NAME <> '-1'
2282: UNION ALL
2283: SELECT '-1' ORG_ID, '-1' ORGANIZATION_ID, NAME TIME_ID,
2284: ID TIME_KEY, '-1' PROJECT_CLASS_ID,