ECC Projects, Projects Costing: Budget Balances

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Budgetary Control-Enabled Project Balances
Dataset Key: pa-ds-cost-bcbalances
Query Procedure: PA_ECC_COST_BUDGET_CNTRL_PKG.LOAD_FULL_BCBALANCES_DATA
Security Procedure: PA_ECC_DATASECURITY_PKG.GetFilterAttributeValues
Run ECC Projects, Projects Costing: Budget Balances and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT
trx.RECORD_TYPE,
trx.ECC_SPEC_ID,
trx.PROJECT_ID,
trx.PROJECT_NAME,
trx.PROJECT_NUMBER,
trx.ORG_ID,
trx.OPERATING_UNIT,
trx.PROJECT_ORGANIZATION,
trx.PROJECT_MANAGER,
trx.PROJECT_START_DATE,
trx.PROJECT_COMPLETION_DATE,
trx.PROJECT_TYPE,
trx.PROJECT_TYPE_CLASS_CODE,
trx.PROJECT_STATUS_CODE,
trx.PROJECT_STATUS_NAME,
trx.PROJECT_SYSTEM_STATUS_CODE,
trx.PROJFUNC_CURRENCY_CODE,
trx.TEMPLATE_FLAG,
trx.AMOUNT_TYPE || '-' || trx.BOUNDARY_CODE PERIODICITY,
trx.BALANCE_TYPE,
trx.EXTERNAL_BUDGET_CODE,
trx.GL_BUDGET_VERSION_ID,
trx.ENCUMBRANCE_TYPE_ID,
trx.BDGT_CNTRL_FLAG,
trx.AMOUNT_TYPE,
trx.BOUNDARY_CODE,
trx.FUND_CONTROL_LEVEL_PROJECT,
trx.FUND_CONTROL_LEVEL_TASK,
trx.FUND_CONTROL_LEVEL_RES_GRP,
trx.FUND_CONTROL_LEVEL_RES,
trx.PROJECT_CONTROL_LEVEL,
trx.TASK_CONTROL_LEVEL,
trx.RES_GROUP_CONTROL_LEVEL,
trx.RESOURCE_CONTROL_LEVEL,
trx.BUDGET_VERSION_ID,
trx.BUDGET_TYPE_CODE,
trx.BUDGET_TYPE,
trx.VERSION_NUMBER,
trx.VERSION_NAME,
trx.VERSION_DESCRIPTION,
trx.BUDGET_STATUS_CODE,
trx.BUDGET_STATUS,
trx.CURRENT_FLAG,
trx.ORIGINAL_FLAG,
trx.CURRENT_ORIGINAL_FLAG,
trx.BUDGET_ENTRY_METHOD_CODE,
trx.LABOR_QUANTITY,
trx.LABOR_UNIT_OF_MEASURE,
trx.RAW_COST,
trx.BURDENED_COST,
trx.REVENUE,
trx.FIRST_BUDGET_PERIOD,
trx.WF_STATUS_CODE,
trx.TOTAL_PROJECT_RAW_COST,
trx.TOTAL_PROJECT_BURDENED_COST,
trx.TOTAL_PROJECT_REVENUE,
trx.TASK_ID,
trx.TASK_NUMBER,
trx.TASK_NAME,
trx.TASK_ORGANIZATION,
trx.TASK_MANAGER,
trx.TASK_START_DATE,
trx.TASK_COMPLETION_DATE,
trx.TASK_STATUS,
trx.TOP_TASK_ID,
trx.TOP_TASK_NUMBER,
trx.TOP_TASK_NAME,
trx.RESOURCE_LIST_MEMBER_ID,
trx.PARENT_MEMBER_ID,
trx.START_DATE,
trx.END_DATE,
trx.PA_PERIOD_NAME,
trx.GL_PERIOD_NAME,
trx.ENCUMBRANCE_TYPE_CODE,
trx.ENCUMBRANCE_TYPE,
trx.BUDGET,
trx.ACTUALS,
trx.ENCUMBRANCES,
trx.BGT_CONSUMPTION,
trx.PROJECT_BUDGET,
trx.PROJECT_COMMITMENTS,
trx.PROJECT_ACTUALS,
trx.PROJ_CMTS_ALL + trx.PROJ_ACTLS_ALL PROJECT_CONSUMPTION,
trx.PROJ_UNCONSUMED_FUNDS,
trx.PROJ_PERCENT_SPENT_BUDGET,
trx.TASK_BUDGET,
trx.TASK_COMMITMENTS,
trx.TASK_ACTUALS,
trx.TASK_CMTS_ALL + trx.TASK_ACTLS_ALL TASK_CONSUMPTION,
trx.TASK_UNCONSUMED_FUNDS,
trx.TASK_PERCENT_SPENT_BUDGET,
trx.PROJECT_REQ_CMT,
trx.PROJECT_PO_CMT,
trx.PROJECT_AP_CMT,
trx.PROJECT_UNUTLFUND_CT,
trx.TASK_REQ_CMT,
trx.TASK_PO_CMT,
trx.TASK_AP_CMT,
trx.TASK_UNUTLFUND_CT,
trx.PROJ_BALANCE_BGT,
trx.TASK_BALANCE_BGT,
trx.PROJ_FAILED_FC,
trx.TASK_FAILED_FC,
TRX.TASK_GROUPING_VAL,
TRX.PROJECT_GROUPING_VAL,
TRX.FC_START_DATE,
TRX.FC_END_DATE,
TRX.PROJ_BDGT_ALL,
TRX.PROJ_CMTS_ALL,
TRX.PROJ_ACTLS_ALL,
TRX.PROJ_RMNG_ALL,
TRX.PROJ_FC_FAIL_ALL,
TRX.TASK_BDGT_ALL,
TRX.TASK_CMTS_ALL,
TRX.TASK_ACTLS_ALL,
TRX.TASK_RMNG_ALL,
TRX.TASK_FC_FAIL_ALL,
TRX.PROJ_UNCONSUMED_FUNDS_FLAG,
TRX.TASK_UNCONSUMED_FUNDS_FLAG,
trx.project_id || trx.task_id || trx.GL_PERIOD_NAME ASSC_ID,
trx.PROJ_UNCONSUMED_FUNDS PROJ_UNCONSUMED_FUNDS_COM,
trx.PROJECT_REQ_CMT PROJECT_REQ_CMT_COM,
trx.PROJECT_PO_CMT PROJECT_PO_CMT_COM,
TRX.PROJ_ACTLS_ALL PROJ_ACTLS_ALL_COM,
trx.TASK_UNCONSUMED_FUNDS TASK_UNCONSUMED_FUNDS_COM,
trx.TASK_REQ_CMT TASK_REQ_CMT_COM,
trx.TASK_PO_CMT TASK_PO_CMT_COM,
trx.TASK_ACTLS_ALL TASK_ACTLS_ALL_COM,
trx.ACTUALS ACTUALS_COM,
trx.PROJECT_ACTUALS PROJECT_ACTUALS_COM,
trx.TASK_ACTUALS TASK_ACTUALS_COM,
trx.ENABLE_REVISE_BUDGET ENABLE_REVISE_BUDGET,
trx.LANGUAGE 
FROM PA_ECC_COST_BC_BALANCES trx, pa_tasks pt 
where  trx.task_id = pt.task_id (+)
and trx.language in ('US')
 
)
PIVOT (
max(OPERATING_UNIT) as OPERATING_UNIT,
max(PROJECT_ORGANIZATION) as PROJECT_ORGANIZATION,
max(PROJECT_TYPE_CLASS_CODE) as PROJECT_TYPE_CLASS_CODE,
max(PROJECT_STATUS_CODE) as PROJECT_STATUS_CODE,
max(PROJECT_SYSTEM_STATUS_CODE) as PROJECT_SYSTEM_STATUS_CODE,
max(AMOUNT_TYPE) as AMOUNT_TYPE,
max(BOUNDARY_CODE) as BOUNDARY_CODE,
max(PROJECT_CONTROL_LEVEL) as PROJECT_CONTROL_LEVEL,
max(TASK_CONTROL_LEVEL) as TASK_CONTROL_LEVEL,
max(RES_GROUP_CONTROL_LEVEL) as RES_GROUP_CONTROL_LEVEL,
max(RESOURCE_CONTROL_LEVEL) as RESOURCE_CONTROL_LEVEL,
max(BUDGET_STATUS) as BUDGET_STATUS,
max(TASK_ORGANIZATION) as TASK_ORGANIZATION,
max(ENCUMBRANCE_TYPE) as ENCUMBRANCE_TYPE,
max(PERIODICITY) as PERIODICITY
for LANGUAGE in ('US' "US"))
) x
where
2=2
Blitz Report™