VIEW: APPS.IGF_AW_AWD_FRML_DET_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)