VIEW: APPS.IGF_AW_FUND_CAT_V

Source

View Text - Preformatted

SELECT fcat.row_id row_id ,fcat.fund_code fund_code ,fcat.description description ,fcat.fund_type fund_type ,ft.description fund_type_desc ,fcat.sys_fund_type sys_fund_type ,fnds1.meaning sys_fund_type_desc ,fcat.fund_source fund_source ,fnds2.meaning fund_source_desc ,fcat.fed_fund_code fed_fund_code ,fnds3.meaning fed_fund_code_desc ,fcat.active active ,fcat.created_by created_by ,fcat.creation_date creation_date ,fcat.last_updated_by last_updated_by ,fcat.last_update_date last_update_date ,fcat.last_update_login last_update_login ,fcat.fcat_id fcat_id ,fcat.alt_loan_code alt_loan_code ,fcat.alt_rel_code alt_rel_code ,igf_aw_gen.lookup_desc('IGF_SL_ALT_LOAN_CODE', fcat.alt_loan_code) ALT_LOAN_CODE_DESC FROM igf_aw_fund_cat fcat, igf_aw_fund_type ft, igf_lookups_view fnds1, igf_lookups_view fnds2, igf_lookups_view fnds3 WHERE fcat.fund_type = ft.fund_type AND fnds1.lookup_type = 'IGF_AW_SYS_FUND_TYPE' AND fcat.sys_fund_type = fnds1.lookup_code AND fnds2.lookup_type = 'IGF_AW_FUND_SOURCE' AND fcat.fund_source = fnds2.lookup_code AND fnds3.lookup_type = 'IGF_AW_FED_FUND' AND fcat.fed_fund_code = fnds3.lookup_code

View Text - HTML Formatted

SELECT FCAT.ROW_ID ROW_ID
, FCAT.FUND_CODE FUND_CODE
, FCAT.DESCRIPTION DESCRIPTION
, FCAT.FUND_TYPE FUND_TYPE
, FT.DESCRIPTION FUND_TYPE_DESC
, FCAT.SYS_FUND_TYPE SYS_FUND_TYPE
, FNDS1.MEANING SYS_FUND_TYPE_DESC
, FCAT.FUND_SOURCE FUND_SOURCE
, FNDS2.MEANING FUND_SOURCE_DESC
, FCAT.FED_FUND_CODE FED_FUND_CODE
, FNDS3.MEANING FED_FUND_CODE_DESC
, FCAT.ACTIVE ACTIVE
, FCAT.CREATED_BY CREATED_BY
, FCAT.CREATION_DATE CREATION_DATE
, FCAT.LAST_UPDATED_BY LAST_UPDATED_BY
, FCAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FCAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FCAT.FCAT_ID FCAT_ID
, FCAT.ALT_LOAN_CODE ALT_LOAN_CODE
, FCAT.ALT_REL_CODE ALT_REL_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_ALT_LOAN_CODE'
, FCAT.ALT_LOAN_CODE) ALT_LOAN_CODE_DESC
FROM IGF_AW_FUND_CAT FCAT
, IGF_AW_FUND_TYPE FT
, IGF_LOOKUPS_VIEW FNDS1
, IGF_LOOKUPS_VIEW FNDS2
, IGF_LOOKUPS_VIEW FNDS3
WHERE FCAT.FUND_TYPE = FT.FUND_TYPE
AND FNDS1.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND FCAT.SYS_FUND_TYPE = FNDS1.LOOKUP_CODE
AND FNDS2.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND FCAT.FUND_SOURCE = FNDS2.LOOKUP_CODE
AND FNDS3.LOOKUP_TYPE = 'IGF_AW_FED_FUND'
AND FCAT.FED_FUND_CODE = FNDS3.LOOKUP_CODE