View: IGSFV_PARTY_CREDITS

View Text

SELECT CR.CREDIT_NUMBER
, '_LA:CR.STATUS:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_STATUS:MEANING'
, '_LA:CR.CREDIT_SOURCE:IGF_LOOKUPS_VIEW:IGF_AW_FED_FUND:MEANING'
, '_LA:CR.CREDIT_INSTRUMENT:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_INSTRUMENT:MEANING'
, CR.DESCRIPTION
, CR.AMOUNT
, CR.UNAPPLIED_AMOUNT
, CR.CURRENCY_CD
, CR.EXCHANGE_RATE
, CR.TRANSACTION_DATE
, CR.EFFECTIVE_DATE
, CR.CHECK_NUMBER
, '_LA:CR.CREDIT_CARD_CODE:IGS_LOOKUP_VALUES:IGS_CREDIT_CARDS:MEANING'
, CR.CREDIT_CARD_HOLDER_NAME
, CR.CREDIT_CARD_NUMBER
, CR.CREDIT_CARD_EXPIRATION_DATE
, CR.CREDIT_CARD_APPROVAL_CODE
, '_LA:CR.CREDIT_CARD_STATUS_CODE:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_CARD_STATUS:MEANING'
, CR.CREDIT_CARD_PAYEE_CD
, CR.CREDIT_CARD_TANGIBLE_CD
, CR.AWD_YR_CAL_TYPE
, CR.AWD_YR_CI_SEQUENCE_NUMBER
, CR.FEE_CAL_TYPE
, CR.FEE_CI_SEQUENCE_NUMBER
, CR.GL_DATE
, CR.SOURCE_TRANSACTION_TYPE
, CR.SOURCE_TRANSACTION_REF
, CR.REVERSAL_DATE
, '_LA:CR.REVERSAL_REASON_CODE:IGS_LOOKUP_VALUES:IGS_FI_REVERSAL_REASON:MEANING'
, CR.REVERSAL_COMMENTS
, CR.RECEIPT_LOCKBOX_NUMBER
, CR.BATCH_NAME
, CR.DEPOSIT_DATE
, CR.TAX_YEAR_CODE
, CR.WAIVER_NAME
, '_LA:CA.STATUS:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_STATUS:MEANING'
, CA.TRANSACTION_DATE
, CA.AMOUNT
, CA.DR_ACCOUNT_CD
, CA.CR_ACCOUNT_CD
, '_KF:SQLGL:GL#:GCC1'
, '_KF:SQLGL:GL#:GCC2'
, CA.BILL_NUMBER
, CA.BILL_DATE
, CA.GL_DATE
, CA.GL_POSTED_DATE
, '_DF:IGS:IGS_FI_CREDITS_ALL_FLEX:CR'
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, IB.NAME
, CI1.START_DT
, CI1.END_DT
, CI1.DESCRIPTION
, CI1.ALTERNATE_CODE
, CI2.START_DT
, CI2.END_DT
, CI2.DESCRIPTION
, CI2.ALTERNATE_CODE
, CP.CREDIT_TYPE_NAME
, '_LA:CP.CREDIT_CLASS:IGS_LOOKUP_VALUES:IGS_FI_CREDIT_CLASS:MEANING'
, FWP.WAIVER_DESC
, LO.LOCKBOX_DESC
, F1S.TAX_YEAR_NAME
, F1S.START_DATE
, F1S.END_DATE
, AC1.DESCRIPTION
, AC2.DESCRIPTION
, BI.CUT_OFF_DATE
, PO.BATCH_NAME
, INV.INVOICE_DESC
, CR.CREDIT_ID
, CA.CREDIT_ACTIVITY_ID
, CR.PARTY_ID
, CR.CREDIT_TYPE_ID
, CR.MERCHANT_ID
, CR.LOCKBOX_INTERFACE_ID
, CA.DR_GL_CCID
, CA.CR_GL_CCID
, CA.BILL_ID
, CA.POSTING_ID
, CA.POSTING_CONTROL_ID
, CR.SOURCE_INVOICE_ID
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
FROM IGS_FI_CREDITS_ALL CR
, IGS_FI_CR_ACTIVITIES CA
, HZ_PARTIES PA
, IGS_CA_INST_ALL CI1
, IGS_CA_INST_ALL CI2
, IGS_FI_CR_TYPES_ALL CP
, IGS_FI_WAIVER_PGMS FWP
, IGS_FI_ACC_ALL AC1
, IGS_FI_ACC_ALL AC2
, IGS_FI_BILL_ALL BI
, IGS_FI_POSTING_INT_ALL PO
, IGS_FI_LOCKBOXES LO
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, IBY_PAYEE IB
, IGS_FI_INV_INT_ALL INV
, IGS_FI_1098T_SETUP F1S
WHERE CR.CREDIT_ID = CA.CREDIT_ID
AND CR.PARTY_ID = PA.PARTY_ID
AND CR.CREDIT_TYPE_ID = CP.CREDIT_TYPE_ID
AND CP.CREDIT_CLASS NOT IN ('OTHDEPOSIT'
, 'ENRDEPOSIT')
AND CR.AWD_YR_CAL_TYPE = CI1.CAL_TYPE(+)
AND CR.AWD_YR_CI_SEQUENCE_NUMBER = CI1.SEQUENCE_NUMBER(+)
AND CR.FEE_CAL_TYPE = CI2.CAL_TYPE(+)
AND CR.FEE_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER(+)
AND CR. FEE_CAL_TYPE = FWP.FEE_CAL_TYPE (+)
AND CR.FEE_CI_SEQUENCE_NUMBER = FWP.FEE_CI_SEQUENCE_NUMBER (+)
AND CR.WAIVER_NAME = FWP.WAIVER_NAME (+)
AND CR.RECEIPT_LOCKBOX_NUMBER = LO.LOCKBOX_NAME(+)
AND CA.DR_ACCOUNT_CD = AC1.ACCOUNT_CD(+)
AND CA.CR_ACCOUNT_CD = AC2.ACCOUNT_CD(+)
AND CA.BILL_ID = BI.BILL_ID(+)
AND CA.POSTING_ID = PO.POSTING_ID(+)
AND CA.DR_GL_CCID = GCC1.CODE_COMBINATION_ID(+)
AND CA.CR_GL_CCID = GCC2.CODE_COMBINATION_ID(+)
AND CR.CREDIT_CARD_PAYEE_CD = IB.PAYEEID(+)
AND CR.SOURCE_INVOICE_ID = INV.INVOICE_ID (+)
AND CR.TAX_YEAR_CODE = F1S.TAX_YEAR_CODE (+) WITH READ ONLY

Columns