View: GL_DEFAS_ASSIGNMENTS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_DEFAS_ASSIGNMENTS_V

View Text

SELECT NA.ROWID ROW_ID
, NA.DEFINITION_ACCESS_SET_ID DEFINITION_ACCESS_SET_ID
, NA.OBJECT_TYPE OBJECT_TYPE
, O.DISPLAY_NAME OBJECT_DESCRIPTION
, NA.OBJECT_KEY OBJECT_KEY
, GL_DEFAS_ACCESS_DETAILS_PKG.GET_OBJECT_NAME(NA.OBJECT_TYPE
, NA.OBJECT_KEY) OBJECT_NAME
, NA.VIEW_ACCESS_FLAG VIEW_ACCESS_FLAG
, NA.USE_ACCESS_FLAG USE_ACCESS_FLAG
, NA.MODIFY_ACCESS_FLAG MODIFY_ACCESS_FLAG
, NA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NA.LAST_UPDATED_BY LAST_UPDATED_BY
, NA.CREATION_DATE CREATION_DATE
, NA.CREATED_BY CREATED_BY
, NA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NA.STATUS_CODE STATUS_CODE
, NA.CONTEXT CONTEXT
, NA.ATTRIBUTE1 ATTRIBUTE1
, NA.ATTRIBUTE2 ATTRIBUTE2
, NA.ATTRIBUTE3 ATTRIBUTE3
, NA.ATTRIBUTE4 ATTRIBUTE4
, NA.ATTRIBUTE5 ATTRIBUTE5
, NA.ATTRIBUTE6 ATTRIBUTE6
, NA.ATTRIBUTE7 ATTRIBUTE7
, NA.ATTRIBUTE8 ATTRIBUTE8
, NA.ATTRIBUTE9 ATTRIBUTE9
, NA.ATTRIBUTE10 ATTRIBUTE10
, NA.ATTRIBUTE11 ATTRIBUTE11
, NA.ATTRIBUTE12 ATTRIBUTE12
, NA.ATTRIBUTE13 ATTRIBUTE13
, NA.ATTRIBUTE14 ATTRIBUTE14
, NA.ATTRIBUTE15 ATTRIBUTE15
, NA.REQUEST_ID REQUEST_ID
, AC.USER_DEFINITION_ACCESS_SET NAME
FROM GL_DEFAS_ASSIGNMENTS NA
, FND_OBJECTS_VL O
, GL_DEFAS_ACCESS_SETS AC
WHERE O.OBJ_NAME = NA.OBJECT_TYPE
AND AC.DEFINITION_ACCESS_SET_ID = NA.DEFINITION_ACCESS_SET_ID

Columns