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

Line 496: select 1 INVERT_ID from dual

492: ) src2,
493: PA_PROJECTS_ALL prj,
494: PJI_ORG_EXTR_INFO info,
495: (
496: select 1 INVERT_ID from dual
497: where l_g1_currency_code is not null union all
498: select 2 INVERT_ID from dual
499: where l_g2_currency_flag = 'Y' and
500: l_g2_currency_code is not null union all

Line 498: select 2 INVERT_ID from dual

494: PJI_ORG_EXTR_INFO info,
495: (
496: select 1 INVERT_ID from dual
497: where l_g1_currency_code is not null union all
498: select 2 INVERT_ID from dual
499: where l_g2_currency_flag = 'Y' and
500: l_g2_currency_code is not null union all
501: select 4 INVERT_ID from dual union all
502: select 8 INVERT_ID from dual

Line 501: select 4 INVERT_ID from dual union all

497: where l_g1_currency_code is not null union all
498: select 2 INVERT_ID from dual
499: where l_g2_currency_flag = 'Y' and
500: l_g2_currency_code is not null union all
501: select 4 INVERT_ID from dual union all
502: select 8 INVERT_ID from dual
503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
504: -- where l_txn_currency_flag = 'Y' union all
505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 502: select 8 INVERT_ID from dual

498: select 2 INVERT_ID from dual
499: where l_g2_currency_flag = 'Y' and
500: l_g2_currency_code is not null union all
501: select 4 INVERT_ID from dual union all
502: select 8 INVERT_ID from dual
503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
504: -- where l_txn_currency_flag = 'Y' union all
505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
506: -- where l_g1_currency_code is not null union all

Line 503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI

499: where l_g2_currency_flag = 'Y' and
500: l_g2_currency_code is not null union all
501: select 4 INVERT_ID from dual union all
502: select 8 INVERT_ID from dual
503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
504: -- where l_txn_currency_flag = 'Y' union all
505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
506: -- where l_g1_currency_code is not null union all
507: -- select 64 INVERT_ID from dual

Line 505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

501: select 4 INVERT_ID from dual union all
502: select 8 INVERT_ID from dual
503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
504: -- where l_txn_currency_flag = 'Y' union all
505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
506: -- where l_g1_currency_code is not null union all
507: -- select 64 INVERT_ID from dual
508: -- where l_g2_currency_flag = 'Y' and
509: -- l_g2_currency_code is not null union all

Line 507: -- select 64 INVERT_ID from dual

503: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
504: -- where l_txn_currency_flag = 'Y' union all
505: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
506: -- where l_g1_currency_code is not null union all
507: -- select 64 INVERT_ID from dual
508: -- where l_g2_currency_flag = 'Y' and
509: -- l_g2_currency_code is not null union all
510: -- select 128 INVERT_ID from dual union all
511: -- select 256 INVERT_ID from dual

Line 510: -- select 128 INVERT_ID from dual union all

506: -- where l_g1_currency_code is not null union all
507: -- select 64 INVERT_ID from dual
508: -- where l_g2_currency_flag = 'Y' and
509: -- l_g2_currency_code is not null union all
510: -- select 128 INVERT_ID from dual union all
511: -- select 256 INVERT_ID from dual
512: ) invert
513: where
514: src2.PROJECT_ID = prj.PROJECT_ID and

Line 511: -- select 256 INVERT_ID from dual

507: -- select 64 INVERT_ID from dual
508: -- where l_g2_currency_flag = 'Y' and
509: -- l_g2_currency_code is not null union all
510: -- select 128 INVERT_ID from dual union all
511: -- select 256 INVERT_ID from dual
512: ) invert
513: where
514: src2.PROJECT_ID = prj.PROJECT_ID and
515: nvl(src2.PROJECT_ORG_ID, -1) = nvl(info.ORG_ID, -1)