[Home] [Help]
View: IGWBV_GRANT_PRPSL_BDGT_LIN_AMT
Product: | IGW - Grants Proposal (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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
Columns
Name |
PROPOSAL_NUMBER |
BUDGET_VERSION_ID |
APPLY_RATE_FLAG |
CALCULATED_COST |
CALCULATED_COST_SHARING |
PROPOSAL_ID |
BUDGET_PERIOD_ID |
LINE_ITEM_ID |
RATE_CLASS_ID |
RATE_TYPE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |