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_OBJECTS_VL

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

View Text

SELECT ECO.ROWID ROW_ID
, ECO.ENTITY_NAME
, ECO.QUERY_OBJECT_NAME
, ECO.PK1_COLUMN_NAME
, ECO.PK2_COLUMN_NAME
, ECO.PK3_COLUMN_NAME
, ECO.PK4_COLUMN_NAME
, ECO.PK5_COLUMN_NAME
, ECO.QUERY_COLUMN1_NAME
, ECO.QUERY_COLUMN2_NAME
, ECO.QUERY_COLUMN3_NAME
, ECO.QUERY_COLUMN4_NAME
, ECO.QUERY_COLUMN5_NAME
, ECO.QUERY_COLUMN1_TYPE
, ECO.QUERY_COLUMN2_TYPE
, ECO.QUERY_COLUMN3_TYPE
, ECO.QUERY_COLUMN4_TYPE
, ECO.QUERY_COLUMN5_TYPE
, ECO.CREATED_BY
, ECO.CREATION_DATE
, ECO.LAST_UPDATE_DATE
, ECO.LAST_UPDATED_BY
, ECO.LAST_UPDATE_LOGIN
, ECOTL.QUERY_COLUMN1_DISPLAY_NAME
, ECOTL.QUERY_COLUMN2_DISPLAY_NAME
, ECOTL.ENTITY_DISPLAY_NAME
, ECO.ENTITY_URL
FROM ENG_CHANGE_OBJECTS ECO
, ENG_CHANGE_OBJECTS_TL ECOTL
WHERE ECO.ENTITY_NAME = ECOTL.ENTITY_NAME
AND ECOTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ENTITY_NAME
QUERY_OBJECT_NAME
PK1_COLUMN_NAME
PK2_COLUMN_NAME
PK3_COLUMN_NAME
PK4_COLUMN_NAME
PK5_COLUMN_NAME
QUERY_COLUMN1_NAME
QUERY_COLUMN2_NAME
QUERY_COLUMN3_NAME
QUERY_COLUMN4_NAME
QUERY_COLUMN5_NAME
QUERY_COLUMN1_TYPE
QUERY_COLUMN2_TYPE
QUERY_COLUMN3_TYPE
QUERY_COLUMN4_TYPE
QUERY_COLUMN5_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
QUERY_COLUMN1_DISPLAY_NAME
QUERY_COLUMN2_DISPLAY_NAME
ENTITY_DISPLAY_NAME
ENTITY_URL