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_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_CAL_QTR

Line 461: , pji_time_CAL_QTR qtr

457: , fact1.plan_type_code plan_type_code /* 4471527 */
458: FROM
459: pji_fp_aggr_pjp1 fact1
460: , pji_time_CAL_PERIOD period
461: , pji_time_CAL_QTR qtr
462: WHERE
463: fact1.calendar_type = 'P'
464: AND period.cal_period_id = fact1.time_id
465: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 690: , pji_time_CAL_QTR qtr

686: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
687: FROM
688: pji_fp_aggr_pjp1 fact1
689: , pji_time_CAL_PERIOD period
690: , pji_time_CAL_QTR qtr
691: WHERE
692: fact1.calendar_type = l_calendar_type
693: AND period.cal_period_id = fact1.time_id
694: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1003: , pji_time_CAL_QTR qtr

999: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1000: FROM
1001: PJI_FP_AGGR_PJP1 fact1
1002: , pji_time_CAL_PERIOD period
1003: , pji_time_CAL_QTR qtr
1004: , pji_fm_extr_plnver4 ver
1005: WHERE
1006: -- cal type changes for bug 6381284
1007: --fact1.calendar_type = p_calendar_type

Line 1216: , pji_time_CAL_QTR qtr

1212: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
1213: FROM
1214: PJI_FP_AGGR_PJP1 fact1
1215: , pji_time_CAL_PERIOD period
1216: , pji_time_CAL_QTR qtr
1217: , pji_fm_extr_plnver4 ver
1218: WHERE
1219: fact1.calendar_type = p_calendar_type
1220: AND period.cal_period_id = fact1.time_id

Line 1472: , pji_time_CAL_QTR qtr

1468: , SUM(fact1.CUSTOM15)
1469: FROM
1470: PJI_AC_AGGR_PJP1 fact1
1471: , pji_time_CAL_PERIOD period
1472: , pji_time_CAL_QTR qtr
1473: WHERE
1474: fact1.calendar_type = 'P'
1475: AND period.cal_period_id = fact1.time_id
1476: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1655: , pji_time_CAL_QTR qtr

1651: , SUM(fact1.CUSTOM15)
1652: FROM
1653: PJI_AC_AGGR_PJP1 fact1
1654: , pji_time_CAL_PERIOD period
1655: , pji_time_CAL_QTR qtr
1656: WHERE
1657: fact1.calendar_type = 'G'
1658: AND period.cal_period_id = fact1.time_id
1659: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 2043: , pji_time_CAL_QTR qtr

2039: , SUM(fact1.CUSTOM15)
2040: FROM
2041: PJI_AC_AGGR_PJP1 fact1
2042: , pji_time_CAL_PERIOD period
2043: , pji_time_CAL_QTR qtr
2044: WHERE
2045: fact1.calendar_type = p_calendar_type
2046: AND period.cal_period_id = fact1.time_id
2047: AND period.cal_qtr_id = qtr.cal_qtr_id