1. Tables and Views for Financials
  2. XCC_BALANCES_V

XCC_BALANCES_V

Details

  • Schema: FUSION

  • Object owner: XCC

  • Object type: VIEW

Columns

Name

CONTROL_BUDGET_ID

BUDGET_CCID

PERIOD_NAME

BUDGET_AMOUNT

BUDGET_ADJUSTMENT_AMOUNT

COMMITMENT_AMOUNT

OBLIGATION_AMOUNT

OTHER_AMOUNT

ACTUAL_AMOUNT

FUNDS_AVAILABLE_AMOUNT

APPROVED_COMMITMENT_AMOUNT

APPROVED_AUTHORIZATION_AMOUNT

APPROVED_OBLIGATION_AMOUNT

VALIDATED_PAYABLES_AMOUNT

APPROVED_PROJECT_AMOUNT

DETAIL_OTHER_AMOUNT

ACCOUNTED_PAYABLES_AMOUNT

ACCOUNTED_RECEIPTS_AMOUNT

ACCOUNTED_PROJECT_AMOUNT

MISC_EXPENDITURES_AMOUNT

UNRELEASED_BUDGET_AMOUNT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

control_budget_id,

budget_ccid,

period_name,

SUM(budget_amount) budget_amount,

SUM(budget_adjustment_amount) budget_adjustment_amount,

SUM(commitment_amount) commitment_amount,

SUM(obligation_amount) obligation_amount,

SUM(other_amount) other_amount,

SUM(actual_amount) actual_amount,

SUM(funds_available_amount) funds_available_amount,

SUM(approved_commitment_amount) approved_commitment_amount,

SUM(approved_authorization_amount) approved_authorization_amount,

SUM(approved_obligation_amount) approved_obligation_amount,

SUM(validated_payables_amount) validated_payables_amount,

SUM(approved_project_amount) approved_project_amount,

SUM(detail_other_amount) detail_other_amount,

SUM(accounted_payables_amount) accounted_payables_amount,

SUM(accounted_receipts_amount) accounted_receipts_amount,

SUM(accounted_project_amount) accounted_project_amount,

SUM(misc_expenditures_amount) misc_expenditures_amount,

SUM(unreleased_budget_amount) unreleased_budget_amount,

MIN(created_by) created_by,

MIN(creation_date) creation_date,

MIN(last_updated_by) last_updated_by,

MAX(last_update_date) last_update_date,

MIN(last_update_login) last_update_login

FROM

(

SELECT /*+ INDEX(xcc_tr_balances XCC_TR_BALANCES_N1) */

control_budget_id,

period_name,

budget_ccid,

budget_amount,

budget_adjustment_amount,

commitment_amount,

obligation_amount,

other_amount,

actual_amount,

funds_available_amount,

approved_commitment_amount,

approved_obligation_amount,

validated_payables_amount,

approved_project_amount,

detail_other_amount,

accounted_payables_amount,

accounted_receipts_amount,

accounted_project_amount,

misc_expenditures_amount,

unreleased_budget_amount,

approved_authorization_amount,

created_by,

creation_date,

last_updated_by,

last_update_date,

last_update_login

FROM

xcc_tr_balances

WHERE

balances_posted_flag = 'N'

UNION ALL

SELECT

control_budget_id,

period_name,

budget_ccid,

budget_amount,

budget_adjustment_amount,

commitment_amount,

obligation_amount,

other_amount,

actual_amount,

funds_available_amount,

approved_commitment_amount,

approved_obligation_amount,

validated_payables_amount,

approved_project_amount,

detail_other_amount,

accounted_payables_amount,

accounted_receipts_amount,

accounted_project_amount,

misc_expenditures_amount,

unreleased_budget_amount,

approved_authorization_amount,

created_by,

creation_date,

last_updated_by,

last_update_date,

last_update_login

FROM

xcc_balances

)

GROUP BY

control_budget_id,

period_name,

budget_ccid