JL_BR_AR_COLL_DOC_DISTS_L_V

Details

• Schema: FUSION

• Object owner: JL

• Object type: VIEW

Columns

Name

ORG_ID JLBR_DISTRIBUTION_ID JLBR_DOCUMENT_ID JLBR_OCCURRENCE_ID JLBR_DISTRIBUTION_TYPE JLBR_ENTERED_AMT JLBR_ENTERED_CURRENCY_CODE JLBR_ACCTD_AMT JLBR_CONVERSION_RATE JLBR_CONVERSION_DATE JLBR_CONVERSION_RATE_TYPE JLBR_ACCT_REVERSING_OPTN JLBR_REVERSED_DIST_ID JLBR_REVERSED_DIST_LINK_TYPE JLBR_PRIOR_DIST_ID JLBR_PRIOR_DIST_LINK_TYPE JLBR_PRIOR_OCCURRENCE_ID JLBR_PRIOR_DOCUMENT_ID JLBR_DISTRIBUTION_LINK_TYPE EVENT_ID EVENT_DATE JLBR_STD_OCC_CODE JLBR_BORDERO_TYPE JLBR_BANK_OCC_TYPE LINE_NUMBER JLBR_CD_BIL_UND_COLL_CCID JLBR_CD_BIL_UND_DISC_CCID JLBR_CD_COLL_ENDRSMNT_CCID JLBR_CD_DISC_ENDRSMNT_CCID JLBR_CD_BANK_CHARGES_CCID JLBR_CD_FACT_CHARGES_CCID JLBR_CD_CASH_CCID OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT dist.ORG_ID, dist.DISTRIBUTION_ID JLBR_DISTRIBUTION_ID, dist.DOCUMENT_ID JLBR_DOCUMENT_ID, dist.OCCURRENCE_ID JLBR_OCCURRENCE_ID, dist.DISTRIBUTION_TYPE JLBR_DISTRIBUTION_TYPE, dist.ENTERED_AMT JLBR_ENTERED_AMT, dist.ENTERED_CURRENCY_CODE JLBR_ENTERED_CURRENCY_CODE, dist.ACCTD_AMT JLBR_ACCTD_AMT, dist.CONVERSION_RATE JLBR_CONVERSION_RATE, dist.CONVERSION_DATE JLBR_CONVERSION_DATE, dist.CONVERSION_RATE_TYPE JLBR_CONVERSION_RATE_TYPE, dist.ACCOUNTING_REVERSAL_OPTION JLBR_ACCT_REVERSING_OPTN, dist.REVERSED_DIST_ID JLBR_REVERSED_DIST_ID, dist.REVERSED_DIST_LINK_TYPE JLBR_REVERSED_DIST_LINK_TYPE, dist.PRIOR_DIST_ID JLBR_PRIOR_DIST_ID, dist.PRIOR_DIST_LINK_TYPE JLBR_PRIOR_DIST_LINK_TYPE, priordist.OCCURRENCE_ID JLBR_PRIOR_OCCURRENCE_ID, priordist.DOCUMENT_ID JLBR_PRIOR_DOCUMENT_ID, dist.DISTRIBUTION_LINK_TYPE JLBR_DISTRIBUTION_LINK_TYPE, dist.EVENT_ID, dist.EVENT_DATE, dist.STD_OCCURRENCE_CODE JLBR_STD_OCC_CODE, dist.BORDERO_TYPE JLBR_BORDERO_TYPE, dist.BANK_OCCURRENCE_TYPE JLBR_BANK_OCC_TYPE, dist.DIST_LINE_NUMBER LINE_NUMBER, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_ENDORSEMENT', DECODE(dist.BORDERO_TYPE, 'COLLECTION', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_DEBIT_CCID, occ.ENDORSEMENT_CREDIT_CCID), 'OCCURRENCE', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_DEBIT_CCID, occ.ENDORSEMENT_CREDIT_CCID), NULL), NULL) JLBR_CD_BIL_UND_COLL_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_ENDORSEMENT', DECODE(dist.BORDERO_TYPE, 'FACTORING', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_DEBIT_CCID, occ.ENDORSEMENT_CREDIT_CCID), NULL), NULL) JLBR_CD_BIL_UND_DISC_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_ENDORSEMENT', DECODE(dist.BORDERO_TYPE, 'COLLECTION', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_CREDIT_CCID, occ.ENDORSEMENT_DEBIT_CCID), 'OCCURRENCE', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_CREDIT_CCID, occ.ENDORSEMENT_DEBIT_CCID), NULL), NULL) JLBR_CD_COLL_ENDRSMNT_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_ENDORSEMENT', DECODE(dist.BORDERO_TYPE, 'FACTORING', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.ENDORSEMENT_CREDIT_CCID, occ.ENDORSEMENT_DEBIT_CCID), NULL), NULL) JLBR_CD_DISC_ENDRSMNT_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_BANK_CHARGES', DECODE(dist.ACCOUNTING_REVERSAL_OPTION, 'N', occ.BANK_CHARGES_DEBIT_CCID, DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.BANK_CHARGES_DEBIT_CCID, occ.REVERSE_CHARGES_CRED_CCID)), NULL) JLBR_CD_BANK_CHARGES_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_FACTORING_CHARGES', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.FACTOR_INTEREST_DEBIT_CCID, occ.FACTOR_INTEREST_CREDIT_CCID), NULL) JLBR_CD_FACT_CHARGES_CCID, DECODE(dist.DISTRIBUTION_TYPE, 'JLBR_AR_BANK_CHARGES', DECODE(dist.ACCOUNTING_REVERSAL_OPTION, 'N', occ.BANK_CHARGES_CREDIT_CCID, DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.BANK_CHARGES_CREDIT_CCID, occ.REVERSE_CHARGES_DEB_CCID)), 'JLBR_AR_FACTORING_CHARGES', DECODE(dist.STD_OCCURRENCE_CODE, 'REMITTANCE', occ.FACTOR_INTEREST_CREDIT_CCID, occ.FACTOR_INTEREST_DEBIT_CCID), NULL) JLBR_CD_CASH_CCID ,dist.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM JL_BR_AR_DISTRIBUTNS_ALL dist, JL_BR_AR_OCCURRENCE_DOCS_ALL occ, JL_BR_AR_DISTRIBUTNS_ALL priordist WHERE occ.OCCURRENCE_ID = dist.OCCURRENCE_ID AND priordist.DISTRIBUTION_ID(+) = NVL(dist.PRIOR_DIST_ID, -88)