VIEW: APPS.IGSFV_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, 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

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
, 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