[Home] [Help]
VIEW: APPS.PA_BIS_CLASS_TO_DATE_V
Source
View Text - Preformatted
SELECT amount_type_code, drilldown_key1, drilldown_key2, sort_order, org_id, actual_ptd, budget_ptd, actual_ytd, budget_ytd FROM PA_BIS_TO_DATE_DRILLS WHERE drilldown_type='CLASS_CATEGORY'
View Text - HTML Formatted
SELECT AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, DRILLDOWN_KEY2
, SORT_ORDER
, ORG_ID
, ACTUAL_PTD
, BUDGET_PTD
, ACTUAL_YTD
, BUDGET_YTD
FROM PA_BIS_TO_DATE_DRILLS
WHERE DRILLDOWN_TYPE='CLASS_CATEGORY'