VIEW: APPS.IGS_FI_CR_TYPES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)