VIEW: APPS.IGWFV_GRNT_PRPSL_BDGT_PERS_AMT

Source

View Text - Preformatted

SELECT PR.PROPOSAL_NUMBER, PER_DETAILS.VERSION_ID, PAPF.FULL_NAME, CLASS.DESCRIPTION, TYPE.DESCRIPTION, CAL_AMTS.APPLY_RATE_FLAG, CAL_AMTS.CALCULATED_COST, CAL_AMTS.CALCULATED_COST_SHARING, PR.PROPOSAL_ID, PER_DETAILS.BUDGET_PERIOD_ID, PER_DETAILS.LINE_ITEM_ID, PER_DETAILS.PERSON_ID, CAL_AMTS.BUDGET_PERSONNEL_DETAIL_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_PERSONNEL_CAL_AMTS CAL_AMTS , IGW_BUDGET_PERSONNEL_DETAILS PER_DETAILS, IGW_PROPOSALS_ALL PR, PER_ALL_PEOPLE_F PAPF, IGW_RATE_CLASSES CLASS, IGW_RATE_TYPES TYPE WHERE CAL_AMTS.budget_personnel_detail_id = PER_DETAILS.budget_personnel_detail_id and PER_DETAILS.proposal_id = PR.proposal_id and PAPF.person_id = PER_DETAILS.person_id and CLASS.rate_class_id = CAL_AMTS.rate_class_id and TYPE.rate_type_id = CAL_AMTS.rate_type_id with read only

View Text - HTML Formatted

SELECT PR.PROPOSAL_NUMBER
, PER_DETAILS.VERSION_ID
, PAPF.FULL_NAME
, CLASS.DESCRIPTION
, TYPE.DESCRIPTION
, CAL_AMTS.APPLY_RATE_FLAG
, CAL_AMTS.CALCULATED_COST
, CAL_AMTS.CALCULATED_COST_SHARING
, PR.PROPOSAL_ID
, PER_DETAILS.BUDGET_PERIOD_ID
, PER_DETAILS.LINE_ITEM_ID
, PER_DETAILS.PERSON_ID
, CAL_AMTS.BUDGET_PERSONNEL_DETAIL_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_PERSONNEL_CAL_AMTS CAL_AMTS
, IGW_BUDGET_PERSONNEL_DETAILS PER_DETAILS
, IGW_PROPOSALS_ALL PR
, PER_ALL_PEOPLE_F PAPF
, IGW_RATE_CLASSES CLASS
, IGW_RATE_TYPES TYPE
WHERE CAL_AMTS.BUDGET_PERSONNEL_DETAIL_ID = PER_DETAILS.BUDGET_PERSONNEL_DETAIL_ID
AND PER_DETAILS.PROPOSAL_ID = PR.PROPOSAL_ID
AND PAPF.PERSON_ID = PER_DETAILS.PERSON_ID
AND CLASS.RATE_CLASS_ID = CAL_AMTS.RATE_CLASS_ID
AND TYPE.RATE_TYPE_ID = CAL_AMTS.RATE_TYPE_ID WITH READ ONLY