[Home] [Help]
View: OKL_ACC_GROUP_CCID_V
Product: | OKL - Lease and Finance Management |
Description: | Account groups |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AGCB.ROWID ROW_ID
, AGCB.ID ID
, AGCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, AGCB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, AGCB.ACC_GROUP_CODE ACC_GROUP_CODE
, AGCB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AGCB.ORG_ID ORG_ID
, AGCB.CREATED_BY CREATED_BY
, AGCB.CREATION_DATE CREATION_DATE
, AGCB.LAST_UPDATED_BY LAST_UPDATED_BY
, AGCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AGCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_ACC_GROUP_CCID AGCB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
Columns
Name |
ROW_ID |
ID |
OBJECT_VERSION_NUMBER |
CODE_COMBINATION_ID |
ACC_GROUP_CODE |
ORG_ID |
SET_OF_BOOKS_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |