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

Line 778: FROM dual

774: , 0 AS PY_FORECAST
775: , null AS P_CHANGE2
776: , null AS P_CHANGE21
777: , null AS P_CHANGE22
778: FROM dual
779: UNION ALL
780: SELECT
781: 1 AS PHASE_CODE
782: , 2 AS AMOUNT_TYPE_CODE

Line 794: FROM dual

790: , 0 AS PY_FORECAST
791: , null AS P_CHANGE2
792: , null AS P_CHANGE21
793: , null AS P_CHANGE22
794: FROM dual
795: UNION ALL
796: SELECT
797: 1 AS PHASE_CODE
798: , 3 AS AMOUNT_TYPE_CODE

Line 810: FROM dual

806: , 0 AS PY_FORECAST
807: , null AS P_CHANGE2
808: , null AS P_CHANGE21
809: , null AS P_CHANGE22
810: FROM dual
811: )
812: WHERE 1 = 1
813: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
814:

Line 1063: FROM dual

1059: , 0 AS PY_FORECAST
1060: , null AS P_CHANGE2
1061: , null AS P_CHANGE21
1062: , null AS P_CHANGE22
1063: FROM dual
1064: UNION ALL
1065: SELECT
1066: 1 AS PHASE_CODE
1067: ,2 AS AMOUNT_TYPE_CODE

Line 1079: FROM dual

1075: , 0 AS PY_FORECAST
1076: , null AS P_CHANGE2
1077: , null AS P_CHANGE21
1078: , null AS P_CHANGE22
1079: FROM dual
1080: UNION ALL
1081: SELECT
1082: 1 AS PHASE_CODE
1083: ,3 AS AMOUNT_TYPE_CODE

Line 1095: FROM dual

1091: , 0 AS PY_FORECAST
1092: , null AS P_CHANGE2
1093: , null AS P_CHANGE21
1094: , null AS P_CHANGE22
1095: FROM dual
1096: )
1097: WHERE 1 = 1
1098: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
1099:

Line 1345: FROM dual

1341: , 0 AS PY_FORECAST
1342: , null AS P_CHANGE2
1343: , null AS P_CHANGE21
1344: , null AS P_CHANGE22
1345: FROM dual
1346: UNION ALL
1347: SELECT
1348: 1 AS PHASE_CODE
1349: ,2 AS AMOUNT_TYPE_CODE

Line 1361: FROM dual

1357: , 0 AS PY_FORECAST
1358: , null AS P_CHANGE2
1359: , null AS P_CHANGE21
1360: , null AS P_CHANGE22
1361: FROM dual
1362: UNION ALL
1363: SELECT
1364: 1 AS PHASE_CODE
1365: ,3 AS AMOUNT_TYPE_CODE

Line 1377: FROM dual

1373: , 0 AS PY_FORECAST
1374: , null AS P_CHANGE2
1375: , null AS P_CHANGE21
1376: , null AS P_CHANGE22
1377: FROM dual
1378: )
1379: WHERE 1 = 1
1380: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
1381:

Line 1616: FROM dual

1612: , 0 AS PY_FORECAST
1613: , null AS P_CHANGE2
1614: , null AS P_CHANGE21
1615: , null AS P_CHANGE22
1616: FROM dual
1617: UNION ALL
1618: SELECT
1619: 1 AS PHASE_CODE
1620: ,2 AS AMOUNT_TYPE_CODE

Line 1632: FROM dual

1628: , 0 AS PY_FORECAST
1629: , null AS P_CHANGE2
1630: , null AS P_CHANGE21
1631: , null AS P_CHANGE22
1632: FROM dual
1633: UNION ALL
1634: SELECT
1635: 1 AS PHASE_CODE
1636: ,3 AS AMOUNT_TYPE_CODE

Line 1648: FROM dual

1644: , 0 AS PY_FORECAST
1645: , null AS P_CHANGE2
1646: , null AS P_CHANGE21
1647: , null AS P_CHANGE22
1648: FROM dual
1649: )
1650: WHERE 1 = 1
1651: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
1652:

Line 1911: FROM dual

1907: , 0 AS PY_FORECAST
1908: , null AS P_CHANGE2
1909: , null AS P_CHANGE21
1910: , null AS P_CHANGE22
1911: FROM dual
1912: UNION ALL
1913: SELECT
1914: 1 AS PHASE_CODE
1915: ,2 AS AMOUNT_TYPE_CODE

Line 1927: FROM dual

1923: , 0 AS PY_FORECAST
1924: , null AS P_CHANGE2
1925: , null AS P_CHANGE21
1926: , null AS P_CHANGE22
1927: FROM dual
1928: UNION ALL
1929: SELECT
1930: 1 AS PHASE_CODE
1931: ,3 AS AMOUNT_TYPE_CODE

Line 1943: FROM dual

1939: , 0 AS PY_FORECAST
1940: , null AS P_CHANGE2
1941: , null AS P_CHANGE21
1942: , null AS P_CHANGE22
1943: FROM dual
1944: )
1945: WHERE 1 = 1
1946: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
1947:

Line 2200: FROM dual

2196: , 0 AS PY_FORECAST
2197: , null AS P_CHANGE2
2198: , null AS P_CHANGE21
2199: , null AS P_CHANGE22
2200: FROM dual
2201: UNION ALL
2202: SELECT
2203: 1 AS PHASE_CODE
2204: ,2 AS AMOUNT_TYPE_CODE

Line 2216: FROM dual

2212: , 0 AS PY_FORECAST
2213: , null AS P_CHANGE2
2214: , null AS P_CHANGE21
2215: , null AS P_CHANGE22
2216: FROM dual
2217: UNION ALL
2218: SELECT
2219: 1 AS PHASE_CODE
2220: ,3 AS AMOUNT_TYPE_CODE

Line 2232: FROM dual

2228: , 0 AS PY_FORECAST
2229: , null AS P_CHANGE2
2230: , null AS P_CHANGE21
2231: , null AS P_CHANGE22
2232: FROM dual
2233: )
2234: WHERE 1 = 1
2235: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
2236:

Line 2482: FROM dual

2478: , 0 AS PY_FORECAST
2479: , null AS P_CHANGE2
2480: , null AS P_CHANGE21
2481: , null AS P_CHANGE22
2482: FROM dual
2483: UNION ALL
2484: SELECT
2485: 1 AS PHASE_CODE
2486: ,2 AS AMOUNT_TYPE_CODE

Line 2498: FROM dual

2494: , 0 AS PY_FORECAST
2495: , null AS P_CHANGE2
2496: , null AS P_CHANGE21
2497: , null AS P_CHANGE22
2498: FROM dual
2499: UNION ALL
2500: SELECT
2501: 1 AS PHASE_CODE
2502: ,3 AS AMOUNT_TYPE_CODE

Line 2514: FROM dual

2510: , 0 AS PY_FORECAST
2511: , null AS P_CHANGE2
2512: , null AS P_CHANGE21
2513: , null AS P_CHANGE22
2514: FROM dual
2515: )
2516: WHERE 1 = 1
2517: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
2518:

Line 2781: FROM dual

2777: , 0 AS PY_FORECAST
2778: , null AS P_CHANGE2
2779: , null AS P_CHANGE21
2780: , null AS P_CHANGE22
2781: FROM dual
2782: UNION ALL
2783: SELECT
2784: 1 AS PHASE_CODE
2785: ,2 AS AMOUNT_TYPE_CODE

Line 2797: FROM dual

2793: , 0 AS PY_FORECAST
2794: , null AS P_CHANGE2
2795: , null AS P_CHANGE21
2796: , null AS P_CHANGE22
2797: FROM dual
2798: UNION ALL
2799: SELECT
2800: 1 AS PHASE_CODE
2801: ,3 AS AMOUNT_TYPE_CODE

Line 2813: FROM dual

2809: , 0 AS PY_FORECAST
2810: , null AS P_CHANGE2
2811: , null AS P_CHANGE21
2812: , null AS P_CHANGE22
2813: FROM dual
2814: )
2815: WHERE 1 = 1
2816: GROUP BY PHASE_CODE,AMOUNT_TYPE_CODE,AMOUNT_TYPE_LABEL;
2817: