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_ENGINE dependencies on DUAL

Line 550: FROM SYS.DUAL; -- REMOVE THIS COMMENT WHEN THE ISSUE WITH DUAL IS RESOLVED.

546: END IF;
547: l_Parse_Status:='Y';
548: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
549: SELECT -1, '-1'
550: FROM SYS.DUAL; -- REMOVE THIS COMMENT WHEN THE ISSUE WITH DUAL IS RESOLVED.
551: ELSE
552: IF p_PA_DEBUG_MODE = 'Y' THEN
553: Write2FWKLog('No need to go the class fact.');
554: END IF;

Line 4280: FROM fii_time_day, dual

4276: Write2FWKLog('Creating day slice for the given week.');
4277: INSERT INTO PJI_PMV_TIME_DIM_TMP
4278: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4279: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4280: FROM fii_time_day, dual
4281: WHERE week_id = l_week_id_tmp
4282: AND report_date <= l_date;
4283:
4284: IF p_parse_prior IS NOT NULL THEN

Line 4308: FROM fii_time_day, dual

4304:
4305: INSERT INTO PJI_PMV_TIME_DIM_TMP
4306: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4307: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4308: FROM fii_time_day, dual
4309: WHERE ent_period_id = l_period_id_tmp
4310: AND report_date <= l_date;
4311:
4312: IF p_parse_prior IS NOT NULL THEN

Line 4328: FROM fii_time_cal_day_mv, dual

4324:
4325: INSERT INTO PJI_PMV_TIME_DIM_TMP
4326: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4327: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4328: FROM fii_time_cal_day_mv, dual
4329: WHERE cal_period_id = l_period_id_tmp
4330: AND calendar_id = l_calendar_id
4331: AND report_date <= l_date;
4332:

Line 4358: FROM fii_time_ent_period, dual

4354:
4355: INSERT INTO PJI_PMV_TIME_DIM_TMP
4356: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4357: SELECT ent_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4358: FROM fii_time_ent_period, dual
4359: WHERE ent_qtr_id = l_qtr_id_tmp
4360: AND start_date < l_period_start_date_tmp;
4361:
4362: ELSIF l_is_GL IS NOT NULL THEN

Line 4368: FROM fii_time_cal_period, dual

4364:
4365: INSERT INTO PJI_PMV_TIME_DIM_TMP
4366: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4367: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4368: FROM fii_time_cal_period, dual
4369: WHERE cal_qtr_id = l_qtr_id_tmp
4370: AND calendar_id = l_calendar_id
4371: AND start_date < l_period_start_date_tmp;
4372: END IF;

Line 4386: FROM fii_time_ent_qtr, dual

4382:
4383: INSERT INTO PJI_PMV_TIME_DIM_TMP
4384: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4385: SELECT ent_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4386: FROM fii_time_ent_qtr, dual
4387: WHERE ent_year_id = l_year_id_tmp
4388: AND start_date < l_qtr_start_date_tmp;
4389:
4390: ELSIF l_is_GL IS NOT NULL THEN

Line 4396: FROM fii_time_cal_qtr, dual

4392:
4393: INSERT INTO PJI_PMV_TIME_DIM_TMP
4394: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4395: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4396: FROM fii_time_cal_qtr, dual
4397: WHERE cal_year_id = l_year_id_tmp
4398: AND calendar_id = l_calendar_id
4399: AND start_date < l_qtr_start_date_tmp;
4400: END IF;

Line 4415: FROM fii_time_ent_year, dual

4411:
4412: INSERT INTO PJI_PMV_TIME_DIM_TMP
4413: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4414: SELECT ent_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4415: FROM fii_time_ent_year, dual
4416: WHERE start_date < l_year_start_date_tmp;
4417:
4418: ELSIF l_is_GL IS NOT NULL THEN
4419: Write2FWKLog('Creating year slice for all previous years - Fiscal Cal.');

Line 4424: FROM fii_time_cal_year, dual

4420:
4421: INSERT INTO PJI_PMV_TIME_DIM_TMP
4422: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4423: SELECT cal_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4424: FROM fii_time_cal_year, dual
4425: WHERE calendar_id = l_calendar_id
4426: AND start_date < l_year_start_date_tmp;
4427: END IF;
4428: END IF;

Line 4456: FROM fii_time_day, dual

4452: Write2FWKLog('Creating day slice for the given week between the two dates - scheduled');
4453: INSERT INTO PJI_PMV_TIME_DIM_TMP
4454: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4455: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4456: FROM fii_time_day, dual
4457: WHERE week_id = l_week_id
4458: AND report_date > l_summ_date
4459: AND report_date <= l_as_of_date;
4460:

Line 4487: FROM fii_time_day, dual

4483:
4484: INSERT INTO PJI_PMV_TIME_DIM_TMP
4485: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4486: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4487: FROM fii_time_day, dual
4488: WHERE ent_period_id = l_period_id
4489: AND report_date > l_summ_date
4490: AND report_date <= l_as_of_date;
4491:

Line 4510: FROM fii_time_cal_day_mv, dual

4506:
4507: INSERT INTO PJI_PMV_TIME_DIM_TMP
4508: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4509: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4510: FROM fii_time_cal_day_mv, dual
4511: WHERE cal_period_id = l_period_id
4512: AND calendar_id = l_calendar_id
4513: AND report_date > l_summ_date
4514: AND report_date <= l_as_of_date;

Line 4542: FROM fii_time_day, dual

4538:
4539: INSERT INTO PJI_PMV_TIME_DIM_TMP
4540: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4541: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4542: FROM fii_time_day, dual
4543: WHERE ent_period_id = l_period_id_s
4544: AND report_date > l_summ_date;
4545:
4546: IF p_parse_prior IS NOT NULL THEN

Line 4562: FROM fii_time_day, dual

4558:
4559: INSERT INTO PJI_PMV_TIME_DIM_TMP
4560: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4561: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4562: FROM fii_time_day, dual
4563: WHERE ent_period_id = l_period_id
4564: AND report_date <= l_as_of_date;
4565:
4566: IF p_parse_prior IS NOT NULL THEN

Line 4582: FROM fii_time_cal_day_mv, dual

4578:
4579: INSERT INTO PJI_PMV_TIME_DIM_TMP
4580: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4581: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4582: FROM fii_time_cal_day_mv, dual
4583: WHERE cal_period_id = l_period_id_s
4584: AND calendar_id = l_calendar_id
4585: AND report_date > l_summ_date;
4586:

Line 4603: FROM fii_time_cal_day_mv, dual

4599:
4600: INSERT INTO PJI_PMV_TIME_DIM_TMP
4601: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4602: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4603: FROM fii_time_cal_day_mv, dual
4604: WHERE cal_period_id = l_period_id
4605: AND calendar_id = l_calendar_id
4606: AND report_date <= l_as_of_date;
4607:

Line 4640: FROM fii_time_ent_period, dual

4636:
4637: INSERT INTO PJI_PMV_TIME_DIM_TMP
4638: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4639: SELECT ent_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4640: FROM fii_time_ent_period, dual
4641: WHERE ent_qtr_id = l_qtr_id
4642: AND start_date < l_period_start_date
4643: AND start_date > l_period_start_date_s;
4644:

Line 4651: FROM fii_time_cal_period, dual

4647:
4648: INSERT INTO PJI_PMV_TIME_DIM_TMP
4649: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4650: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4651: FROM fii_time_cal_period, dual
4652: WHERE cal_qtr_id = l_qtr_id_s
4653: AND calendar_id = l_calendar_id
4654: AND start_date < l_period_start_date
4655: AND start_date > l_period_start_date_s;

Line 4672: FROM fii_time_ent_period, dual

4668:
4669: INSERT INTO PJI_PMV_TIME_DIM_TMP
4670: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4671: SELECT ent_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4672: FROM fii_time_ent_period, dual
4673: WHERE ent_qtr_id = l_qtr_id_s
4674: AND start_date > l_period_start_date_s;
4675:
4676: Write2FWKLog('Creating period slice for the as_of_date quarter - Enterprise Cal - scheduled');

Line 4681: FROM fii_time_ent_period, dual

4677:
4678: INSERT INTO PJI_PMV_TIME_DIM_TMP
4679: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4680: SELECT ent_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4681: FROM fii_time_ent_period, dual
4682: WHERE ent_qtr_id = l_qtr_id
4683: AND start_date < l_period_start_date;
4684:
4685: ELSIF l_is_GL IS NOT NULL THEN

Line 4691: FROM fii_time_cal_period, dual

4687:
4688: INSERT INTO PJI_PMV_TIME_DIM_TMP
4689: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4690: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4691: FROM fii_time_cal_period, dual
4692: WHERE cal_qtr_id = l_qtr_id_s
4693: AND calendar_id = l_calendar_id
4694: AND start_date > l_period_start_date_s;
4695:

Line 4701: FROM fii_time_cal_period, dual

4697:
4698: INSERT INTO PJI_PMV_TIME_DIM_TMP
4699: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4700: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4701: FROM fii_time_cal_period, dual
4702: WHERE cal_qtr_id = l_qtr_id
4703: AND calendar_id = l_calendar_id
4704: AND start_date < l_period_start_date;
4705:

Line 4726: FROM fii_time_ent_qtr, dual

4722:
4723: INSERT INTO PJI_PMV_TIME_DIM_TMP
4724: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4725: SELECT ent_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4726: FROM fii_time_ent_qtr, dual
4727: WHERE ent_year_id = l_year_id
4728: AND start_date < l_qtr_start_date
4729: AND start_date > l_qtr_start_date_s;
4730:

Line 4737: FROM fii_time_cal_qtr, dual

4733:
4734: INSERT INTO PJI_PMV_TIME_DIM_TMP
4735: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4736: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4737: FROM fii_time_cal_qtr, dual
4738: WHERE cal_year_id = l_year_id
4739: AND calendar_id = l_calendar_id
4740: AND start_date < l_qtr_start_date
4741: AND start_date > l_qtr_start_date_s;

Line 4758: FROM fii_time_ent_qtr, dual

4754:
4755: INSERT INTO PJI_PMV_TIME_DIM_TMP
4756: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4757: SELECT ent_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4758: FROM fii_time_ent_qtr, dual
4759: WHERE ent_year_id = l_year_id_s
4760: AND start_date > l_qtr_start_date_s;
4761:
4762: Write2FWKLog('Creating quarter slice for the as_of_date year - Enterprise Cal - scheduled');

Line 4767: FROM fii_time_ent_qtr, dual

4763:
4764: INSERT INTO PJI_PMV_TIME_DIM_TMP
4765: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4766: SELECT ent_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4767: FROM fii_time_ent_qtr, dual
4768: WHERE ent_year_id = l_year_id
4769: AND start_date < l_qtr_start_date;
4770:
4771:

Line 4778: FROM fii_time_cal_qtr, dual

4774:
4775: INSERT INTO PJI_PMV_TIME_DIM_TMP
4776: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4777: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4778: FROM fii_time_cal_qtr, dual
4779: WHERE cal_year_id = l_year_id_s
4780: AND calendar_id = l_calendar_id
4781: AND start_date > l_qtr_start_date_s;
4782:

Line 4788: FROM fii_time_cal_qtr, dual

4784:
4785: INSERT INTO PJI_PMV_TIME_DIM_TMP
4786: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4787: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4788: FROM fii_time_cal_qtr, dual
4789: WHERE cal_year_id = l_year_id
4790: AND calendar_id = l_calendar_id
4791: AND start_date < l_qtr_start_date;
4792:

Line 4811: FROM fii_time_ent_year, dual

4807:
4808: INSERT INTO PJI_PMV_TIME_DIM_TMP
4809: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4810: SELECT ent_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4811: FROM fii_time_ent_year, dual
4812: WHERE start_date < l_year_start_date
4813: AND start_date > l_year_start_date_s;
4814:
4815: ELSIF l_is_GL IS NOT NULL THEN

Line 4821: FROM fii_time_cal_year, dual

4817:
4818: INSERT INTO PJI_PMV_TIME_DIM_TMP
4819: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4820: SELECT cal_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4821: FROM fii_time_cal_year, dual
4822: WHERE calendar_id = l_calendar_id
4823: AND start_date < l_year_start_date
4824: AND start_date > l_year_start_date_s;
4825: END IF;