VIEW: APPS.IGSFV_PAY_PLAN_INSTALLMENTS

Source

View Text - Preformatted

SELECT PP.INSTALLMENT_ID, PP.STUDENT_PLAN_ID, PP.INSTALLMENT_LINE_NUM, PP.DUE_DAY, '_LA:DUE_MONTH_CODE:IGS_LOOKUP_VALUES:VS_CA_MONTH:MEANING', PP.DUE_YEAR, PP.DUE_DATE, PP.INSTALLMENT_AMT, PP.DUE_AMT, PP.PENALTY_FLAG, STD.PERSON_ID, HZ.PARTY_NUMBER, HZ.PARTY_NAME, STD.PAYMENT_PLAN_NAME, STD.PLAN_START_DATE, STD.PLAN_END_DATE, PP.CREATED_BY, PP.CREATION_DATE, PP.LAST_UPDATE_DATE, PP.LAST_UPDATED_BY FROM IGS_FI_PP_INSTLMNTS PP, IGS_FI_PP_STD_ATTRS STD, HZ_PARTIES HZ WHERE PP.STUDENT_PLAN_ID = STD.STUDENT_PLAN_ID AND HZ.PARTY_ID = STD.PERSON_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PP.INSTALLMENT_ID
, PP.STUDENT_PLAN_ID
, PP.INSTALLMENT_LINE_NUM
, PP.DUE_DAY
, '_LA:DUE_MONTH_CODE:IGS_LOOKUP_VALUES:VS_CA_MONTH:MEANING'
, PP.DUE_YEAR
, PP.DUE_DATE
, PP.INSTALLMENT_AMT
, PP.DUE_AMT
, PP.PENALTY_FLAG
, STD.PERSON_ID
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, STD.PAYMENT_PLAN_NAME
, STD.PLAN_START_DATE
, STD.PLAN_END_DATE
, PP.CREATED_BY
, PP.CREATION_DATE
, PP.LAST_UPDATE_DATE
, PP.LAST_UPDATED_BY
FROM IGS_FI_PP_INSTLMNTS PP
, IGS_FI_PP_STD_ATTRS STD
, HZ_PARTIES HZ
WHERE PP.STUDENT_PLAN_ID = STD.STUDENT_PLAN_ID
AND HZ.PARTY_ID = STD.PERSON_ID WITH READ ONLY