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

Line 1432: DUAL

1428: -power(2,0) as AVL_RES_COUNT_BKT3,
1429: -power(2,0) as AVL_RES_COUNT_BKT4,
1430: -power(2,0) as AVL_RES_COUNT_BKT5
1431: FROM
1432: DUAL
1433: ORDER BY TIME_ID,
1434: EXPENDITURE_ORGANIZATION_ID;
1435:
1436: BEGIN

Line 1535: SELECT 1 as tmp_index from dual

1531: ABS(nvl(tmp2.available_res_count_bkt4_s, 0)) + ABS(nvl(tmp2.available_res_count_bkt5_s, 0))
1532: ) > 0
1533: ) rt1,
1534: (
1535: SELECT 1 as tmp_index from dual
1536: UNION ALL
1537: SELECT 2 as tmp_index from dual
1538: ) rt2
1539: UNION ALL

Line 1537: SELECT 2 as tmp_index from dual

1533: ) rt1,
1534: (
1535: SELECT 1 as tmp_index from dual
1536: UNION ALL
1537: SELECT 2 as tmp_index from dual
1538: ) rt2
1539: UNION ALL
1540: SELECT /*+ ordered
1541: index(tmp2, PJI_RM_AGGR_RES2_N1)