Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is created from multi-org filtered flat view IGS_FI_INVLN_INT for presentation of data in Charges History Form. |
Implementation/DBA Data: | Not implemented in this database |
SELECT FII.ROWID
, FII.INVOICE_LINES_ID
, FII.INVOICE_ID
, FII.LINE_NUMBER
, FII.S_CHG_METHOD_TYPE
, FII.DESCRIPTION
, FII.CHG_ELEMENTS
, FII.AMOUNT
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, FII.UNIT_ATTEMPT_STATUS
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.UNIT_CLASS
, FII.EFTSU
, FII.CREDIT_POINTS
, FII.REC_ACCOUNT_CD
, FII.REV_ACCOUNT_CD
, FII.REC_GL_CCID
, FII.REV_GL_CCID
, FII.ORG_UNIT_CD
, FII.POSTING_ID
, FII.SOURCE_TRANSACTION_ID
, FII.ATTRIBUTE_CATEGORY
, FII.ATTRIBUTE1
, FII.ATTRIBUTE2
, FII.ATTRIBUTE3
, FII.ATTRIBUTE4
, FII.ATTRIBUTE5
, FII.ATTRIBUTE6
, FII.ATTRIBUTE7
, FII.ATTRIBUTE8
, FII.ATTRIBUTE9
, FII.ATTRIBUTE10
, FII.ATTRIBUTE11
, FII.ATTRIBUTE12
, FII.ATTRIBUTE13
, FII.ATTRIBUTE14
, FII.ATTRIBUTE15
, FII.ATTRIBUTE16
, FII.ATTRIBUTE17
, FII.ATTRIBUTE18
, FII.ATTRIBUTE19
, FII.ATTRIBUTE20
, FII.ORG_ID
, FII.LAST_UPDATE_DATE
, FII.LAST_UPDATED_BY
, FII.CREATION_DATE
, FII.CREATED_BY
, FII.LAST_UPDATE_LOGIN
, FII.REQUEST_ID
, FII.PROGRAM_APPLICATION_ID
, FII.PROGRAM_ID
, FII.PROGRAM_UPDATE_DATE
, FII.ERROR_STRING
, FII.ERROR_ACCOUNT
, FII.LOCATION_CD
, FII.UOO_ID
, FII.GL_DATE
, FII.GL_POSTED_DATE
, FII.POSTING_CONTROL_ID
, FII.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FII.UNIT_LEVEL
FROM IGS_FI_INVLN_INT FII
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE UOO.UOO_ID (+) = FII.UOO_ID
AND FII.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)