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

Line 790: select 1 INVERT_ID from dual

786: ) src2,
787: PA_PROJECTS_ALL prj,
788: PJI_ORG_EXTR_INFO info,
789: (
790: select 1 INVERT_ID from dual
791: where l_g1_currency_code is not null union all
792: select 2 INVERT_ID from dual
793: where l_g2_currency_flag = 'Y' and
794: l_g2_currency_code is not null union all

Line 792: select 2 INVERT_ID from dual

788: PJI_ORG_EXTR_INFO info,
789: (
790: select 1 INVERT_ID from dual
791: where l_g1_currency_code is not null union all
792: select 2 INVERT_ID from dual
793: where l_g2_currency_flag = 'Y' and
794: l_g2_currency_code is not null union all
795: select 4 INVERT_ID from dual union all
796: select 8 INVERT_ID from dual

Line 795: select 4 INVERT_ID from dual union all

791: where l_g1_currency_code is not null union all
792: select 2 INVERT_ID from dual
793: where l_g2_currency_flag = 'Y' and
794: l_g2_currency_code is not null union all
795: select 4 INVERT_ID from dual union all
796: select 8 INVERT_ID from dual
797: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
798: -- where l_txn_currency_flag = 'Y' union all
799: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW

Line 796: select 8 INVERT_ID from dual

792: select 2 INVERT_ID from dual
793: where l_g2_currency_flag = 'Y' and
794: l_g2_currency_code is not null union all
795: select 4 INVERT_ID from dual union all
796: select 8 INVERT_ID from dual
797: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
798: -- where l_txn_currency_flag = 'Y' union all
799: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
800: -- where l_g1_currency_code is not null union all

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

793: where l_g2_currency_flag = 'Y' and
794: l_g2_currency_code is not null union all
795: select 4 INVERT_ID from dual union all
796: select 8 INVERT_ID from dual
797: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
798: -- where l_txn_currency_flag = 'Y' union all
799: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
800: -- where l_g1_currency_code is not null union all
801: -- select 64 INVERT_ID from dual

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

795: select 4 INVERT_ID from dual union all
796: select 8 INVERT_ID from dual
797: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
798: -- where l_txn_currency_flag = 'Y' union all
799: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
800: -- where l_g1_currency_code is not null union all
801: -- select 64 INVERT_ID from dual
802: -- where l_g2_currency_flag = 'Y' and
803: -- l_g2_currency_code is not null union all

Line 801: -- select 64 INVERT_ID from dual

797: -- select 16 INVERT_ID from dual OMIT TXN CURRENCY FROM PJI
798: -- where l_txn_currency_flag = 'Y' union all
799: -- select 32 INVERT_ID from dual OMIT DETAIL SLICES FOR NOW
800: -- where l_g1_currency_code is not null union all
801: -- select 64 INVERT_ID from dual
802: -- where l_g2_currency_flag = 'Y' and
803: -- l_g2_currency_code is not null union all
804: -- select 128 INVERT_ID from dual union all
805: -- select 256 INVERT_ID from dual

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

800: -- where l_g1_currency_code is not null union all
801: -- select 64 INVERT_ID from dual
802: -- where l_g2_currency_flag = 'Y' and
803: -- l_g2_currency_code is not null union all
804: -- select 128 INVERT_ID from dual union all
805: -- select 256 INVERT_ID from dual
806: ) invert
807: where
808: src2.PROJECT_ID = prj.PROJECT_ID and

Line 805: -- select 256 INVERT_ID from dual

801: -- select 64 INVERT_ID from dual
802: -- where l_g2_currency_flag = 'Y' and
803: -- l_g2_currency_code is not null union all
804: -- select 128 INVERT_ID from dual union all
805: -- select 256 INVERT_ID from dual
806: ) invert
807: where
808: src2.PROJECT_ID = prj.PROJECT_ID and
809: nvl(src2.PROJECT_ORG_ID, -1) = nvl(info.ORG_ID, -1)