VIEW: APPS.OE_DEF_AK_OBJ_EXT_V

Source

View Text - Preformatted

SELECT y.rowid row_id, x.ATTRIBUTE_CATEGORY, x.ATTRIBUTE1, x.ATTRIBUTE2, x.ATTRIBUTE3, x.ATTRIBUTE4, x.ATTRIBUTE5, x.ATTRIBUTE6, x.ATTRIBUTE7, x.ATTRIBUTE8, x.ATTRIBUTE9, x.ATTRIBUTE10, x.ATTRIBUTE11, x.ATTRIBUTE12, x.ATTRIBUTE13, x.ATTRIBUTE14, x.ATTRIBUTE15, x.APPLICATION_ID, x.PRIMARY_KEY_NAME, x.DEFAULTING_API_PKG, x.DEFAULTING_API_PROC, x.VALIDATION_API_PKG, x.VALIDATION_API_PROC, x.application_name, x.application_short_name, x.name, y.created_by, y.creation_date, y.last_updated_by, y.last_update_date, y.last_update_login, y.database_object_name, y.entity_code, y.entity_id from ak_objects_vl x,oe_ak_objects_ext y WHERE x.database_object_name=y.database_object_name and y.defaulting_enabled_flag = 'Y'

View Text - HTML Formatted

SELECT Y.ROWID ROW_ID
, X.ATTRIBUTE_CATEGORY
, X.ATTRIBUTE1
, X.ATTRIBUTE2
, X.ATTRIBUTE3
, X.ATTRIBUTE4
, X.ATTRIBUTE5
, X.ATTRIBUTE6
, X.ATTRIBUTE7
, X.ATTRIBUTE8
, X.ATTRIBUTE9
, X.ATTRIBUTE10
, X.ATTRIBUTE11
, X.ATTRIBUTE12
, X.ATTRIBUTE13
, X.ATTRIBUTE14
, X.ATTRIBUTE15
, X.APPLICATION_ID
, X.PRIMARY_KEY_NAME
, X.DEFAULTING_API_PKG
, X.DEFAULTING_API_PROC
, X.VALIDATION_API_PKG
, X.VALIDATION_API_PROC
, X.APPLICATION_NAME
, X.APPLICATION_SHORT_NAME
, X.NAME
, Y.CREATED_BY
, Y.CREATION_DATE
, Y.LAST_UPDATED_BY
, Y.LAST_UPDATE_DATE
, Y.LAST_UPDATE_LOGIN
, Y.DATABASE_OBJECT_NAME
, Y.ENTITY_CODE
, Y.ENTITY_ID
FROM AK_OBJECTS_VL X
, OE_AK_OBJECTS_EXT Y
WHERE X.DATABASE_OBJECT_NAME=Y.DATABASE_OBJECT_NAME
AND Y.DEFAULTING_ENABLED_FLAG = 'Y'