VIEW: APPS.IGWBV_GRANT_PROPOSAL_BDGT_LINE

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, BUD_DETAILS.VERSION_ID, 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, BUD_DETAILS.EXPENDITURE_CATEGORY_FLAG, 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 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 with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, BUD_DETAILS.VERSION_ID
, 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
, BUD_DETAILS.EXPENDITURE_CATEGORY_FLAG
, 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
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 WITH READ ONLY