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