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_RESOURCE_UTILZ dependencies on PJI_TIME_MV

Line 139: FROM pji_time_mv

135: sequence - g_curr_period_seq as order_by_id,
136: 32 as period_type,
137: 1 as amount_type,
138: p_calendar_type as calendar_type
139: FROM pji_time_mv
140: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
141: AND calendar_id = p_calendar_id
142: AND sequence between g_curr_period_seq-g_backward_periods
143: and g_curr_period_seq+g_forward_periods;

Line 151: FROM pji_time_mv lower

147:
148: UPDATE PJI_PMV_TIME_DIM_TMP pmv
149: SET pmv.PRIOR_ID =
150: ( SELECT period_id as prior_id
151: FROM pji_time_mv lower
152: WHERE
153: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
154: AND lower.calendar_id = p_calendar_id
155: AND lower.sequence between g_prev_yr_period_seq-g_backward_periods

Line 187: FROM pji_time_mv

183: 32 as period_type,
184: p_table_amount_type as amount_type,
185: p_calendar_type as calendar_type,
186: 1 as sequence
187: FROM pji_time_mv
188: WHERE period_id = g_curr_period_id
189: and calendar_id = p_calendar_id
190: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
191: UNION ALL

Line 199: FROM pji_time_mv

195: 64 as period_type,
196: p_table_amount_type as amount_type,
197: p_calendar_type as calendar_type,
198: 2 as sequence
199: FROM pji_time_mv
200: WHERE quarter_id = g_curr_quarter_id
201: and calendar_id = p_calendar_id
202: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_QTR', 'FII_TIME_CAL_QTR')
203: UNION ALL

Line 211: FROM pji_time_mv

207: 128 as period_type,
208: p_table_amount_type as amount_type,
209: p_calendar_type as calendar_type,
210: 3 as sequence
211: FROM pji_time_mv
212: WHERE year_id = g_curr_year_id
213: and calendar_id = p_calendar_id
214: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_YEAR', 'FII_TIME_CAL_YEAR')
215: ) r1;

Line 224: FROM pji_time_mv

220: INTO
221: l_prev_period_id,
222: l_prev_quarter_id,
223: l_prev_year_id
224: FROM pji_time_mv
225: WHERE sequence = g_prev_yr_period_seq
226: and calendar_id = p_calendar_id
227: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
228:

Line 315: FROM pji_time_mv

311: sequence - g_curr_period_seq as order_by_id,
312: 32 as period_type,
313: DECODE(sign(sequence-g_last_summ_pd_seq),1,0,-1,1,0,1) as amount_type,
314: p_calendar_type as calendar_type
315: FROM pji_time_mv
316: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
317: AND calendar_id = p_calendar_id
318: AND sequence between g_curr_period_seq-g_backward_periods
319: and g_curr_period_seq+g_forward_periods;

Line 327: FROM pji_time_mv lower

323:
324: UPDATE PJI_PMV_TIME_DIM_TMP pmv
325: SET pmv.PRIOR_ID =
326: ( SELECT period_id as prior_id
327: FROM pji_time_mv lower
328: WHERE
329: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
330: AND lower.calendar_id = p_calendar_id
331: AND lower.sequence between g_prev_yr_period_seq-g_backward_periods

Line 445: FROM pji_time_mv

441: 1 as order_by_id,
442: 32 as period_type,
443: DECODE(sign(sequence-g_last_summ_pd_seq),1,0,-1,1,0,1) as amount_type,
444: p_calendar_type as calendar_type
445: FROM pji_time_mv
446: WHERE period_id = g_curr_period_id
447: and calendar_id = p_calendar_id
448: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
449: ELSE

Line 487: pji_time_mv pt

483: period_id
484: BULK COLLECT INTO
485: l_curr_period_id_tbl
486: FROM
487: pji_time_mv pt
488: where quarter_id = g_curr_quarter_id
489: and calendar_id = p_calendar_id
490: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
491:

Line 517: FROM pji_time_mv

513: 2 as order_by_id,
514: 32 as period_type,
515: DECODE(sign(sequence-g_last_summ_pd_seq),1,0,-1,1,0,1) as amount_type,
516: p_calendar_type as calendar_type
517: FROM pji_time_mv
518: WHERE quarter_id = g_curr_quarter_id
519: and calendar_id = p_calendar_id
520: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
521: ELSE

Line 591: FROM pji_time_mv

587: INTO
588: l_prev_period_id,
589: l_prev_quarter_id,
590: l_prev_year_id
591: FROM pji_time_mv
592: WHERE sequence = g_prev_yr_period_seq
593: and calendar_id = p_calendar_id
594: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
595:

Line 734: ,pji_time_mv pmv

730: INTO g_last_summ_period_id,
731: g_last_summ_pd_name
732: FROM
733: fii_time_cal_day_mv day
734: ,pji_time_mv pmv
735: WHERE
736: report_date = g_last_summ_date
737: and pmv.period_type = 'FII_TIME_CAL_PERIOD' /* Added this condition for bug 4312361 */
738: AND day.cal_period_id = pmv.period_id

Line 746: FROM pji_time_mv

742:
743: --Get the sequence for the last summarized date period
744: SELECT sequence
745: INTO g_last_summ_pd_seq
746: FROM pji_time_mv
747: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
748: AND period_id = g_last_summ_period_id
749: AND calendar_id = l_calendar_id;
750:

Line 766: FROM pji_time_mv

762: g_curr_quarter_id,
763: g_curr_quarter_name,
764: g_curr_year_id,
765: g_curr_year_name
766: FROM pji_time_mv
767: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
768: AND period_id = p_period_id
769: AND calendar_id = l_calendar_id;
770:

Line 814: FROM pji_time_mv

810:
811: --Get the sequence for the last year corresponding period
812: SELECT NVL(sequence,0)
813: INTO g_prev_yr_period_seq
814: FROM pji_time_mv
815: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
816: AND period_id = g_prev_yr_period_id
817: AND calendar_id = l_calendar_id;
818:

Line 962: FROM pji_time_mv

958:
959: SELECT year
960: INTO
961: l_prev_year_name
962: FROM pji_time_mv
963: WHERE sequence = g_prev_yr_period_seq
964: and calendar_id = l_calendar_id
965: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
966:

Line 1084: pji_time_mv pt

1080: INTO
1081: g_curr_yr_max_sequence,
1082: g_curr_yr_min_sequence
1083: FROM
1084: pji_time_mv pt
1085: WHERE year_id = g_curr_year_id
1086: and calendar_id = l_calendar_id
1087: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
1088:

Line 1241: FROM pji_time_mv

1237:
1238: --Get the sequence for the year
1239: SELECT sequence
1240: INTO l_sequence
1241: FROM pji_time_mv
1242: WHERE
1243: period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_YEAR', 'FII_TIME_CAL_YEAR')
1244: AND calendar_id = l_calendar_id
1245: and year_id in

Line 1248: FROM pji_time_mv

1244: AND calendar_id = l_calendar_id
1245: and year_id in
1246: (
1247: SELECT year_id
1248: FROM pji_time_mv
1249: WHERE period_id = p_period_id
1250: AND calendar_id = l_calendar_id
1251: );
1252:

Line 1269: FROM pji_time_mv

1265: l_period_id_tbl,
1266: l_period_name_tbl,
1267: l_period_status_tbl,
1268: l_period_st_dt_tbl
1269: FROM pji_time_mv
1270: WHERE calendar_id = l_calendar_id
1271: and period_type = 'FII_TIME_ENT_PERIOD'
1272: and year_id in
1273: (

Line 1275: FROM pji_time_mv

1271: and period_type = 'FII_TIME_ENT_PERIOD'
1272: and year_id in
1273: (
1274: SELECT year_id
1275: FROM pji_time_mv
1276: WHERE period_type = 'FII_TIME_ENT_YEAR'
1277: and calendar_id = l_calendar_id
1278: and sequence in
1279: (l_sequence-1,l_sequence,l_sequence+1)

Line 1298: FROM pji_time_mv

1294: (
1295: SELECT period_id,
1296: period_name,
1297: period_start_date
1298: FROM pji_time_mv
1299: WHERE calendar_id = l_calendar_id
1300: and period_type = 'FII_TIME_CAL_PERIOD'
1301: and year_id in
1302: (

Line 1304: FROM pji_time_mv

1300: and period_type = 'FII_TIME_CAL_PERIOD'
1301: and year_id in
1302: (
1303: SELECT year_id
1304: FROM pji_time_mv
1305: WHERE period_type = 'FII_TIME_CAL_YEAR'
1306: and calendar_id = l_calendar_id
1307: and sequence in
1308: (l_sequence-1,l_sequence,l_sequence+1)

Line 1421: --Bug5872158 Make sure SYSDATE is lesser than or equal to the maximum period end date in pji_time_mv

1417: ,x_msg_count => x_msg_count
1418: ,x_msg_data => x_msg_data
1419: );
1420:
1421: --Bug5872158 Make sure SYSDATE is lesser than or equal to the maximum period end date in pji_time_mv
1422: IF ( x_calendar_type = 'E') THEN
1423: --Get for Enterprise period
1424: SELECT period_id,
1425: period_name

Line 1428: FROM pji_time_mv

1424: SELECT period_id,
1425: period_name
1426: INTO x_curr_period_id,
1427: x_curr_period_name
1428: FROM pji_time_mv
1429: WHERE
1430: (SELECT DECODE(SIGN(TRUNC(SYSDATE) - MAX(period_end_date)), 1, MAX(period_end_date), TRUNC(SYSDATE))
1431: FROM pji_time_mv
1432: WHERE 1=1

Line 1431: FROM pji_time_mv

1427: x_curr_period_name
1428: FROM pji_time_mv
1429: WHERE
1430: (SELECT DECODE(SIGN(TRUNC(SYSDATE) - MAX(period_end_date)), 1, MAX(period_end_date), TRUNC(SYSDATE))
1431: FROM pji_time_mv
1432: WHERE 1=1
1433: AND calendar_id = l_calendar_id
1434: AND period_type = 'FII_TIME_ENT_PERIOD') BETWEEN period_start_date and period_end_date
1435: AND calendar_id = l_calendar_id

Line 1443: FROM pji_time_mv

1439: SELECT period_id,
1440: period_name
1441: INTO x_curr_period_id,
1442: x_curr_period_name
1443: FROM pji_time_mv
1444: WHERE
1445: (SELECT DECODE(SIGN(TRUNC(SYSDATE) - MAX(period_end_date)), 1, MAX(period_end_date), TRUNC(SYSDATE))
1446: FROM pji_time_mv
1447: WHERE 1=1

Line 1446: FROM pji_time_mv

1442: x_curr_period_name
1443: FROM pji_time_mv
1444: WHERE
1445: (SELECT DECODE(SIGN(TRUNC(SYSDATE) - MAX(period_end_date)), 1, MAX(period_end_date), TRUNC(SYSDATE))
1446: FROM pji_time_mv
1447: WHERE 1=1
1448: AND calendar_id = l_calendar_id
1449: AND period_type = 'FII_TIME_CAL_PERIOD') BETWEEN period_start_date and period_end_date
1450: AND calendar_id = l_calendar_id