Product: | ENG - Engineering |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ENG_CHANGE_ACTIONS_VL |
SELECT ECA.ROWID ROW_ID
, ECA.ACTION_ID
, ECA.ACTION_TYPE
, ECA.OBJECT_NAME
, ECA.OBJECT_ID1
, ECA.OBJECT_ID2
, ECA.OBJECT_ID3
, ECA.OBJECT_ID4
, ECA.OBJECT_ID5
, ECA.PARENT_ACTION_ID
, ECA.STATUS_CODE
, ECA.PRIORITY_CODE
, ECA.ASSIGNEE_ID
, ECA.RESPONSE_BY_DATE
, ECA.PARTY_ID_LIST
, ECA.PARENT_STATUS_CODE
, ECA.WORKFLOW_ITEM_TYPE
, ECA.WORKFLOW_ITEM_KEY
, ECA.ROUTE_ID
, ECA.REQUEST_ID
, ECA.PROGRAM_ID
, ECA.PROGRAM_APPLICATION_ID
, ECA.PROGRAM_UPDATE_DATE
, ECA.ORIGINAL_SYSTEM_REFERENCE
, ECA.CREATION_DATE
, ECA.CREATED_BY
, ECA.LAST_UPDATE_DATE
, ECA.LAST_UPDATED_BY
, ECA.LAST_UPDATE_LOGIN
, ECAT.DESCRIPTION
, ECA.IMPLEMENTATION_REQ_ID
, ECA.LOCAL_ORGANIZATION_ID
FROM ENG_CHANGE_ACTIONS ECA
, ENG_CHANGE_ACTIONS_TL ECAT
WHERE ECA.ACTION_ID = ECAT.ACTION_ID
AND ECAT.LANGUAGE = USERENV('LANG')