View: IGWFV_GRANT_PROPOSAL_BDGT_LINE

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRANT_PROPOSAL_BDGT_LINE

View Text

SELECT PR.PROPOSAL_NUMBER
, BUD_DETAILS.VERSION_ID
, AWARDS.AWARD_NUMBER
, PROJECTS.NAME
, TASKS.TASK_NUMBER
, PERIODS.START_DATE
, PERIODS.END_DATE
, DECODE(BUD_DETAILS.EXPENDITURE_CATEGORY_FLAG
, 'Y'
, BUD_DETAILS.EXPENDITURE_TYPE)
, DECODE(BUD_DETAILS.EXPENDITURE_CATEGORY_FLAG
, 'N'
, BUD_DETAILS.EXPENDITURE_TYPE)
, BUD_DETAILS.LINE_ITEM_DESCRIPTION
, BUD_DETAILS.BASED_ON_LINE_ITEM
, BUD_DETAILS.LINE_ITEM_COST
, BUD_DETAILS.COST_SHARING_AMOUNT
, BUD_DETAILS.UNDERRECOVERY_AMOUNT
, BUD_DETAILS.APPLY_INFLATION_FLAG
, BUD_DETAILS.BUDGET_JUSTIFICATION
, LKUP2.MEANING
, LKUP1.MEANING
, PR.PROPOSAL_ID
, BUD_DETAILS.BUDGET_PERIOD_ID
, BUD_DETAILS.LINE_ITEM_ID
, BUD_DETAILS.PROJECT_ID
, BUD_DETAILS.TASK_ID
, BUD_DETAILS.AWARD_ID
, BUD_DETAILS.LAST_UPDATE_DATE
, BUD_DETAILS.LAST_UPDATED_BY
, BUD_DETAILS.CREATION_DATE
, BUD_DETAILS.CREATED_BY
FROM IGW_BUDGET_DETAILS BUD_DETAILS
, IGW_PROPOSALS_ALL PR
, IGW_LOOKUPS_V LKUP1
, IGW_LOOKUPS_V LKUP2
, IGW_BUDGET_PERIODS PERIODS
, GMS_AWARDS_ALL AWARDS
, PA_PROJECTS_ALL PROJECTS
, PA_TASKS TASKS
WHERE PR.PROPOSAL_ID = BUD_DETAILS.PROPOSAL_ID
AND LKUP1.LOOKUP_TYPE(+) = 'IGW_BUDGET_CATEGORY'
AND LKUP1.LOOKUP_CODE(+) = BUD_DETAILS.BUDGET_CATEGORY_CODE
AND LKUP2.LOOKUP_TYPE = 'IGW_LOCATION'
AND LKUP2.LOOKUP_CODE = BUD_DETAILS.LOCATION_CODE
AND PROJECTS.PROJECT_ID(+) = BUD_DETAILS.PROJECT_ID
AND TASKS.TASK_ID(+) = BUD_DETAILS.TASK_ID
AND AWARDS.AWARD_ID(+) = BUD_DETAILS.AWARD_ID WITH READ ONLY

Columns