DBA Data[Home] [Help]

VIEW: APPS.IGWBV_GRANT_PRPSL_BDGT_LIN_AMT

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, CAL_AMTS.VERSION_ID, CAL_AMTS.APPLY_RATE_FLAG, CAL_AMTS.CALCULATED_COST, CAL_AMTS.CALCULATED_COST_SHARING, PR.PROPOSAL_ID, CAL_AMTS.BUDGET_PERIOD_ID, CAL_AMTS.LINE_ITEM_ID, CAL_AMTS.RATE_CLASS_ID, CAL_AMTS.RATE_TYPE_ID, CAL_AMTS.LAST_UPDATE_DATE, CAL_AMTS.LAST_UPDATED_BY, CAL_AMTS.CREATION_DATE, CAL_AMTS.CREATED_BY from IGW_BUDGET_DETAILS_CAL_AMTS CAL_AMTS, IGW_PROPOSALS_ALL PR WHERE PR.proposal_id = CAL_AMTS.proposal_id with read only
View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, CAL_AMTS.VERSION_ID
, CAL_AMTS.APPLY_RATE_FLAG
, CAL_AMTS.CALCULATED_COST
, CAL_AMTS.CALCULATED_COST_SHARING
, PR.PROPOSAL_ID
, CAL_AMTS.BUDGET_PERIOD_ID
, CAL_AMTS.LINE_ITEM_ID
, CAL_AMTS.RATE_CLASS_ID
, CAL_AMTS.RATE_TYPE_ID
, CAL_AMTS.LAST_UPDATE_DATE
, CAL_AMTS.LAST_UPDATED_BY
, CAL_AMTS.CREATION_DATE
, CAL_AMTS.CREATED_BY
FROM IGW_BUDGET_DETAILS_CAL_AMTS CAL_AMTS
, IGW_PROPOSALS_ALL PR
WHERE PR.PROPOSAL_ID = CAL_AMTS.PROPOSAL_ID WITH READ ONLY