[Home] [Help]
View: PA_BIS_CLASS_PRJ_TO_DATE_V
View Text
SELECT AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, SORT_ORDER
, ORG_ID
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
FROM PA_BIS_PRJ_TO_DATE_DRILLS
WHERE DRILLDOWN_TYPE='CLASS_CATEGORY'
Columns
Name |
AMOUNT_TYPE_CODE |
CLASS_CATEGORY |
CLASS_CODE |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
SORT_ORDER |
ORG_ID |
ACTUAL_PTD |
BUDGET_PTD |
ACTUAL_YTD |
BUDGET_YTD |