Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_PC_VENTITIES_V |
SELECT APPLICATION_ID
, APPLICATION_SHORT_NAME
, ENTITY_ID
, ENTITY_SHORT_NAME
, ENTITY_DISPLAY_NAME
, ENTITY_DESCRIPTION
, DB_OBJECT_NAME
, APPLICATION_ID
, APPLICATION_SHORT_NAME
, ENTITY_ID
, ENTITY_SHORT_NAME
, ENTITY_DISPLAY_NAME
, ENTITY_DESCRIPTION
, DB_OBJECT_NAME
FROM OE_PC_ENTITIES_V UNION SELECT APPLICATION_ID
, APPLICATION_SHORT_NAME
, ENTITY_ID
, ENTITY_SHORT_NAME
, ENTITY_DISPLAY_NAME
, ENTITY_DESCRIPTION
, DB_OBJECT_NAME
, RELATED_APPLICATION_ID
, RELATED_APPLICATION_SHORT_NAME
, RELATED_ENTITY_ID
, RELATED_ENTITY_SHORT_NAME
, RELATED_ENTITY_DISPLAY_NAME
, RELATED_ENTITY_DESCRIPTION
, RELATED_DB_OBJECT_NAME
FROM OE_PC_RENTITIES_V UNION SELECT RELATED_APPLICATION_ID
, RELATED_APPLICATION_SHORT_NAME
, RELATED_ENTITY_ID
, RELATED_ENTITY_SHORT_NAME
, RELATED_ENTITY_DISPLAY_NAME
, RELATED_ENTITY_DESCRIPTION
, RELATED_DB_OBJECT_NAME
, APPLICATION_ID
, APPLICATION_SHORT_NAME
, ENTITY_ID
, ENTITY_SHORT_NAME
, ENTITY_DISPLAY_NAME
, ENTITY_DESCRIPTION
, DB_OBJECT_NAME
FROM OE_PC_RENTITIES_V