Product: | OE - Order Entry |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
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'