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

Line 185: FROM eng_engineering_changes

181:
182: CURSOR c_CheckChange(l_change_id NUMBER) IS
183: SELECT status_type,
184: approval_status_type
185: FROM eng_engineering_changes
186: WHERE change_id = l_change_id;
187:
188: CURSOR c_CheckLine(l_change_line_id NUMBER) IS
189: SELECT status_code

Line 317: FROM ENG_ENGINEERING_CHANGES EEC

313:
314: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
315: SET UAI.CHANGE_ID =
316: (SELECT EEC.CHANGE_ID
317: FROM ENG_ENGINEERING_CHANGES EEC
318: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
319: AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
320: AND EEC.CHANGE_MGMT_TYPE_CODE = UAI.CHANGE_MGMT_TYPE_CODE
321: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)

Line 325: FROM ENG_ENGINEERING_CHANGES EEC

321: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
322: WHERE UAI.DATA_SET_ID = p_data_set_id
323: AND PROCESS_STATUS = G_PS_IN_PROCESS
324: AND EXISTS(SELECT EEC.CHANGE_ID
325: FROM ENG_ENGINEERING_CHANGES EEC
326: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
327: AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
328: AND EEC.CHANGE_MGMT_TYPE_CODE = UAI.CHANGE_MGMT_TYPE_CODE
329: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);

Line 335: FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC

331:
332: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI SET
333: UAI.CHANGE_LINE_ID=
334: (SELECT ELV.CHANGE_LINE_ID
335: FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC
336: WHERE
337: EEC.CHANGE_ID = ELV.CHANGE_ID
338: AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
339: AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 344: FROM ENG_CHANGE_LINES ELV, ENG_ENGINEERING_CHANGES EEC

340: AND ELV.SEQUENCE_NUMBER = UAI.CHANGE_LINE_SEQUENCE_NUMBER
341: ),
342: UAI.CHANGE_ID=
343: (SELECT ELV.CHANGE_ID
344: FROM ENG_CHANGE_LINES ELV, ENG_ENGINEERING_CHANGES EEC
345: WHERE
346: EEC.CHANGE_ID = ELV.CHANGE_ID
347: AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
348: AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 356: FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC

352: UAI.DATA_SET_ID = p_data_set_id
353: AND PROCESS_STATUS = G_PS_IN_PROCESS
354: AND EXISTS
355: (SELECT ELV.CHANGE_LINE_ID
356: FROM ENG_CHANGE_LINES ELV,ENG_ENGINEERING_CHANGES EEC
357: WHERE
358: EEC.CHANGE_ID = ELV.CHANGE_ID
359: AND EEC.CHANGE_NOTICE = UAI.CHANGE_NUMBER
360: AND EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID

Line 407: FROM ENG_ENGINEERING_CHANGES EEC

403:
404: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
405: SET UAI.CHANGE_TYPE_ID =
406: (SELECT EEC.CHANGE_ORDER_TYPE_ID
407: FROM ENG_ENGINEERING_CHANGES EEC
408: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
409: AND EEC.CHANGE_ID = UAI.CHANGE_ID
410: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
411: WHERE UAI.DATA_SET_ID = p_data_set_id

Line 414: FROM ENG_ENGINEERING_CHANGES EEC

410: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL)
411: WHERE UAI.DATA_SET_ID = p_data_set_id
412: AND PROCESS_STATUS = G_PS_IN_PROCESS
413: AND EXISTS(SELECT EEC.CHANGE_ORDER_TYPE_ID
414: FROM ENG_ENGINEERING_CHANGES EEC
415: WHERE EEC.ORGANIZATION_ID = UAI.ORGANIZATION_ID
416: AND EEC.CHANGE_ID = UAI.CHANGE_ID
417: AND UAI.CHANGE_LINE_SEQUENCE_NUMBER IS NULL);
418:

Line 1316: from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP

1312: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1313:
1314: cursor chg_csr is
1315: select EEC.CHANGE_ID,EEC.CHANGE_ORDER_TYPE_ID
1316: from ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1317: where EEC.CHANGE_MGMT_TYPE_CODE = p_change_mgmt_type_code
1318: AND EEC.CHANGE_NOTICE = p_change_number
1319: AND MP.ORGANIZATION_CODE = p_Organization_Code
1320: AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID;

Line 1461: from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP

1457: l_attr_row_table EGO_USER_ATTR_ROW_TABLE;
1458:
1459: cursor chgline_csr is
1460: select EEV.CHANGE_LINE_ID,EEV.CHANGE_TYPE_ID
1461: from ENG_CHANGE_LINES EEV,ENG_ENGINEERING_CHANGES EEC,MTL_PARAMETERS MP
1462: where EEC.CHANGE_ID = EEV.CHANGE_ID
1463: AND EEC.CHANGE_NOTICE = p_change_number
1464: AND MP.ORGANIZATION_CODE = p_Organization_Code
1465: AND EEC.ORGANIZATION_ID = MP.ORGANIZATION_ID