SELECT amount_type_code, drilldown_key1, drilldown_key2, project_id, period_name, accumulation_period_type, start_date, end_date, sort_order, org_id, actual, budget FROM PA_BIS_PRJ_BY_PRD_DRILLS WHERE drilldown_type='CLASS_CATEGORY'
SELECT AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, PROJECT_ID
, PERIOD_NAME
, ACCUMULATION_PERIOD_TYPE
, START_DATE
, END_DATE
, SORT_ORDER
, ORG_ID
, ACTUAL
, BUDGET
FROM PA_BIS_PRJ_BY_PRD_DRILLS
WHERE DRILLDOWN_TYPE='CLASS_CATEGORY'
|
|
|