VIEW: APPS.IGSBV_PARTY_CHARGES

Source

View Text - Preformatted

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, 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 WHERE INV.INVOICE_ID = INVLN.INVOICE_ID WITH READ ONLY

View Text - HTML Formatted

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
, 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
WHERE INV.INVOICE_ID = INVLN.INVOICE_ID WITH READ ONLY