[Home] [Help]
VIEW: APPS.PA_BIS_ORG_PRJ_BY_PERIOD_V
Source
View Text - Preformatted
SELECT amount_type_code, drilldown_key1, 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='ORGANIZATION'
View Text - HTML Formatted
SELECT AMOUNT_TYPE_CODE
, DRILLDOWN_KEY1
, 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='ORGANIZATION'