[Home] [Help]
View: PA_BIS_TOTALS_TO_DATE
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AMOUNT_TYPE_CODE
, SORT_ORDER
, DRILLDOWN_INDICATOR
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
, ORG_ID
FROM PA_BIS_TOTALS_TO_DATE_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 |
SORT_ORDER |
DRILLDOWN_INDICATOR |
ACTUAL_PTD |
BUDGET_PTD |
ACTUAL_YTD |
BUDGET_YTD |
ORG_ID |