VIEW: APPS.IGF_AW_FN_RPKG_PRTY_V

Source

View Text - Preformatted

SELECT RPP.ROWID, RPP.FUND_ORDER_NUM, RPP.CI_CAL_TYPE, RPP.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, RPP.FUND_ID, FM.FUND_CODE, FM.DESCRIPTION, FNDS1.MEANING SYS_FUND_TYPE_DESC, FNDS2.MEANING FUND_SOURCE_DESC, FNDS3.MEANING SYS_FUND_CODE_DESC, RPP.CREATED_BY, RPP.CREATION_DATE, RPP.LAST_UPDATED_BY, RPP.LAST_UPDATE_DATE, RPP.LAST_UPDATE_LOGIN FROM IGF_AW_FN_RPKG_PRTY RPP, IGF_AW_FUND_MAST_V FM, IGF_LOOKUPS_VIEW FNDS1, IGF_LOOKUPS_VIEW FNDS2, IGF_LOOKUPS_VIEW FNDS3 , IGS_CA_INST CA WHERE FM.FUND_ID = RPP.FUND_ID AND FNDS1.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE' AND FM.SYS_FUND_TYPE = FNDS1.LOOKUP_CODE AND FNDS2.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE' AND FM.FUND_SOURCE = FNDS2.LOOKUP_CODE AND FNDS3.LOOKUP_TYPE = 'IGF_AW_FED_FUND' AND FM.FED_FUND_CODE = FNDS3.LOOKUP_CODE AND CA.CAL_TYPE = RPP.CI_CAL_TYPE AND CA.SEQUENCE_NUMBER = RPP.CI_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT RPP.ROWID
, RPP.FUND_ORDER_NUM
, RPP.CI_CAL_TYPE
, RPP.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, RPP.FUND_ID
, FM.FUND_CODE
, FM.DESCRIPTION
, FNDS1.MEANING SYS_FUND_TYPE_DESC
, FNDS2.MEANING FUND_SOURCE_DESC
, FNDS3.MEANING SYS_FUND_CODE_DESC
, RPP.CREATED_BY
, RPP.CREATION_DATE
, RPP.LAST_UPDATED_BY
, RPP.LAST_UPDATE_DATE
, RPP.LAST_UPDATE_LOGIN
FROM IGF_AW_FN_RPKG_PRTY RPP
, IGF_AW_FUND_MAST_V FM
, IGF_LOOKUPS_VIEW FNDS1
, IGF_LOOKUPS_VIEW FNDS2
, IGF_LOOKUPS_VIEW FNDS3
, IGS_CA_INST CA
WHERE FM.FUND_ID = RPP.FUND_ID
AND FNDS1.LOOKUP_TYPE = 'IGF_AW_SYS_FUND_TYPE'
AND FM.SYS_FUND_TYPE = FNDS1.LOOKUP_CODE
AND FNDS2.LOOKUP_TYPE = 'IGF_AW_FUND_SOURCE'
AND FM.FUND_SOURCE = FNDS2.LOOKUP_CODE
AND FNDS3.LOOKUP_TYPE = 'IGF_AW_FED_FUND'
AND FM.FED_FUND_CODE = FNDS3.LOOKUP_CODE
AND CA.CAL_TYPE = RPP.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = RPP.CI_SEQUENCE_NUMBER