VIEW: APPS.OE_PC_RENTITIES_V

Source

View Text - Preformatted

SELECT e.application_id ,e.application_short_name ,e.entity_id ,e.entity_short_name ,e.entity_display_name ,e.entity_description ,e.db_object_name ,re.application_id ,re.application_short_name ,re.entity_id ,re.entity_short_name ,re.entity_display_name ,re.entity_description ,re.db_object_name FROM oe_pc_entities_v e, oe_pc_entities_v re, oe_pc_fkeys_v efk WHERE e.application_id = efk.application_id AND e.db_object_name = efk.db_object_name AND e.db_object_type = efk.db_object_type AND efk.uk_application_id = re.application_id and efk.uk_db_object_name = re.db_object_name

View Text - HTML Formatted

SELECT E.APPLICATION_ID
, E.APPLICATION_SHORT_NAME
, E.ENTITY_ID
, E.ENTITY_SHORT_NAME
, E.ENTITY_DISPLAY_NAME
, E.ENTITY_DESCRIPTION
, E.DB_OBJECT_NAME
, RE.APPLICATION_ID
, RE.APPLICATION_SHORT_NAME
, RE.ENTITY_ID
, RE.ENTITY_SHORT_NAME
, RE.ENTITY_DISPLAY_NAME
, RE.ENTITY_DESCRIPTION
, RE.DB_OBJECT_NAME
FROM OE_PC_ENTITIES_V E
, OE_PC_ENTITIES_V RE
, OE_PC_FKEYS_V EFK
WHERE E.APPLICATION_ID = EFK.APPLICATION_ID
AND E.DB_OBJECT_NAME = EFK.DB_OBJECT_NAME
AND E.DB_OBJECT_TYPE = EFK.DB_OBJECT_TYPE
AND EFK.UK_APPLICATION_ID = RE.APPLICATION_ID
AND EFK.UK_DB_OBJECT_NAME = RE.DB_OBJECT_NAME