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_T dependencies on PJI_FM_EXTR_PLNVER3_T

Line 219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

215: , 'ENTR'
216: , g_default_prg_level prg_level
217: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
218: FROM
219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: , pji_fm_extr_plnver3_t ver
223: WHERE

Line 222: , pji_fm_extr_plnver3_t ver

218: FROM
219: PJI_FP_AGGR_PJP1_T fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: , pji_fm_extr_plnver3_t ver
223: WHERE
224: fact1.calendar_type = 'E'
225: AND period.ENT_period_id = fact1.time_id
226: AND period.ENT_qtr_id = qtr.ENT_qtr_id

Line 451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

447: , l_line_type line_type
448: , g_default_prg_level prg_level
449: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
450: FROM
451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
452: , pji_time_CAL_PERIOD period
453: , pji_time_CAL_QTR qtr
454: , pji_fm_extr_plnver3_t ver
455: WHERE

Line 454: , pji_fm_extr_plnver3_t ver

450: FROM
451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
452: , pji_time_CAL_PERIOD period
453: , pji_time_CAL_QTR qtr
454: , pji_fm_extr_plnver3_t ver
455: WHERE
456: fact1.calendar_type = 'P'
457: AND period.cal_period_id = fact1.time_id
458: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

692: , l_line_type
693: , g_default_prg_level prg_level
694: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
695: FROM
696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
697: , pji_time_CAL_PERIOD period
698: , pji_time_CAL_QTR qtr
699: , pji_fm_extr_plnver3_t ver
700: WHERE

Line 699: , pji_fm_extr_plnver3_t ver

695: FROM
696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
697: , pji_time_CAL_PERIOD period
698: , pji_time_CAL_QTR qtr
699: , pji_fm_extr_plnver3_t ver
700: WHERE
701: fact1.calendar_type = l_calendar_type
702: AND period.cal_period_id = fact1.time_id
703: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 774: select 1 into l_time_phase_change from PJI_FM_EXTR_PLNVER3_T VER

770: END IF;
771: END IF;
772: /* 4604617 */
773: BEGIN
774: select 1 into l_time_phase_change from PJI_FM_EXTR_PLNVER3_T VER
775: where EXISTS (SELECT 1 FROM PJI_FM_EXTR_PLAN_LINES PL
776: WHERE PL.PROJECT_ID = VER.PROJECT_ID
777: AND PL.PLAN_VERSION_ID = VER.PLAN_VERSION_ID
778: AND PL.PLAN_TYPE_ID = VER.PLAN_TYPE_ID

Line 957: , pji_fm_extr_plnver3_t ver

953: FROM
954: PJI_FP_AGGR_PJP1_T fact1
955: , pji_time_CAL_PERIOD period
956: , pji_time_CAL_QTR qtr
957: , pji_fm_extr_plnver3_t ver
958: WHERE
959: fact1.calendar_type IN ( p_calendar_type
960: , DECODE (p_calendar_type ,'C','G','X')
961: , DECODE (p_calendar_type ,'C','P','X')

Line 1079: , pji_fm_extr_plnver3_t ver

1075: FROM
1076: PJI_FP_AGGR_PJP1_T fact1
1077: , pji_time_CAL_PERIOD period
1078: , pji_time_CAL_QTR qtr
1079: , pji_fm_extr_plnver3_t ver
1080: WHERE
1081: fact1.calendar_type IN ( p_calendar_type
1082: , DECODE (p_calendar_type ,'C','G','X')
1083: , DECODE (p_calendar_type ,'C','P','X')

Line 1518: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

1514: , SUM(CUSTOM15) CUSTOM15
1515: , l_line_type
1516: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1517: FROM
1518: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1519: , pji_fm_extr_plnver3_t ver
1520: WHERE
1521: fact1.calendar_type = l_calendar_type
1522: AND fact1.period_type_id = l_period_type_id

Line 1519: , pji_fm_extr_plnver3_t ver

1515: , l_line_type
1516: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1517: FROM
1518: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1519: , pji_fm_extr_plnver3_t ver
1520: WHERE
1521: fact1.calendar_type = l_calendar_type
1522: AND fact1.period_type_id = l_period_type_id
1523: AND fact1.time_id = l_time_id

Line 1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

1766: , 'PAR'
1767: , g_default_prg_level prg_level
1768: , fact1.plan_type_code plan_type_code /* 4471527 */
1769: FROM
1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1771: , pji_time_CAL_PERIOD period
1772: , pji_time_CAL_QTR qtr
1773: , pji_fm_extr_plnver3_t ver
1774: WHERE

Line 1773: , pji_fm_extr_plnver3_t ver

1769: FROM
1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1771: , pji_time_CAL_PERIOD period
1772: , pji_time_CAL_QTR qtr
1773: , pji_fm_extr_plnver3_t ver
1774: WHERE
1775: fact1.calendar_type = 'P'
1776: AND period.cal_period_id = fact1.time_id
1777: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

2009: , 'GLR'
2010: , g_default_prg_level prg_level
2011: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2012: FROM
2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2014: , pji_time_CAL_PERIOD period
2015: , pji_time_CAL_QTR qtr
2016: , pji_fm_extr_plnver3_t ver
2017: WHERE

Line 2016: , pji_fm_extr_plnver3_t ver

2012: FROM
2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2014: , pji_time_CAL_PERIOD period
2015: , pji_time_CAL_QTR qtr
2016: , pji_fm_extr_plnver3_t ver
2017: WHERE
2018: fact1.calendar_type = 'G'
2019: AND period.cal_period_id = fact1.time_id
2020: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver

2252: , 'ENTR'
2253: , g_default_prg_level prg_level
2254: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2255: FROM
2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2257: , pji_time_ENT_PERIOD period
2258: , pji_time_ENT_QTR qtr
2259: , pji_fm_extr_plnver3_t ver
2260: WHERE

Line 2259: , pji_fm_extr_plnver3_t ver

2255: FROM
2256: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2257: , pji_time_ENT_PERIOD period
2258: , pji_time_ENT_QTR qtr
2259: , pji_fm_extr_plnver3_t ver
2260: WHERE
2261: fact1.calendar_type = 'E'
2262: AND period.ENT_period_id = fact1.time_id
2263: AND period.ENT_qtr_id = qtr.ENT_qtr_id

Line 4159: , pji_fm_extr_plnver3_t ver

4155: , g_default_prg_level prg_level
4156: FROM pji_fp_aggr_pjp1_t fact
4157: , pji_time_cal_period non_pa_cal
4158: , pji_time_ent_period pa_cal
4159: , pji_fm_extr_plnver3_t ver
4160: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4161: AND fact.worker_id = g_worker_id
4162: AND non_pa_cal.cal_period_id = fact.time_id
4163: AND fact.line_type like 'OF%'

Line 4439: , pji_fm_extr_plnver3_t ver

4435: , fact.plan_type_code plan_type_code /* 4471527 */
4436: FROM pji_fp_aggr_pjp1_t fact
4437: , pji_time_cal_period_v non_pa_cal
4438: , pji_time_ent_period_v pa_cal
4439: , pji_fm_extr_plnver3_t ver
4440: , (SELECT currency_code,
4441: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4442: null, 0.01,
4443: 0, 1,

Line 5591: , PJI_FM_EXTR_PLNVER3_T ver

5587: FROM pji_fp_xbs_accum_f fact
5588: , pji_time_cal_period non_pa_cal
5589: -- , pji_org_extr_info orginfo
5590: , pji_time_ent_period pa_cal
5591: , PJI_FM_EXTR_PLNVER3_T ver
5592: WHERE 1 = 1
5593: AND fact.calendar_type IN ('P', 'G')
5594: AND fact.period_type_id = 32
5595: AND non_pa_cal.cal_period_id = fact.time_id

Line 6745: , pji_fm_extr_plnver3_t ver

6741: , fact.rate_dangling_flag rate_dangling_flag
6742: , g_default_prg_level prg_level
6743: FROM pji_fp_aggr_pjp1_t fact
6744: , pji_time_ent_period pa_cal
6745: , pji_fm_extr_plnver3_t ver
6746: WHERE 1=1
6747: AND fact.CALENDAR_TYPE = 'A'
6748: AND fact.worker_id = g_worker_id
6749: AND fact.start_date IS NOT NULL

Line 7030: , pji_fm_extr_plnver3_t ver

7026: / (fact.end_date - fact.start_date+1) factor
7027: , fact.plan_type_code plan_type_code /* 4471527 */
7028: FROM pji_fp_aggr_pjp1_t fact
7029: , pji_time_ent_period_v entCal
7030: , pji_fm_extr_plnver3_t ver
7031: , (SELECT currency_code,
7032: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7033: null, 0.01,
7034: 0, 1,

Line 7254: , pji_fm_extr_plnver3_t ver

7250: FROM pji_fp_aggr_pjp1_t fact
7251: , pji_time_cal_period non_pa_cal
7252: -- , pji_org_extr_info orginfo
7253: , pji_time_ent_period pa_cal
7254: , pji_fm_extr_plnver3_t ver
7255: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7256: AND fact.worker_id = g_worker_id
7257: AND non_pa_cal.cal_period_id = fact.time_id
7258: AND fact.line_type like 'OF%'

Line 7447: , pji_fm_extr_plnver3_t ver

7443: , fact.plan_type_code plan_type_code /* 4471527 */
7444: FROM pji_fp_aggr_pjp1_t fact
7445: , pji_time_cal_period_v non_pa_cal
7446: , pji_time_ent_period_v pa_cal
7447: , pji_fm_extr_plnver3_t ver
7448: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7449: AND fact.worker_id = g_worker_id
7450: AND non_pa_cal.cal_period_id = fact.time_id
7451: AND fact.line_type like 'OF%'

Line 7654: , PJI_FM_EXTR_PLNVER3_T ver

7650: -- , DECODE ('E', 'E', MAX(pa_cal.end_date), 'S', MIN(pa_cal.end_date)) end_date
7651: , g_default_prg_level prg_level
7652: , fact.plan_type_code plan_type_code /* 4471527 */
7653: FROM pji_fp_xbs_accum_f fact
7654: , PJI_FM_EXTR_PLNVER3_T ver
7655: , pji_time_cal_period non_pa_cal
7656: -- , pji_org_extr_info orginfo
7657: , pji_time_ent_period pa_cal
7658: WHERE non_pa_cal.cal_period_id = fact.time_id

Line 7862: , pji_fm_extr_plnver3_t ver

7858: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
7859: , g_default_prg_level prg_level
7860: FROM pji_fp_aggr_pjp1_t fact
7861: , pji_time_ent_period pa_cal
7862: , pji_fm_extr_plnver3_t ver
7863: WHERE fact.CALENDAR_TYPE = 'A'
7864: AND fact.worker_id = g_worker_id
7865: AND fact.line_type = 'NTP'
7866: AND fact.start_date IS NOT NULL

Line 8068: , pji_fm_extr_plnver3_t ver

8064: , g_default_prg_level prg_level
8065: , fact.plan_type_code plan_type_code /* 4471527 */
8066: FROM pji_fp_aggr_pjp1_t fact
8067: , pji_time_ent_period_v pa_cal
8068: , pji_fm_extr_plnver3_t ver
8069: WHERE fact.CALENDAR_TYPE = 'A'
8070: AND fact.worker_id = g_worker_id
8071: AND fact.line_type = 'NTP'
8072: AND fact.start_date IS NOT NULL

Line 9223: , pji_fm_extr_plnver3_t ver

9219: FROM pji_fp_aggr_pjp1_t fact
9220: , pji_time_cal_period non_pa_cal
9221: , pji_org_extr_info orginfo
9222: , pji_time_cal_period pa_cal
9223: , pji_fm_extr_plnver3_t ver
9224: WHERE 1=1
9225: AND fact.CALENDAR_TYPE <> p_calendar_type
9226: AND fact.worker_id = g_worker_id
9227: AND fact.CALENDAR_TYPE IN ('P', 'G')

Line 9514: , pji_fm_extr_plnver3_t ver

9510: FROM
9511: pji_time_cal_period_v pri
9512: , pji_org_extr_info orginfo
9513: , pji_time_cal_period_v sec
9514: , pji_fm_extr_plnver3_t ver
9515: , pa_projects_all ppa
9516: WHERE 1=1
9517: AND ppa.org_id=orginfo.org_id
9518: AND pri.calendar_id in (orginfo.gl_calendar_id,orginfo.pa_calendar_id)

Line 10687: , PJI_FM_EXTR_PLNVER3_T ver

10683: , NULL time_dangling_flag
10684: , NULL rate_dangling_flag
10685: ,fact.plan_type_code plan_type_code /*4471527 */
10686: FROM pji_fp_xbs_accum_f fact
10687: , PJI_FM_EXTR_PLNVER3_T ver
10688: , pji_time_cal_period non_pa_cal
10689: , pji_org_extr_info orginfo
10690: , pji_time_cal_period pa_cal
10691: WHERE 1=1

Line 11846: , pji_fm_extr_plnver3_t ver

11842: , NULL rate_dangling_flag
11843: FROM pji_fp_aggr_pjp1_t fact
11844: , pji_org_extr_info orginfo
11845: , pji_time_cal_period pa_cal
11846: , pji_fm_extr_plnver3_t ver
11847: WHERE 1=1
11848: AND fact.CALENDAR_TYPE = 'A'
11849: AND fact.worker_id = g_worker_id
11850: AND fact.start_date IS NOT NULL

Line 12137: , pji_fm_extr_plnver3_t ver

12133: , fact.plan_type_code plan_type_code /* 4471527 */
12134: FROM pji_fp_aggr_pjp1_t fact
12135: , pji_org_extr_info orginfo
12136: , pji_time_cal_period_v pa_cal
12137: , pji_fm_extr_plnver3_t ver
12138: ,(SELECT currency_code,
12139: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
12140: null, 0.01,
12141: 0, 1,

Line 12367: , pji_fm_extr_plnver3_t ver

12363: FROM pji_fp_aggr_pjp1_t fact
12364: , pji_time_cal_period non_pa_cal
12365: , pji_org_extr_info orginfo
12366: , pji_time_cal_period pa_cal
12367: , pji_fm_extr_plnver3_t ver
12368: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12369: AND fact.worker_id = g_worker_id
12370: AND fact.CALENDAR_TYPE IN ('P', 'G')
12371: AND non_pa_cal.cal_period_id = fact.time_id

Line 12562: , pji_fm_extr_plnver3_t ver

12558: FROM pji_fp_aggr_pjp1_t fact
12559: , pji_time_cal_period_v non_pa_cal
12560: , pji_org_extr_info orginfo
12561: , pji_time_cal_period_v pa_cal
12562: , pji_fm_extr_plnver3_t ver
12563: WHERE fact.CALENDAR_TYPE <> p_calendar_type
12564: AND fact.worker_id = g_worker_id
12565: AND fact.CALENDAR_TYPE IN ('P', 'G')
12566: AND non_pa_cal.cal_period_id = fact.time_id

Line 12774: , PJI_FM_EXTR_PLNVER3_T ver

12770: , NULL RATE_DANGLING_FLAG
12771: , g_default_prg_level prg_level
12772: , fact.plan_type_code plan_type_code /* 4471527 */
12773: FROM pji_fp_xbs_accum_f fact
12774: , PJI_FM_EXTR_PLNVER3_T ver
12775: , pji_time_cal_period non_pa_cal
12776: , pji_org_extr_info orginfo
12777: , pji_time_cal_period pa_cal
12778: WHERE fact.CALENDAR_TYPE <> p_calendar_type

Line 12994: , pji_fm_extr_plnver3_t ver

12990: , g_default_prg_level prg_level
12991: FROM pji_fp_aggr_pjp1_t fact
12992: , pji_org_extr_info orginfo
12993: , pji_time_cal_period pa_cal
12994: , pji_fm_extr_plnver3_t ver
12995: WHERE 1=1
12996: AND fact.CALENDAR_TYPE = 'A'
12997: AND orginfo.org_id = fact.PROJECT_ORG_ID
12998: AND DECODE(p_calendar_type

Line 13206: , pji_fm_extr_plnver3_t ver

13202: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
13203: FROM pji_fp_aggr_pjp1_t fact
13204: , pji_org_extr_info orginfo
13205: , pji_time_cal_period_v pa_cal
13206: , pji_fm_extr_plnver3_t ver
13207: WHERE 1=1
13208: AND fact.CALENDAR_TYPE = 'A'
13209: AND orginfo.org_id = fact.PROJECT_ORG_ID
13210: AND DECODE(p_calendar_type