[Home] [Help]
View: OKL_REPORTS_V
Product: | OKL - Lease and Finance Management |
Description: | |
Implementation/DBA Data: |
APPS.OKL_REPORTS_V
|
View Text
SELECT B.REPORT_ID
, TL.NAME
, B.CHART_OF_ACCOUNTS_ID
, B.BOOK_CLASSIFICATION_CODE
, B.LEDGER_ID
, B.REPORT_CATEGORY_CODE
, B.REPORT_TYPE_CODE
, B.ACTIVITY_CODE
, B.STATUS_CODE
, TL.DESCRIPTION
, B.EFFECTIVE_FROM_DATE
, B.EFFECTIVE_TO_DATE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, TL.LANGUAGE
, TL.SOURCE_LANG
, TL.SFWT_FLAG
FROM OKL_REPORTS_B B
, OKL_REPORTS_TL TL
WHERE B.REPORT_ID = TL.REPORT_ID
AND TL.LANGUAGE = USERENV('LANG')
Columns
Name |
REPORT_ID |
NAME |
CHART_OF_ACCOUNTS_ID |
BOOK_CLASSIFICATION_CODE |
LEDGER_ID |
REPORT_CATEGORY_CODE |
REPORT_TYPE_CODE |
ACTIVITY_CODE |
STATUS_CODE |
DESCRIPTION |
EFFECTIVE_FROM_DATE |
EFFECTIVE_TO_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
LANGUAGE |
SOURCE_LANG |
SFWT_FLAG |