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.

[Home] [Help]

View: ENG_CHANGE_LINES_VL

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_CHANGE_LINES_VL

View Text

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')

Columns

Name
ROW_ID
CHANGE_LINE_ID
CHANGE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE
SEQUENCE_NUMBER
CHANGE_TYPE_ID
STATUS_CODE
ASSIGNEE_ID
NEED_BY_DATE
SCHEDULED_DATE
IMPLEMENTATION_DATE
CANCELATION_DATE
ORIGINAL_SYSTEM_REFERENCE
NAME
DESCRIPTION
APPROVAL_STATUS_TYPE
APPROVAL_DATE
APPROVAL_REQUEST_DATE
ROUTE_ID
REQUIRED_FLAG
COMPLETE_BEFORE_STATUS_CODE
START_AFTER_STATUS_CODE