VIEW: APPS.IGF_SE_WORK_AWD_PRG_V

Source

View Text - Preformatted

SELECT SE.ROWID ROW_ID, AWD.BASE_ID, AWD.AWARD_ID, AWD.FUND_ID, FM.FUND_CODE, FM.DESCRIPTION FUND_CODE_DESC, FC.FED_FUND_CODE, AWD.AWARD_STATUS, SE.AUTH_ID, SE.AUTHORIZATION_DATE, AWD.OFFERED_AMT, AWD.ACCEPTED_AMT, SE.ACCEPTED_AMNT, AWD.PAID_AMT, (NVL(AWD.ACCEPTED_AMT,0) - NVL(AWD.PAID_AMT,0)) REMAINING_AMT, DECODE(NVL(AWD.ACCEPTED_AMT,0), 0, 0, ROUND(NVL(AWD.PAID_AMT,0) * 100/ AWD.ACCEPTED_AMT)) PROGRESS_TWDS_LMT, SE.NOTIFICATION_DATE, AWD.LEGACY_RECORD_FLAG, SE.CREATED_BY, SE.CREATION_DATE, SE.LAST_UPDATED_BY, SE.LAST_UPDATE_DATE, SE.LAST_UPDATE_LOGIN FROM IGF_AW_AWARD_ALL AWD, IGF_AW_FUND_MAST_ALL FM, IGF_AW_FUND_CAT FC, IGF_SE_AUTH SE WHERE SE.AWARD_ID(+) = AWD.AWARD_ID AND AWD.FUND_ID = FM.FUND_ID AND FM.FUND_CODE = FC.FUND_CODE AND FC.FED_FUND_CODE = 'FWS' AND SE.FLAG(+) = 'A'

View Text - HTML Formatted

SELECT SE.ROWID ROW_ID
, AWD.BASE_ID
, AWD.AWARD_ID
, AWD.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION FUND_CODE_DESC
, FC.FED_FUND_CODE
, AWD.AWARD_STATUS
, SE.AUTH_ID
, SE.AUTHORIZATION_DATE
, AWD.OFFERED_AMT
, AWD.ACCEPTED_AMT
, SE.ACCEPTED_AMNT
, AWD.PAID_AMT
, (NVL(AWD.ACCEPTED_AMT
, 0) - NVL(AWD.PAID_AMT
, 0)) REMAINING_AMT
, DECODE(NVL(AWD.ACCEPTED_AMT
, 0)
, 0
, 0
, ROUND(NVL(AWD.PAID_AMT
, 0) * 100/ AWD.ACCEPTED_AMT)) PROGRESS_TWDS_LMT
, SE.NOTIFICATION_DATE
, AWD.LEGACY_RECORD_FLAG
, SE.CREATED_BY
, SE.CREATION_DATE
, SE.LAST_UPDATED_BY
, SE.LAST_UPDATE_DATE
, SE.LAST_UPDATE_LOGIN
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FM
, IGF_AW_FUND_CAT FC
, IGF_SE_AUTH SE
WHERE SE.AWARD_ID(+) = AWD.AWARD_ID
AND AWD.FUND_ID = FM.FUND_ID
AND FM.FUND_CODE = FC.FUND_CODE
AND FC.FED_FUND_CODE = 'FWS'
AND SE.FLAG(+) = 'A'