VIEW: APPS.IGW_BUDGETS_V

Source

View Text - Preformatted

SELECT pb.rowid ,pb.proposal_id ,pb.version_id ,pb.start_date ,pb.end_date ,pb.total_cost ,pb.total_direct_cost ,pb.total_indirect_cost ,pb.cost_sharing_amount ,pb.underrecovery_amount ,pb.residual_funds ,pb.total_cost_limit ,pb.oh_rate_class_id ,pb.proposal_form_number ,prc.description ,pb.comments ,pb.final_version_flag ,pb.budget_type_code ,il.meaning ,pb.record_version_number ,pb.enter_budget_at_period_level ,pb.apply_inflation_setup_rates ,pb.apply_eb_setup_rates ,pb.apply_oh_setup_rates ,pb.last_update_date ,pb.last_updated_by ,pb.creation_date ,pb.created_by ,pb.last_update_login ,pb.attribute_category ,pb.attribute1 ,pb.attribute2 ,pb.attribute3 ,pb.attribute4 ,pb.attribute5 ,pb.attribute6 ,pb.attribute7 ,pb.attribute8 ,pb.attribute9 ,pb.attribute10 ,pb.attribute11 ,pb.attribute12 ,pb.attribute13 ,pb.attribute14 ,pb.attribute15 ,prc.description ,igw_security.allow_create('BUDGET', proposal_id, fnd_global.user_id) ,igw_security.allow_modify('BUDGET', proposal_id, fnd_global.user_id) from igw_budgets pb , igw_rate_classes prc , igw_lookups_v il WHERE pb.oh_rate_class_id = prc.rate_class_id and pb.budget_type_code = il.lookup_code and il.lookup_type = 'IGW_BUDGET_TYPES'

View Text - HTML Formatted

SELECT PB.ROWID
, PB.PROPOSAL_ID
, PB.VERSION_ID
, PB.START_DATE
, PB.END_DATE
, PB.TOTAL_COST
, PB.TOTAL_DIRECT_COST
, PB.TOTAL_INDIRECT_COST
, PB.COST_SHARING_AMOUNT
, PB.UNDERRECOVERY_AMOUNT
, PB.RESIDUAL_FUNDS
, PB.TOTAL_COST_LIMIT
, PB.OH_RATE_CLASS_ID
, PB.PROPOSAL_FORM_NUMBER
, PRC.DESCRIPTION
, PB.COMMENTS
, PB.FINAL_VERSION_FLAG
, PB.BUDGET_TYPE_CODE
, IL.MEANING
, PB.RECORD_VERSION_NUMBER
, PB.ENTER_BUDGET_AT_PERIOD_LEVEL
, PB.APPLY_INFLATION_SETUP_RATES
, PB.APPLY_EB_SETUP_RATES
, PB.APPLY_OH_SETUP_RATES
, PB.LAST_UPDATE_DATE
, PB.LAST_UPDATED_BY
, PB.CREATION_DATE
, PB.CREATED_BY
, PB.LAST_UPDATE_LOGIN
, PB.ATTRIBUTE_CATEGORY
, PB.ATTRIBUTE1
, PB.ATTRIBUTE2
, PB.ATTRIBUTE3
, PB.ATTRIBUTE4
, PB.ATTRIBUTE5
, PB.ATTRIBUTE6
, PB.ATTRIBUTE7
, PB.ATTRIBUTE8
, PB.ATTRIBUTE9
, PB.ATTRIBUTE10
, PB.ATTRIBUTE11
, PB.ATTRIBUTE12
, PB.ATTRIBUTE13
, PB.ATTRIBUTE14
, PB.ATTRIBUTE15
, PRC.DESCRIPTION
, IGW_SECURITY.ALLOW_CREATE('BUDGET'
, PROPOSAL_ID
, FND_GLOBAL.USER_ID)
, IGW_SECURITY.ALLOW_MODIFY('BUDGET'
, PROPOSAL_ID
, FND_GLOBAL.USER_ID)
FROM IGW_BUDGETS PB
, IGW_RATE_CLASSES PRC
, IGW_LOOKUPS_V IL
WHERE PB.OH_RATE_CLASS_ID = PRC.RATE_CLASS_ID
AND PB.BUDGET_TYPE_CODE = IL.LOOKUP_CODE
AND IL.LOOKUP_TYPE = 'IGW_BUDGET_TYPES'