View: PA_BIS_PRJ_TO_DATE_DRILLS

View Text

SELECT DRILLDOWN_TYPE
, AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, DRILLDOWN_KEY3
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, SORT_ORDER
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
, ORG_ID
FROM PA_BIS_PRJ_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