VIEW: APPS.IGSBV_PARTY_CREDITS

Source

View Text - Preformatted

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, ca.bill_number, ca.bill_date, ca.gl_date, ca.gl_posted_date, pa.party_number, pa.party_name, 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_fi_cr_types_all cp 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') WITH READ ONLY

View Text - HTML Formatted

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
, CA.BILL_NUMBER
, CA.BILL_DATE
, CA.GL_DATE
, CA.GL_POSTED_DATE
, PA.PARTY_NUMBER
, PA.PARTY_NAME
, 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_FI_CR_TYPES_ALL CP
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') WITH READ ONLY