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_ORG_DIM_TMP

Line 400: , pji_pmv_org_dim_tmp HOU

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

Line 430: , pji_pmv_org_dim_tmp HOU

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

Line 460: , pji_pmv_org_dim_tmp HOU

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

Line 491: , pji_pmv_org_dim_tmp HOU

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

Line 521: , pji_pmv_org_dim_tmp HOU

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
524: AND FCT.organization_id = HORG.id
525: AND FCT.time_id BETWEEN p_As_Of_Date-l_BTB_Days AND p_As_Of_Date

Line 549: , pji_pmv_org_dim_tmp HOU

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
552: FCT.org_id = HOU.id
553: AND FCT.organization_id = HORG.id

Line 575: FROM pji_pmv_org_dim_tmp

571: , 0 btb_revenue
572: , 0
573: , 0 prior_btb_total_bookings
574: , 0 prior_btb_revenue
575: FROM pji_pmv_org_dim_tmp
576: WHERE name <> '-1'
577: UNION ALL
578: SELECT '-1' org_id
579: , name organization_id

Line 677: , pji_pmv_org_dim_tmp HOU

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
679: FCT.project_org_id = HOU.id
680: AND FCT.project_organization_id = HORG.id
681: AND FCT.time_id = TIME.id

Line 709: , pji_pmv_org_dim_tmp HOU

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
711: FCT.project_org_id = HOU.id
712: AND FCT.project_organization_id = HORG.id
713: AND FCT.time_id = TIME.id

Line 741: , pji_pmv_org_dim_tmp HOU

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
743: FCT.project_org_id = HOU.id
744: AND FCT.project_organization_id = HORG.id
745: AND FCT.time_id = TIME.id

Line 774: , pji_pmv_org_dim_tmp HOU

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
776: FCT.project_org_id = HOU.id
777: AND FCT.project_organization_id = HORG.id
778: AND FCT.time_id = TIME.id

Line 806: , pji_pmv_org_dim_tmp HOU

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
808: FCT.project_org_id = HOU.id
809: AND FCT.project_organization_id = HORG.id
810: AND FCT.time_id BETWEEN p_As_Of_Date-l_BTB_Days AND p_As_Of_Date

Line 836: , pji_pmv_org_dim_tmp HOU

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
838: FCT.project_org_id = HOU.id
839: AND FCT.project_organization_id = HORG.id
840: AND FCT.time_id BETWEEN l_BTB_C_As_Of_Date-l_BTB_Days AND l_BTB_C_As_Of_Date

Line 862: FROM pji_pmv_org_dim_tmp

858: , 0 btb_revenue
859: , 0
860: , 0 prior_btb_total_bookings
861: , 0 prior_btb_revenue
862: FROM pji_pmv_org_dim_tmp
863: WHERE name <> '-1'
864: UNION ALL
865: SELECT '-1' org_id
866: , name organization_id

Line 1435: PJI_PMV_ORG_DIM_TMP TOU

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
1438: AND TIME.ID IS NOT NULL
1439: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 1484: PJI_PMV_ORG_DIM_TMP TOU

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
1487: AND TIME.ID IS NOT NULL
1488: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 1652: PJI_PMV_ORG_DIM_TMP TOU

1648: 0
1649: FROM PJI_PMV_TIME_DIM_TMP TIME,
1650: PJI_PMV_PRJ_DIM_TMP TPRJ,
1651: PJI_AC_PROJ_F FCT,
1652: PJI_PMV_ORG_DIM_TMP TOU
1653: WHERE FCT.PROJECT_ORG_ID = TOU.ID
1654: AND FCT.TIME_ID = TIME.ID
1655: AND TIME.ID IS NOT NULL
1656: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 1701: PJI_PMV_ORG_DIM_TMP TOU

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
1703: AND FCT.TIME_ID = TIME.ID
1704: AND TIME.ID IS NOT NULL
1705: AND FCT.PERIOD_TYPE_ID = TIME.PERIOD_TYPE

Line 2041: PJI_PMV_ORG_DIM_TMP HOU

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
2044: AND FCT.TIME_ID = TIME.ID
2045: AND TIME.ID IS NOT NULL

Line 2077: PJI_PMV_ORG_DIM_TMP HOU

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
2080: AND FCT.TIME_ID = TIME.ID
2081: AND TIME.ID IS NOT NULL

Line 2095: FROM PJI_PMV_ORG_DIM_TMP

2091: 0 LOST_BACKLOG, 0 LOST_BACKLOG_ITD, 0 BACKLOG,
2092: 0 BACKLOG_ITD, 0 REVENUE_AT_RISK,
2093: 0 REVENUE_AT_RISK_ITD,
2094: 0,0,0,0,0,0,0,0,0,0
2095: FROM PJI_PMV_ORG_DIM_TMP
2096: WHERE NAME <> '-1'
2097: UNION ALL
2098: SELECT '-1' ORG_ID, NAME ORGANIZATION_ID, '-1' TIME_ID,
2099: -1 TIME_KEY, '-1' PROJECT_CLASS_ID,

Line 2193: PJI_PMV_ORG_DIM_TMP HOU

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
2195: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2196: AND FCT.TIME_ID = TIME.ID
2197: AND TIME.ID IS NOT NULL

Line 2231: PJI_PMV_ORG_DIM_TMP HOU

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
2233: AND FCT.PROJECT_ORGANIZATION_ID = HORG.ID
2234: AND FCT.TIME_ID = TIME.ID
2235: AND TIME.ID IS NOT NULL

Line 2259: FROM PJI_PMV_ORG_DIM_TMP

2255: 0,
2256: 0,
2257: 0,
2258: 0
2259: FROM PJI_PMV_ORG_DIM_TMP
2260: WHERE NAME <> '-1'
2261: UNION ALL
2262: SELECT '-1' ORG_ID, NAME ORGANIZATION_ID, '-1' TIME_ID,
2263: -1 TIME_KEY, '-1' PROJECT_CLASS_ID,