Product: | ENG - Engineering |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ENG_CHANGE_ROUTES_VL |
SELECT ECR.ROWID ROW_ID
, ECR.ROUTE_ID
, ECRTL.ROUTE_NAME
, ECRTL.ROUTE_DESCRIPTION
, ECR.TEMPLATE_FLAG
, ECR.OWNER_ID
, ECR.FIXED_FLAG
, ECR.OBJECT_NAME
, ECR.OBJECT_ID1
, ECR.OBJECT_ID2
, ECR.OBJECT_ID3
, ECR.OBJECT_ID4
, ECR.OBJECT_ID5
, ECR.APPLIED_TEMPLATE_ID
, ECR.WF_ITEM_TYPE
, ECR.WF_ITEM_KEY
, ECR.WF_PROCESS_NAME
, ECR.STATUS_CODE
, ECR.ROUTE_START_DATE
, ECR.ROUTE_END_DATE
, ECR.CHANGE_REVISION
, ECR.CREATION_DATE
, ECR.CREATED_BY
, ECR.LAST_UPDATE_DATE
, ECR.LAST_UPDATED_BY
, ECR.LAST_UPDATE_LOGIN
, ECR.ATTRIBUTE_CATEGORY
, ECR.ATTRIBUTE1
, ECR.ATTRIBUTE2
, ECR.ATTRIBUTE3
, ECR.ATTRIBUTE4
, ECR.ATTRIBUTE5
, ECR.ATTRIBUTE6
, ECR.ATTRIBUTE7
, ECR.ATTRIBUTE8
, ECR.ATTRIBUTE9
, ECR.ATTRIBUTE10
, ECR.ATTRIBUTE11
, ECR.ATTRIBUTE12
, ECR.ATTRIBUTE13
, ECR.ATTRIBUTE14
, ECR.ATTRIBUTE15
, ECR.REQUEST_ID
, ECR.PROGRAM_ID
, ECR.PROGRAM_APPLICATION_ID
, ECR.PROGRAM_UPDATE_DATE
, ECR.ORIGINAL_SYSTEM_REFERENCE
, ECR.CLASSIFICATION_CODE
, ECR.ROUTE_TYPE_CODE
FROM ENG_CHANGE_ROUTES ECR
, ENG_CHANGE_ROUTES_TL ECRTL
WHERE ECR.ROUTE_ID = ECRTL.ROUTE_ID
AND ECRTL.LANGUAGE = USERENV('LANG')