[Home] [Help]
View: GL_TRANS_BUDGET_PERIODS_V
Product: | GL - General Ledger |
Description: | 10SC ONLY |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TR.PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
, TR.ACTUAL_FLAG ACTUAL_FLAG
, TR.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TR.TO_CURRENCY_CODE TO_CURRENCY_CODE
FROM GL_PERIOD_STATUSES PS
, GL_TRANSLATION_RATES TR
WHERE TR.PERIOD_NAME = PS.PERIOD_NAME
AND TR.SET_OF_BOOKS_ID = PS.SET_OF_BOOKS_ID
AND PS.APPLICATION_ID = 101
AND TR.ACTUAL_FLAG = 'B'
Columns
Name |
PERIOD_NAME |
PERIOD_YEAR |
PERIOD_NUM |
ACTUAL_FLAG |
SET_OF_BOOKS_ID |
TO_CURRENCY_CODE |