DBA Data[Home] [Help]

VIEW: APPS.XLA_EXTRACT_OBJECTS_V

Source

View Text - Preformatted

SELECT b.rowid ,b.application_id ,b.entity_code ,b.event_class_code ,b.object_name ,b.object_type_code ,t.meaning ,b.always_populated_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login FROM xla_extract_objects b ,xla_lookups t WHERE b.object_type_code = t.lookup_code AND t.lookup_type = 'XLA_EXTRACT_OBJECT_TYPE'
View Text - HTML Formatted

SELECT B.ROWID
, B.APPLICATION_ID
, B.ENTITY_CODE
, B.EVENT_CLASS_CODE
, B.OBJECT_NAME
, B.OBJECT_TYPE_CODE
, T.MEANING
, B.ALWAYS_POPULATED_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM XLA_EXTRACT_OBJECTS B
, XLA_LOOKUPS T
WHERE B.OBJECT_TYPE_CODE = T.LOOKUP_CODE
AND T.LOOKUP_TYPE = 'XLA_EXTRACT_OBJECT_TYPE'