View: PA_PRJ_ACCT_FC_RESULTS_V

Product:	PA - Projects
Description:	Base View for Budget Funds Check Results - Project Level - Integrated to an External Budget
Implementation/DBA Data:	APPS.PA_PRJ_ACCT_FC_RESULTS_V

View Text

SELECT PBL.BUDGET_VERSION_ID
, PBL.GL_PERIOD_NAME
, PBL.START_DATE
, PBL.END_DATE
, PBL.CODE_COMBINATION_ID
, SUM(PBL.CURR_VER_BUDGET_AMOUNT)
, SUM(PBL.CURR_VER_AVAILABLE_AMOUNT)
, PBL.FUNDS_CHECK_RESULT_CODE
, PBL.FUNDS_CHECK_STATUS_CODE
FROM PA_BUDGET_ACCT_LINES PBL GROUP BY PBL.BUDGET_VERSION_ID
, PBL.GL_PERIOD_NAME
, PBL.START_DATE
, PBL.END_DATE
, PBL.CODE_COMBINATION_ID
, PBL.FUNDS_CHECK_RESULT_CODE
, PBL.FUNDS_CHECK_STATUS_CODE

Columns