VIEW: APPS.IGWFV_GRANT_PROPOSAL_BDGT_LINE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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