View: PA_BGT_ACCT_LINES_V

Product:	PA - Projects
Description:	PA_BGT_ACCT_LINES_V stores the information of a project or task budget, including GL period, code combination identifier, budget amounts and funds check status.
Implementation/DBA Data:	APPS.PA_BGT_ACCT_LINES_V

View Text

SELECT BAL.ROWID
, BAL.BUDGET_ACCT_LINE_ID
, BAL.BUDGET_VERSION_ID
, BAL.CODE_COMBINATION_ID
, BAL.GL_PERIOD_NAME
, BAL.START_DATE
, BAL.PREV_VER_BUDGET_AMOUNT
, BAL.PREV_VER_AVAILABLE_AMOUNT
, BAL.CURR_VER_BUDGET_AMOUNT
, DECODE(BV.BUDGET_STATUS_CODE
, 'B'
, BAL.CURR_VER_AVAILABLE_AMOUNT
, (BAL.CURR_VER_BUDGET_AMOUNT - (BAL.PREV_VER_BUDGET_AMOUNT - BAL.PREV_VER_AVAILABLE_AMOUNT)) )
, BAL.ACCOUNTED_AMOUNT
, BAL.FUNDS_CHECK_STATUS_CODE
, BAL.FUNDS_CHECK_RESULT_CODE
FROM PA_BUDGET_ACCT_LINES BAL
, PA_BUDGET_VERSIONS BV
WHERE BV.BUDGET_VERSION_ID = BAL.BUDGET_VERSION_ID

Columns