VIEW: APPS.OE_PC_ENTITIES_V

Source

View Text - Preformatted

SELECT e.rowid row_id ,e.entity_id ,e.application_id ,ak.application_name ,ak.application_short_name ,ak.name ,ak.description ,e.entity_code ,e.database_object_name ,e.database_object_type ,e.created_by ,e.creation_date ,e.last_updated_by ,e.last_update_date ,e.wf_item_type ,e.itemkey_column1 ,e.itemkey_column2 ,e.itemkey_column3 ,e.itemkey_column4 ,e.itemkey_delimiter ,e.last_update_login FROM OE_AK_OBJECTS_EXT e, AK_OBJECTS_VL ak WHERE e.application_id = ak.application_id AND e.database_object_name = ak.database_object_name AND e.constraints_enabled_flag = 'Y'

View Text - HTML Formatted

SELECT E.ROWID ROW_ID
, E.ENTITY_ID
, E.APPLICATION_ID
, AK.APPLICATION_NAME
, AK.APPLICATION_SHORT_NAME
, AK.NAME
, AK.DESCRIPTION
, E.ENTITY_CODE
, E.DATABASE_OBJECT_NAME
, E.DATABASE_OBJECT_TYPE
, E.CREATED_BY
, E.CREATION_DATE
, E.LAST_UPDATED_BY
, E.LAST_UPDATE_DATE
, E.WF_ITEM_TYPE
, E.ITEMKEY_COLUMN1
, E.ITEMKEY_COLUMN2
, E.ITEMKEY_COLUMN3
, E.ITEMKEY_COLUMN4
, E.ITEMKEY_DELIMITER
, E.LAST_UPDATE_LOGIN
FROM OE_AK_OBJECTS_EXT E
, AK_OBJECTS_VL AK
WHERE E.APPLICATION_ID = AK.APPLICATION_ID
AND E.DATABASE_OBJECT_NAME = AK.DATABASE_OBJECT_NAME
AND E.CONSTRAINTS_ENABLED_FLAG = 'Y'