ECC Projects, Projects Billing: Budget

Description
Categories: Enterprise Command Center
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
Run ECC Projects, Projects Billing: Budget and other Oracle EBS reports with Blitz Report™ on our demo environment
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