VIEW: APPS.ENG_CHANGE_LINES_VL

Source

View Text - Preformatted

SELECT ecl.ROWID ROW_ID ,ecl.CHANGE_LINE_ID ,ecl.CHANGE_ID ,ecl.CREATED_BY ,ecl.CREATION_DATE ,ecl.LAST_UPDATED_BY ,ecl.LAST_UPDATE_DATE ,ecl.LAST_UPDATE_LOGIN ,ecl.REQUEST_ID ,ecl.PROGRAM_ID ,ecl.PROGRAM_APPLICATION_ID ,ecl.PROGRAM_UPDATE_DATE ,ecl.SEQUENCE_NUMBER ,ecl.CHANGE_TYPE_ID ,ecl.STATUS_CODE ,ecl.ASSIGNEE_ID ,ecl.NEED_BY_DATE ,ecl.SCHEDULED_DATE ,ecl.IMPLEMENTATION_DATE ,ecl.CANCELATION_DATE ,ecl.ORIGINAL_SYSTEM_REFERENCE ,ecltl.NAME ,ecltl.DESCRIPTION ,ecl.APPROVAL_STATUS_TYPE ,ecl.APPROVAL_DATE ,ecl.APPROVAL_REQUEST_DATE ,ecl.ROUTE_ID ,ecl.REQUIRED_FLAG ,ecl.COMPLETE_BEFORE_STATUS_CODE ,ecl.START_AFTER_STATUS_CODE FROM eng_change_lines ecl, eng_change_lines_tL ecltl WHERE ecl.CHANGE_LINE_ID = ecltl.CHANGE_LINE_ID and ecltl.language = userenv('LANG')

View Text - HTML Formatted

SELECT ECL.ROWID ROW_ID
, ECL.CHANGE_LINE_ID
, ECL.CHANGE_ID
, ECL.CREATED_BY
, ECL.CREATION_DATE
, ECL.LAST_UPDATED_BY
, ECL.LAST_UPDATE_DATE
, ECL.LAST_UPDATE_LOGIN
, ECL.REQUEST_ID
, ECL.PROGRAM_ID
, ECL.PROGRAM_APPLICATION_ID
, ECL.PROGRAM_UPDATE_DATE
, ECL.SEQUENCE_NUMBER
, ECL.CHANGE_TYPE_ID
, ECL.STATUS_CODE
, ECL.ASSIGNEE_ID
, ECL.NEED_BY_DATE
, ECL.SCHEDULED_DATE
, ECL.IMPLEMENTATION_DATE
, ECL.CANCELATION_DATE
, ECL.ORIGINAL_SYSTEM_REFERENCE
, ECLTL.NAME
, ECLTL.DESCRIPTION
, ECL.APPROVAL_STATUS_TYPE
, ECL.APPROVAL_DATE
, ECL.APPROVAL_REQUEST_DATE
, ECL.ROUTE_ID
, ECL.REQUIRED_FLAG
, ECL.COMPLETE_BEFORE_STATUS_CODE
, ECL.START_AFTER_STATUS_CODE
FROM ENG_CHANGE_LINES ECL
, ENG_CHANGE_LINES_TL ECLTL
WHERE ECL.CHANGE_LINE_ID = ECLTL.CHANGE_LINE_ID
AND ECLTL.LANGUAGE = USERENV('LANG')