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.BOMPCOAN dependencies on ENG_ENGINEERING_CHANGES

Line 90: FROM ENG_ENGINEERING_CHANGES

86:
87: SELECT GREATEST(P_NEXT_NUMBER,
88: NVL(GREATEST(TO_NUMBER(LTRIM(CHANGE_NOTICE,P_PREFIX_TEMP))),0)+1)
89: INTO P_GREATEST_NUM
90: FROM ENG_ENGINEERING_CHANGES
91: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
92: AND RTRIM(CHANGE_NOTICE,'0123456789') = P_PREFIX_TEMP;
93:
94: P_NEXT_NUMBER := GREATEST(P_GREATEST_NUM, P_NEXT_NUMBER);

Line 202: FROM ENG_ENGINEERING_CHANGES

198:
199: SELECT GREATEST(P_NEXT_NUMBER,
200: NVL(MAX(TO_NUMBER(LTRIM(CHANGE_NOTICE,P_PREFIX_TEMP))),0)+1)
201: INTO P_GREATEST_NUM
202: FROM ENG_ENGINEERING_CHANGES
203: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
204: AND RTRIM(CHANGE_NOTICE,'0123456789') = P_PREFIX_TEMP;
205:
206: P_NEXT_NUMBER := GREATEST(P_GREATEST_NUM, P_NEXT_NUMBER);