[Home] [Help]
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
Name |
BUDGET_VERSION_ID |
GL_PERIOD_NAME |
START_DATE |
END_DATE |
CODE_COMBINATION_ID |
BUDGET |
FUNDS_AVAILABLE |
FUNDS_CHECK_RESULT_CODE |
STATUS_CODE |