[Home] [Help]
View: PA_BIS_TOTALS_BY_PRD
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AMOUNT_TYPE_CODE
, PERIOD_NAME
, ACCUMULATION_PERIOD_TYPE
, START_DATE
, END_DATE
, SORT_ORDER
, ACTUAL
, BUDGET
, ORG_ID
FROM PA_BIS_TOTALS_BY_PRD_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
Columns
Name |
AMOUNT_TYPE_CODE |
PERIOD_NAME |
ACCUMULATION_PERIOD_TYPE |
START_DATE |
END_DATE |
SORT_ORDER |
ACTUAL |
BUDGET |
ORG_ID |