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

Line 1803: select 4 INVERT_ID from dual union all

1799: ) spread_bl
1800: ---- end of third inline view 'spread_bl'...........
1801: ,
1802: (
1803: select 4 INVERT_ID from dual union all
1804: select 8 INVERT_ID from dual union all
1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1806: ) invert
1807: ) collapse_bl

Line 1804: select 8 INVERT_ID from dual union all

1800: ---- end of third inline view 'spread_bl'...........
1801: ,
1802: (
1803: select 4 INVERT_ID from dual union all
1804: select 8 INVERT_ID from dual union all
1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1806: ) invert
1807: ) collapse_bl
1808: ---- End of second inline view 'collapse_bl' ..........

Line 1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

1801: ,
1802: (
1803: select 4 INVERT_ID from dual union all
1804: select 8 INVERT_ID from dual union all
1805: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
1806: ) invert
1807: ) collapse_bl
1808: ---- End of second inline view 'collapse_bl' ..........
1809: GROUP BY

Line 2882: select 1 INVERT_ID from dual union all

2878: ) spread_bl
2879: ---- end of third inline view 'spread_bl'...........
2880: ,
2881: (
2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

2879: ---- end of third inline view 'spread_bl'...........
2880: ,
2881: (
2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert

Line 2884: select 4 INVERT_ID from dual union all

2880: ,
2881: (
2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert
2888: ) collapse_bl

Line 2885: select 8 INVERT_ID from dual union all

2881: (
2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert
2888: ) collapse_bl
2889: ---- End of second inline view 'collapse_bl' ..........

Line 2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

2882: select 1 INVERT_ID from dual union all
2883: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
2884: select 4 INVERT_ID from dual union all
2885: select 8 INVERT_ID from dual union all
2886: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
2887: ) invert
2888: ) collapse_bl
2889: ---- End of second inline view 'collapse_bl' ..........
2890: GROUP BY

Line 3900: select 1 INVERT_ID from dual union all

3896: ) spread_bl
3897: ---- end of third inline view 'spread_bl'...........
3898: ,
3899: (
3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

3897: ---- end of third inline view 'spread_bl'...........
3898: ,
3899: (
3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert

Line 3902: select 4 INVERT_ID from dual union all

3898: ,
3899: (
3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert
3906: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909

Line 3903: select 8 INVERT_ID from dual union all

3899: (
3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert
3906: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
3907: ---- End of second inline view 'collapse_bl' ..........

Line 3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

3900: select 1 INVERT_ID from dual union all
3901: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
3902: select 4 INVERT_ID from dual union all
3903: select 8 INVERT_ID from dual union all
3904: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3905: ) invert
3906: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
3907: ---- End of second inline view 'collapse_bl' ..........
3908: GROUP BY

Line 4872: select 4 INVERT_ID from dual union all

4868: ) spread_bl
4869: ---- end of third inline view 'spread_bl'...........
4870: ,
4871: (
4872: select 4 INVERT_ID from dual union all
4873: select 8 INVERT_ID from dual union all
4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4875: ) invert
4876: ) collapse_bl

Line 4873: select 8 INVERT_ID from dual union all

4869: ---- end of third inline view 'spread_bl'...........
4870: ,
4871: (
4872: select 4 INVERT_ID from dual union all
4873: select 8 INVERT_ID from dual union all
4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4875: ) invert
4876: ) collapse_bl
4877: ---- End of second inline view 'collapse_bl' ..........

Line 4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4870: ,
4871: (
4872: select 4 INVERT_ID from dual union all
4873: select 8 INVERT_ID from dual union all
4874: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4875: ) invert
4876: ) collapse_bl
4877: ---- End of second inline view 'collapse_bl' ..........
4878: GROUP BY

Line 5297: FROM DUAL;

5293: -- Todo: Remove hardcoded currency codes after making code work if one of the global currencies is null.
5294: --
5295: SELECT DECODE(g_global1_currency_code, NULL, 'USD', g_global1_currency_code)
5296: INTO g_global1_currency_code
5297: FROM DUAL;
5298:
5299: SELECT DECODE(g_global2_currency_code, NULL, 'USD', g_global2_currency_code)
5300: INTO g_global2_currency_code
5301: FROM DUAL;

Line 5301: FROM DUAL;

5297: FROM DUAL;
5298:
5299: SELECT DECODE(g_global2_currency_code, NULL, 'USD', g_global2_currency_code)
5300: INTO g_global2_currency_code
5301: FROM DUAL;
5302:
5303: print_time(' Got global currency settings. ');
5304: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
5305: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global1_currency_code ' || g_global1_currency_code );

Line 5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL

5782: -- , 0 prg_level
5783: , fact.plan_type_code plan_type_code -- 4471527
5784: FROM pji_fp_aggr_pjp1_t fact
5785: , pa_projects_all ppa
5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5789: ) curr
5790: , PJI_FM_AGGR_DLY_RATES_T rates

Line 5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL

5784: FROM pji_fp_aggr_pjp1_t fact
5785: , pa_projects_all ppa
5786: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5787: UNION
5788: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5789: ) curr
5790: , PJI_FM_AGGR_DLY_RATES_T rates
5791: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5792: UNION ALL

Line 5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL

5894: -- , 0 prg_level
5895: , fact.plan_type_code plan_type_code -- 4471527
5896: FROM pji_fp_xbs_accum_f fact
5897: , pa_projects_all ppa
5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5901: ) curr
5902: , PJI_FM_AGGR_DLY_RATES_T rates

Line 5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL

5896: FROM pji_fp_xbs_accum_f fact
5897: , pa_projects_all ppa
5898: , ( SELECT g_global1_currency_code curr_code, 0.01 mau FROM DUAL
5899: UNION
5900: SELECT g_global2_currency_code curr_code, 0.01 mau FROM DUAL
5901: ) curr
5902: , PJI_FM_AGGR_DLY_RATES_T rates
5903: , ( SELECT cal_period_id period_id, start_date, end_date FROM pji_time_cal_period_v
5904: UNION ALL

Line 7156: SELECT 4 INVERT_ID FROM dual UNION ALL

7152: ) spread_bl
7153: ---- end of third inline view 'spread_bl'...........
7154: ,
7155: (
7156: SELECT 4 INVERT_ID FROM dual UNION ALL
7157: SELECT 8 INVERT_ID FROM dual UNION ALL
7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
7159: ) invert
7160: ) collapse_bl

Line 7157: SELECT 8 INVERT_ID FROM dual UNION ALL

7153: ---- end of third inline view 'spread_bl'...........
7154: ,
7155: (
7156: SELECT 4 INVERT_ID FROM dual UNION ALL
7157: SELECT 8 INVERT_ID FROM dual UNION ALL
7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
7159: ) invert
7160: ) collapse_bl
7161: ---- End of second inline view 'collapse_bl' ..........

Line 7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

7154: ,
7155: (
7156: SELECT 4 INVERT_ID FROM dual UNION ALL
7157: SELECT 8 INVERT_ID FROM dual UNION ALL
7158: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
7159: ) invert
7160: ) collapse_bl
7161: ---- End of second inline view 'collapse_bl' ..........
7162: GROUP BY

Line 9233: FROM DUAL

9229: DECLARE
9230: BEGIN
9231: SELECT 'Y'
9232: INTO l_dangling_flag
9233: FROM DUAL
9234: WHERE EXISTS(
9235: SELECT 1
9236: FROM pji_fp_aggr_pjp1_t
9237: WHERE ( time_dangling_flag IS NOT NULL

Line 9521: FROM DUAL;

9517: , l_last_update_date last_update_date
9518: , l_last_updated_by last_updated_by
9519: , l_created_by created_by
9520: , l_last_update_login last_update_login
9521: FROM DUAL;
9522:
9523: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
9524:
9525: EXCEPTION

Line 9583: , ( SELECT 1 cal_type FROM DUAL -- 1 GL, 2 PA.

9579: FROM pa_implementations_all imp
9580: , gl_sets_of_books sob
9581: , pa_projects_all proj
9582: , pji_fm_extr_plnver3_t ver
9583: , ( SELECT 1 cal_type FROM DUAL -- 1 GL, 2 PA.
9584: UNION ALL
9585: SELECT 2 FROM DUAL
9586: ) split_cal
9587: WHERE 1=1

Line 9585: SELECT 2 FROM DUAL

9581: , pa_projects_all proj
9582: , pji_fm_extr_plnver3_t ver
9583: , ( SELECT 1 cal_type FROM DUAL -- 1 GL, 2 PA.
9584: UNION ALL
9585: SELECT 2 FROM DUAL
9586: ) split_cal
9587: WHERE 1=1
9588: AND proj.org_id=imp.org_id
9589: AND ver.project_id = proj.project_id