Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This view is created to be used in Credit Types form. All associated descriptions are obtained by joining with the setup tables. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CRT.ROWID
, CRT.CREDIT_TYPE_ID
, CRT.CREDIT_TYPE_NAME
, CRT.DESCRIPTION
, LKV.MEANING
, CRT.CREDIT_CLASS
, NULL
, CRT.SUBACCOUNT_ID
, CRT.EFFECTIVE_START_DATE
, CRT.EFFECTIVE_END_DATE
, CRT.REFUND_ALLOWED
, CRT.PAYMENT_PRIORITY
, CRT.DR_ACCOUNT_CD
, ACC1.DESCRIPTION
, CRT.CR_ACCOUNT_CD
, ACC2.DESCRIPTION
, CRT.DR_GL_CCID
, CRT.CR_GL_CCID
, CRT.TITLE4_TYPE_IND
, CRT.ORG_ID
, CRT.ATTRIBUTE_CATEGORY
, CRT.ATTRIBUTE1
, CRT.ATTRIBUTE2
, CRT.ATTRIBUTE3
, CRT.ATTRIBUTE4
, CRT.ATTRIBUTE5
, CRT.ATTRIBUTE6
, CRT.ATTRIBUTE7
, CRT.ATTRIBUTE8
, CRT.ATTRIBUTE9
, CRT.ATTRIBUTE10
, CRT.ATTRIBUTE11
, CRT.ATTRIBUTE12
, CRT.ATTRIBUTE13
, CRT.ATTRIBUTE14
, CRT.ATTRIBUTE15
, CRT.ATTRIBUTE16
, CRT.ATTRIBUTE17
, CRT.ATTRIBUTE18
, CRT.ATTRIBUTE19
, CRT.ATTRIBUTE20
, CRT.LAST_UPDATED_BY
, CRT.LAST_UPDATE_LOGIN
, CRT.LAST_UPDATE_DATE
, CRT.CREATED_BY
, CRT.CREATION_DATE
, CRT.PAYMENT_CREDIT_TYPE_ID
, CRT1.CREDIT_TYPE_NAME
, CRT.FORFEITURE_GL_CCID
, CRT.FORFEITURE_ACCOUNT_CD
, ACC3.DESCRIPTION
, AH.APPL_HIERARCHY_ID
, AH.HIERARCHY_NAME
, AH.VERSION_NUMBER
FROM IGS_FI_CR_TYPES CRT
, IGS_FI_CR_TYPES CRT1
, IGS_FI_ACC ACC1
, IGS_FI_ACC ACC2
, IGS_FI_ACC ACC3
, IGS_LOOKUPS_VIEW LKV
, IGS_FI_A_HIERARCHIES AH
WHERE CRT.PAYMENT_CREDIT_TYPE_ID = CRT1.CREDIT_TYPE_ID (+)
AND CRT.DR_ACCOUNT_CD = ACC1.ACCOUNT_CD (+)
AND CRT.CR_ACCOUNT_CD = ACC2.ACCOUNT_CD (+)
AND CRT.FORFEITURE_ACCOUNT_CD = ACC3.ACCOUNT_CD (+)
AND CRT.CREDIT_CLASS = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_CLASS'
AND CRT.APPL_HIERARCHY_ID = AH.APPL_HIERARCHY_ID (+)