Product: | IGF - Financial Aid |
---|---|
Description: | Shows the detail sequence of funds that have to be applied for a given formula |
Implementation/DBA Data: | APPS.IGF_AW_AWD_FRML_DET_V |
SELECT FMDET.ROW_ID
, FMDET.FORMULA_CODE
, FMDET.CI_CAL_TYPE
, FMDET.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, FMDET.SEQ_NO
, FMDET.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FMDET.MIN_AWARD_AMT
, FMDET.MAX_AWARD_AMT
, FMDET.REPLACE_FC
, FMDET.CREATED_BY
, FMDET.CREATION_DATE
, FMDET.LAST_UPDATED_BY
, FMDET.LAST_UPDATE_DATE
, FMDET.LAST_UPDATE_LOGIN
, FMDET.PE_GROUP_ID
, FMDET.ADPLANS_ID
, ADPLANS.AWD_DIST_PLAN_CD
, ADPLANS.AWD_DIST_PLAN_CD_DESC
, ADPLANS.DIST_PLAN_METHOD_CODE
, FMDET.LOCK_AWARD_FLAG
FROM IGF_AW_AWD_FRML_DET FMDET
, IGS_CA_INST CI
, IGF_AW_FUND_MAST FMAST
, IGF_AW_AWD_DIST_PLANS ADPLANS
WHERE FMDET.CI_CAL_TYPE = CI.CAL_TYPE
AND FMDET. CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FMAST.FUND_ID = FMDET.FUND_ID
AND FMDET.ADPLANS_ID = ADPLANS.ADPLANS_ID (+)