FND_OBJECTS_VL

Details

• Schema: DATASECURITY

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID OBJECT_ID OBJ_NAME MODULE_ID DATABASE_OBJECT_NAME PK1_COLUMN_NAME PK2_COLUMN_NAME PK3_COLUMN_NAME PK4_COLUMN_NAME PK5_COLUMN_NAME PK1_COLUMN_TYPE PK2_COLUMN_TYPE PK3_COLUMN_TYPE PK4_COLUMN_TYPE PK5_COLUMN_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DISPLAY_NAME DESCRIPTION OBJECT_TYPE OBJECT_TAG OBJECT_STRIPE_CONDITION FILTER_COLUMN_LIST FUNCTION_SECURITY_ENABLED CHANGE_SINCE_LAST_REFRESH

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.OBJECT_ID, B.OBJ_NAME, B.MODULE_ID, B.DATABASE_OBJECT_NAME, B.PK1_COLUMN_NAME, B.PK2_COLUMN_NAME, B.PK3_COLUMN_NAME, B.PK4_COLUMN_NAME, B.PK5_COLUMN_NAME, B.PK1_COLUMN_TYPE, B.PK2_COLUMN_TYPE, B.PK3_COLUMN_TYPE, B.PK4_COLUMN_TYPE, B.PK5_COLUMN_TYPE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, T.DISPLAY_NAME, T.DESCRIPTION, B.OBJECT_TYPE, B.OBJECT_TAG, B.OBJECT_STRIPE_CONDITION, B.FILTER_COLUMN_LIST, B.FUNCTION_SECURITY_ENABLED, B.CHANGE_SINCE_LAST_REFRESH FROM FND_OBJECTS_TL T, FND_OBJECTS B WHERE B.OBJECT_ID = T.OBJECT_ID AND T.LANGUAGE = USERENV('LANG')