VIEW: APPS.IGWBV_GRANT_PRPSL_BDGT_VERSION

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, BUDGETS.VERSION_ID, BUDGETS.START_DATE, BUDGETS.END_DATE, BUDGETS.TOTAL_COST, BUDGETS.TOTAL_DIRECT_COST, BUDGETS.TOTAL_INDIRECT_COST, BUDGETS.COST_SHARING_AMOUNT, BUDGETS.UNDERRECOVERY_AMOUNT, BUDGETS.RESIDUAL_FUNDS, BUDGETS.TOTAL_COST_LIMIT, BUDGETS.COMMENTS, BUDGETS.FINAL_VERSION_FLAG, '_LA:budgets.budget_type_code:IGW_LOOKUPS_V:IGW_BUDGET_TYPES:MEANING', BUDGETS.PROPOSAL_FORM_NUMBER , '_DF:IGW:IGW_BUDGETS_DESC_FLEX:BUDGETS' , PR.PROPOSAL_ID, BUDGETS.OH_RATE_CLASS_ID, BUDGETS.LAST_UPDATE_DATE, BUDGETS.LAST_UPDATED_BY, BUDGETS.CREATION_DATE, BUDGETS.CREATED_BY from IGW_BUDGETS BUDGETS, IGW_PROPOSALS_ALL PR WHERE PR.proposal_id = BUDGETS.proposal_id with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, BUDGETS.VERSION_ID
, BUDGETS.START_DATE
, BUDGETS.END_DATE
, BUDGETS.TOTAL_COST
, BUDGETS.TOTAL_DIRECT_COST
, BUDGETS.TOTAL_INDIRECT_COST
, BUDGETS.COST_SHARING_AMOUNT
, BUDGETS.UNDERRECOVERY_AMOUNT
, BUDGETS.RESIDUAL_FUNDS
, BUDGETS.TOTAL_COST_LIMIT
, BUDGETS.COMMENTS
, BUDGETS.FINAL_VERSION_FLAG
, '_LA:BUDGETS.BUDGET_TYPE_CODE:IGW_LOOKUPS_V:IGW_BUDGET_TYPES:MEANING'
, BUDGETS.PROPOSAL_FORM_NUMBER
, '_DF:IGW:IGW_BUDGETS_DESC_FLEX:BUDGETS'
, PR.PROPOSAL_ID
, BUDGETS.OH_RATE_CLASS_ID
, BUDGETS.LAST_UPDATE_DATE
, BUDGETS.LAST_UPDATED_BY
, BUDGETS.CREATION_DATE
, BUDGETS.CREATED_BY
FROM IGW_BUDGETS BUDGETS
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = BUDGETS.PROPOSAL_ID WITH READ ONLY