APPS.EGO_CHANGE_USER_ATTRS_PUB dependencies on ENG_CHANGE_LINES

Line 190: FROM eng_change_lines

186: WHERE change_id = l_change_id;
187:
188: CURSOR c_CheckLine(l_change_line_id NUMBER) IS
189: SELECT status_code
190: FROM eng_change_lines
191: WHERE change_line_id = l_change_line_id;
192: BEGIN
193:
194: -----------------------------------------------

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 423: FROM ENG_CHANGE_LINES_VL EEC

419:
420: UPDATE ENG_CHG_USR_ATR_INTERFACE UAI
421: SET UAI.CHANGE_TYPE_ID =
422: (SELECT EEC.CHANGE_TYPE_ID
423: FROM ENG_CHANGE_LINES_VL EEC
424: WHERE
425: EEC.CHANGE_LINE_ID = UAI.CHANGE_LINE_ID
426: )
427: WHERE UAI.DATA_SET_ID = p_data_set_id

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

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