VIEW: APPS.PA_BGT_ACCT_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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