ECC Projects, Projects Billing: Budget

Description
Categories: Enterprise Command Center
Columns: Record Type, Ecc Spec Id, Project Id, Project Name, Project Number, Org Id, Project Organization, Projfunc Currency Code, Project Start Date, Project Completion Date ...
Imported from Enterprise Command Center
Description: Projects Billing Revenue Budget Details
Dataset Key: pa-ds-bill-budget
Query Procedure: PA_ECC_BILL_LOAD_PKG.LOAD_FULL_BUDGET_DATA
Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues
select
x.*
from
(
select * from (
SELECT
RECORD_TYPE,
ECC_SPEC_ID,
PROJECT_ID,
PROJECT_NAME,
PROJECT_NUMBER,
ORG_ID,
OPERATING_UNIT,
PROJECT_ORGANIZATION,
PROJFUNC_CURRENCY_CODE,
PROJECT_START_DATE,
PROJECT_COMPLETION_DATE,
FUNDING_TASK_ID,
FUNDING_TASK_NUMBER,
FUNDING_TASK_NAME,
BUDGET_VERSION_ID,
BUDGET_TYPE_CODE,
BUDGET_TYPE,
VERSION_NUMBER,
VERSION_NAME,
VERSION_DESCRIPTION,
BUDGET_ENTRY_METHOD_CODE,
BUDGET_ENTRY_METHOD,
VERSION_RAW_COST,
VERSION_BURDENED_COST,
VERSION_REVENUE,
BUDGET_LINE_ID,
RESOURCE_ASSIGNMENT_ID,
TASK_ID,
TASK_NUMBER,
TASK_NAME,
TASK_START_DATE,
TASK_COMPLETION_DATE,
BUDGET_LINE_START_DATE,
BUDGET_LINE_END_DATE,
GL_PERIOD_NAME,
CHART_PERIOD_NAME,
REVENUE_BUDGET,
REVENUE_BUDGET REVENUE_BUDGET_ITD,
ITD_FLAG,
CHART_DISPLAY_FLAG,
EXP_REV_GL_PERIOD,
EXP_REV_GL_PERIOD_FMT,
PROJ_PERIOD_REVENUE,
PROJ_PERIOD_EXPENDITURE,
(nvl(PROJ_PERIOD_REVENUE, 0) - nvl(PROJ_PERIOD_EXPENDITURE, 0)) CASH_FLOW,
PROJECT_ID||':'||FUNDING_TASK_ID DS_ASSOC_PRJ_TSK_ATTR,
PROJECT_ID||':'||FUNDING_TASK_ID||':'||GL_PERIOD_NAME DS_ASSOC_PRJ_TSK_PER_ATTR,
LANGUAGE
FROM PA_ECC_BILL_BUDGET where language in ('US'))PIVOT (
max(OPERATING_UNIT) as OPERATING_UNIT
for LANGUAGE in ('US' "US"))
) x
where
2=2