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