VIEW: APPS.IGF_AW_FUND_TP_V

Source

View Text - Preformatted

SELECT FTP.ROW_ID ,FTP.FUND_ID ,FMAST.FUND_CODE ,FMAST.DESCRIPTION ,FTP.TP_CAL_TYPE ,FTP.TP_SEQUENCE_NUMBER ,CI.ALTERNATE_CODE ,CI.START_DT ,CI.END_DT ,FTP.TP_PERCT ,FTP.CREATED_BY ,FTP.CREATION_DATE ,FTP.LAST_UPDATE_DATE ,FTP.LAST_UPDATED_BY ,FTP.LAST_UPDATE_LOGIN , FMAST.CI_CAL_TYPE , FMAST.CI_SEQUENCE_NUMBER ,AWD.ALTERNATE_CODE AWD_ALTERNATE_CODE ,AWD.START_DT AWD_START_DATE ,AWD.END_DT AWD_END_DATE FROM IGF_AW_FUND_TP FTP , IGS_CA_INST CI, IGS_CA_INST AWD, IGF_AW_FUND_MAST FMAST WHERE FTP.TP_CAL_TYPE = CI.CAL_TYPE AND FTP.TP_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND FTP.FUND_ID = FMAST.FUND_ID AND FMAST.CI_CAL_TYPE = AWD.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = AWD.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT FTP.ROW_ID
, FTP.FUND_ID
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, FTP.TP_CAL_TYPE
, FTP.TP_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FTP.TP_PERCT
, FTP.CREATED_BY
, FTP.CREATION_DATE
, FTP.LAST_UPDATE_DATE
, FTP.LAST_UPDATED_BY
, FTP.LAST_UPDATE_LOGIN
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, AWD.ALTERNATE_CODE AWD_ALTERNATE_CODE
, AWD.START_DT AWD_START_DATE
, AWD.END_DT AWD_END_DATE
FROM IGF_AW_FUND_TP FTP
, IGS_CA_INST CI
, IGS_CA_INST AWD
, IGF_AW_FUND_MAST FMAST
WHERE FTP.TP_CAL_TYPE = CI.CAL_TYPE
AND FTP.TP_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND FTP.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = AWD.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWD.SEQUENCE_NUMBER