Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_PC_RENTITIES_V |
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