VIEW: APPS.SO_ENTITIES_PARAMETERS_V

Source

View Text - Preformatted

SELECT E.ROWID ROW_ID , E.ENTITY_ID , E.ENTITY_CODE , E.LAST_UPDATE_DATE , E.LAST_UPDATED_BY , E.LAST_UPDATE_LOGIN , E.CREATION_DATE , E.CREATED_BY , E.NAME , E.TABLE_NAME , E.COLUMN_NAME , E.COLUMN_TYPE_CODE , L.MEANING COLUMN_TYPE_MEANING , E.ENABLED_FLAG , E.DESCRIPTION , E.CONTEXT , E.ATTRIBUTE1 , E.ATTRIBUTE2 , E.ATTRIBUTE3 , E.ATTRIBUTE4 , E.ATTRIBUTE5 , E.ATTRIBUTE6 , E.ATTRIBUTE7 , E.ATTRIBUTE8 , E.ATTRIBUTE9 , E.ATTRIBUTE10 , E.ATTRIBUTE11 , E.ATTRIBUTE12 , E.ATTRIBUTE13 , E.ATTRIBUTE14 , E.ATTRIBUTE15 FROM SO_ENTITIES E, SO_LOOKUPS L WHERE E.COLUMN_TYPE_CODE = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'COLUMN_TYPE_CODE'

View Text - HTML Formatted

SELECT E.ROWID ROW_ID
, E.ENTITY_ID
, E.ENTITY_CODE
, E.LAST_UPDATE_DATE
, E.LAST_UPDATED_BY
, E.LAST_UPDATE_LOGIN
, E.CREATION_DATE
, E.CREATED_BY
, E.NAME
, E.TABLE_NAME
, E.COLUMN_NAME
, E.COLUMN_TYPE_CODE
, L.MEANING COLUMN_TYPE_MEANING
, E.ENABLED_FLAG
, E.DESCRIPTION
, E.CONTEXT
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, E.ATTRIBUTE11
, E.ATTRIBUTE12
, E.ATTRIBUTE13
, E.ATTRIBUTE14
, E.ATTRIBUTE15
FROM SO_ENTITIES E
, SO_LOOKUPS L
WHERE E.COLUMN_TYPE_CODE = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'COLUMN_TYPE_CODE'