VIEW: APPS.ENG_CHANGE_ACTIONS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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