VIEW: APPS.IGF_AW_TP_INSTMT_V

Source

View Text - Preformatted

SELECT FINST.ROW_ID, FINST.FUND_ID, FINST.FINST_ID, FINST.LD_CAL_TYPE, FINST.LD_SEQUENCE_NUMBER , LD_CAL.ALTERNATE_CODE, LD_CAL.START_DT , LD_CAL.END_DT , FINST.TP_CAL_TYPE , FINST.TP_SEQUENCE_NUMBER , TP_CAL.ALTERNATE_CODE , TP_CAL.START_DT , TP_CAL.END_DT, FINST.TP_OFFSET_DA, FINST.TP_PERCT , FINST.MIN_CREDIT_PTS, FINST.CREATED_BY , FINST.CREATION_DATE, FINST.LAST_UPDATED_BY, FINST.LAST_UPDATE_DATE, FINST.LAST_UPDATE_LOGIN FROM IGF_AW_TP_INSTMT FINST, IGS_CA_INST LD_CAL, IGS_CA_INST TP_CAL WHERE FINST.LD_CAL_TYPE = LD_CAL.CAL_TYPE AND FINST.LD_SEQUENCE_NUMBER = LD_CAL.SEQUENCE_NUMBER AND FINST.TP_CAL_TYPE = TP_CAL.CAL_TYPE AND FINST.TP_SEQUENCE_NUMBER = TP_CAL.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT FINST.ROW_ID
, FINST.FUND_ID
, FINST.FINST_ID
, FINST.LD_CAL_TYPE
, FINST.LD_SEQUENCE_NUMBER
, LD_CAL.ALTERNATE_CODE
, LD_CAL.START_DT
, LD_CAL.END_DT
, FINST.TP_CAL_TYPE
, FINST.TP_SEQUENCE_NUMBER
, TP_CAL.ALTERNATE_CODE
, TP_CAL.START_DT
, TP_CAL.END_DT
, FINST.TP_OFFSET_DA
, FINST.TP_PERCT
, FINST.MIN_CREDIT_PTS
, FINST.CREATED_BY
, FINST.CREATION_DATE
, FINST.LAST_UPDATED_BY
, FINST.LAST_UPDATE_DATE
, FINST.LAST_UPDATE_LOGIN
FROM IGF_AW_TP_INSTMT FINST
, IGS_CA_INST LD_CAL
, IGS_CA_INST TP_CAL
WHERE FINST.LD_CAL_TYPE = LD_CAL.CAL_TYPE
AND FINST.LD_SEQUENCE_NUMBER = LD_CAL.SEQUENCE_NUMBER
AND FINST.TP_CAL_TYPE = TP_CAL.CAL_TYPE
AND FINST.TP_SEQUENCE_NUMBER = TP_CAL.SEQUENCE_NUMBER