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_SUBJECT_ENTITIES_V

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

View Text

SELECT ESE.SUBJECT_ID
, ESE.SUBJECT_LEVEL
, ESE.ENTITY_NAME
, ESE.PARENT_ENTITY_NAME
, ECOV.QUERY_OBJECT_NAME
, ECOV.PK1_COLUMN_NAME
, ECOV.PK2_COLUMN_NAME
, ECOV.PK3_COLUMN_NAME
, ECOV.PK4_COLUMN_NAME
, ECOV.PK5_COLUMN_NAME
, ECOV.QUERY_COLUMN1_NAME
, ECOV.QUERY_COLUMN2_NAME
, ECOV.QUERY_COLUMN3_NAME
, ECOV.QUERY_COLUMN4_NAME
, ECOV.QUERY_COLUMN5_NAME
, ECOV.QUERY_COLUMN1_TYPE
, ECOV.QUERY_COLUMN2_TYPE
, ECOV.QUERY_COLUMN3_TYPE
, ECOV.QUERY_COLUMN4_TYPE
, ECOV.QUERY_COLUMN5_TYPE
, ECOV.QUERY_COLUMN1_DISPLAY_NAME
, ECOV.QUERY_COLUMN2_DISPLAY_NAME
, ESE.FK1_COLUMN_NAME
, ESE.FK2_COLUMN_NAME
, ESE.FK3_COLUMN_NAME
, ESE.FK4_COLUMN_NAME
, ESE.FK5_COLUMN_NAME
, ESE.CREATED_BY
, ESE.CREATION_DATE
, ESE.LAST_UPDATE_DATE
, ESE.LAST_UPDATED_BY
, ESE.LAST_UPDATE_LOGIN
, ECOV.ENTITY_URL
, ESE.BEAN_TYPE
FROM ENG_CHANGE_OBJECTS_V ECOV
, ENG_SUBJECT_ENTITIES ESE
WHERE ESE.ENTITY_NAME = ECOV.ENTITY_NAME

Columns

Name
SUBJECT_ID
SUBJECT_LEVEL
ENTITY_NAME
PARENT_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
QUERY_COLUMN1_DISPLAY_NAME
QUERY_COLUMN2_DISPLAY_NAME
FK1_COLUMN_NAME
FK2_COLUMN_NAME
FK3_COLUMN_NAME
FK4_COLUMN_NAME
FK5_COLUMN_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ENTITY_URL
BEAN_TYPE