[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Contains details of charges for a person |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INV.PERSON_ID
, INV.INVOICE_ID
, INVLN.INVOICE_LINES_ID
, INV.INVOICE_NUMBER
, INVLN.LINE_NUMBER
, '_LA:TRANSACTION_TYPE:IGS_LOOKUP_VALUES:TRANSACTION_TYPE:MEANING'
, INV.INVOICE_CREATION_DATE
, INV.INVOICE_DESC
, INVLN.DESCRIPTION
, INV.INVOICE_AMOUNT
, INVLN.AMOUNT
, INV.INVOICE_AMOUNT_DUE
, INV.CURRENCY_CD
, INV.EXCHANGE_RATE
, INV.EFFECTIVE_DATE
, INV.FEE_CAL_TYPE
, INV.FEE_CI_SEQUENCE_NUMBER
, INVLN.REC_ACCOUNT_CD
, INVLN.REV_ACCOUNT_CD
, INVLN.REC_GL_CCID
, INVLN.REV_GL_CCID
, INV.FEE_TYPE
, INV.FEE_CAT
, INV.BILL_NUMBER
, INV.BILL_DATE
, INVLN.GL_DATE
, INVLN.GL_POSTED_DATE
, INV.REVERSAL_GL_DATE
, INVLN.ERROR_STRING
, INVLN.ERROR_ACCOUNT
, INV.WAIVER_FLAG
, INV.WAIVER_REASON
, INV.BILL_PAYMENT_DUE_DATE
, INV.OPTIONAL_FEE_FLAG
, '_LA:S_CHG_METHOD_TYPE:IGS_LOOKUP_VALUES:CHG_METHOD:MEANING'
, INVLN.CHG_ELEMENTS
, INVLN.EFTSU
, INVLN.CREDIT_POINTS
, INV.COURSE_CD
, INVLN.LOCATION_CD
, INV.ATTENDANCE_MODE
, INV.ATTENDANCE_TYPE
, INV.TAX_YEAR_CODE
, INV.WAIVER_NAME
, INVLN.UNIT_ATTEMPT_STATUS
, INVLN.ORG_UNIT_CD
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, ACC1.DESCRIPTION
, ACC2.DESCRIPTION
, '_KF:SQLGL:GL#:GCC1'
, '_KF:SQLGL:GL#:GCC2'
, BL.CUT_OFF_DATE
, PS.BATCH_NAME
, FWP.WAIVER_DESC
, PUT.LEVEL_CODE
, PUT.DESCRIPTION
, UL.DESCRIPTION
, F1S.TAX_YEAR_NAME
, F1S.START_DATE
, F1S.END_DATE
, '_DF:IGS:IGS_FI_INVLN_INT_ALL_FLEX:INVLN'
, INV.BILL_ID
, INVLN.UOO_ID
, INVLN.POSTING_ID
, INVLN.POSTING_CONTROL_ID
, INVLN.UNIT_TYPE_ID
, INVLN.UNIT_LEVEL
, INVLN.CREATED_BY
, INVLN.CREATION_DATE
, INVLN.LAST_UPDATED_BY
, INVLN.LAST_UPDATE_DATE
FROM IGS_FI_INV_INT_ALL INV
, IGS_FI_INVLN_INT_ALL INVLN
, HZ_PARTIES HZ
, IGS_FI_ACC_ALL ACC1
, IGS_FI_ACC_ALL ACC2
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, IGS_FI_BILL_ALL BL
, IGS_FI_POSTING_INT_ALL PS
, IGS_FI_1098T_SETUP F1S
, IGS_PS_UNIT_TYPE_LVL PUT
, IGS_PS_UNIT_LEVEL_ALL UL
, IGS_FI_WAIVER_PGMS FWP
WHERE INV.INVOICE_ID = INVLN.INVOICE_ID
AND INV.PERSON_ID = HZ.PARTY_ID
AND INVLN.REC_ACCOUNT_CD = ACC1.ACCOUNT_CD (+)
AND INVLN.REV_ACCOUNT_CD = ACC2.ACCOUNT_CD (+)
AND INVLN.REC_GL_CCID = GCC1.CODE_COMBINATION_ID (+)
AND INVLN.REV_GL_CCID = GCC2.CODE_COMBINATION_ID (+)
AND INV.BILL_ID = BL.BILL_ID (+)
AND INVLN.POSTING_ID = PS.POSTING_ID (+)
AND INV.TAX_YEAR_CODE = F1S.TAX_YEAR_CODE(+)
AND INVLN.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)
AND INVLN.UNIT_LEVEL = UL.UNIT_LEVEL(+)
AND INV.FEE_CAL_TYPE = FWP.FEE_CAL_TYPE (+)
AND INV.FEE_CI_SEQUENCE_NUMBER = FWP.FEE_CI_SEQUENCE_NUMBER (+)
AND INV.WAIVER_NAME = FWP.WAIVER_NAME (+) WITH READ ONLY