[Home] [Help]
View: GL_ACCESS_SET_LEDGERS_V
View Text
SELECT GL_ASL.ROWID ROW_ID
, GL_ASL.ACCESS_SET_ID ACCESS_SET_ID
, GL_ASL.LEDGER_ID LEDGER_ID
, LDG.NAME LEDGER_NAME
, LDG.CURRENCY_CODE CURRENCY_CODE
, LDG.OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, GL_ASL.ACCESS_PRIVILEGE_CODE ACCESS_PRIVILEGE_CODE
, GL_ASL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GL_ASL.LAST_UPDATED_BY LAST_UPDATED_BY
, GL_ASL.CREATION_DATE CREATION_DATE
, GL_ASL.CREATED_BY CREATED_BY
, GL_ASL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GL_ASL.START_DATE START_DATE
, GL_ASL.END_DATE END_DATE
FROM GL_ACCESS_SET_LEDGERS GL_ASL
, GL_LEDGERS LDG
WHERE GL_ASL.LEDGER_ID = LDG.LEDGER_ID
Columns
Name |
ROW_ID |
ACCESS_SET_ID |
LEDGER_ID |
LEDGER_NAME |
CURRENCY_CODE |
OBJECT_TYPE_CODE |
ACCESS_PRIVILEGE_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
START_DATE |
END_DATE |