Product: | ENG - Engineering |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ENG_CHANGE_ROUTE_STEPS_VL |
SELECT ECRS.ROWID ROW_ID
, ECRS.STEP_ID
, ECRS.ROUTE_ID
, ECRSTL.INSTRUCTION
, ECRS.STEP_SEQ_NUM
, ECRS.ADHOC_STEP_FLAG
, ECRS.WF_ITEM_TYPE
, ECRS.WF_ITEM_KEY
, ECRS.WF_PROCESS_NAME
, ECRS.CONDITION_TYPE_CODE
, ECRS.TIMEOUT_OPTION
, ECRS.STEP_STATUS_CODE
, ECRS.STEP_START_DATE
, ECRS.STEP_END_DATE
, ECRS.REQUIRED_RELATIVE_DAYS
, ECRS.REQUIRED_DATE
, ECRS.CREATION_DATE
, ECRS.CREATED_BY
, ECRS.LAST_UPDATE_DATE
, ECRS.LAST_UPDATED_BY
, ECRS.LAST_UPDATE_LOGIN
, ECRS.ATTRIBUTE_CATEGORY
, ECRS.ATTRIBUTE1
, ECRS.ATTRIBUTE2
, ECRS.ATTRIBUTE3
, ECRS.ATTRIBUTE4
, ECRS.ATTRIBUTE5
, ECRS.ATTRIBUTE6
, ECRS.ATTRIBUTE7
, ECRS.ATTRIBUTE8
, ECRS.ATTRIBUTE9
, ECRS.ATTRIBUTE10
, ECRS.ATTRIBUTE11
, ECRS.ATTRIBUTE12
, ECRS.ATTRIBUTE13
, ECRS.ATTRIBUTE14
, ECRS.ATTRIBUTE15
, ECRS.REQUEST_ID
, ECRS.PROGRAM_ID
, ECRS.PROGRAM_APPLICATION_ID
, ECRS.PROGRAM_UPDATE_DATE
, ECRS.ORIGINAL_SYSTEM_REFERENCE
, ECRS.ASSIGNMENT_CODE
FROM ENG_CHANGE_ROUTE_STEPS ECRS
, ENG_CHANGE_ROUTE_STEPS_TL ECRSTL
WHERE ECRS.STEP_ID = ECRSTL.STEP_ID
AND ECRSTL.LANGUAGE = USERENV('LANG')