VIEW: APPS.ENG_SUBJECT_ENTITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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