{"id":946,"date":"2016-12-01T14:11:01","date_gmt":"2016-12-01T06:11:01","guid":{"rendered":"http:\/\/www.oracle.name\/?p=946"},"modified":"2016-12-01T14:13:16","modified_gmt":"2016-12-01T06:13:16","slug":"%e5%ba%94%e6%94%b6%e7%95%8c%e9%9d%a2%e4%bf%a1%e6%81%af%e8%8e%b7%e5%8f%96","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=946","title":{"rendered":"\u5e94\u6536\u6536\u6b3e\u754c\u9762\u4fe1\u606f\u83b7\u53d6"},"content":{"rendered":"<p>\n\tSELECT CR.CASH_RECEIPT_ID CASH_RECEIPT_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.CASH_RECEIPT_HISTORY_ID CASH_RECEIPT_HISTORY_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.AMOUNT AMOUNT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.ACCTD_AMOUNT FUNCTIONAL_AMOUNT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.AMOUNT NET_AMOUNT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.RECEIPT_NUMBER RECEIPT_NUMBER,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.RECEIPT_DATE RECEIPT_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.TYPE TYPE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.STATUS RECEIPT_STATUS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ARPT_SQL_FUNC_UTIL.get_lookup_meaning(&#39;CHECK_STATUS&#39;, CR.STATUS) RECEIPT_STATUS_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.COMMENTS COMMENTS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.MISC_PAYMENT_SOURCE MISC_PAYMENT_SOURCE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.EXCHANGE_RATE EXCHANGE_RATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.EXCHANGE_DATE EXCHANGE_RATE_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_DCT.USER_CONVERSION_TYPE EXCHANGE_RATE_TYPE_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.DOC_SEQUENCE_ID DOC_SEQUENCE_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.DOC_SEQUENCE_VALUE DOCUMENT_NUMBER,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.CUSTOMER_RECEIPT_REFERENCE CUSTOMER_RECEIPT_REFERENCE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_METHOD.NAME PAYMENT_METHOD_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_METHOD.PAYMENT_CHANNEL_CODE PAYMENT_TYPE_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_METHOD.RECEIPT_METHOD_ID RECEIPT_METHOD_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RC.NAME RECEIPT_CLASS_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RC.BILL_OF_EXCHANGE_FLAG BILL_OF_EXCHANGE_FLAG,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RC.CREATION_METHOD_CODE CREATION_METHOD_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.PAY_FROM_CUSTOMER CUSTOMER_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RTRIM(RTRIM(SUBSTRB(PARTY.PARTY_NAME, 1, 50)), to_multi_byte(&#39; &#39;)) CUSTOMER_NAME,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arp_etax_util.get_taxpayer_masked_value(PARTY.JGZZ_FISCAL_CODE) TAXPAYER_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SITE_USES.LOCATION LOCATION,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.CUSTOMER_BANK_BRANCH_ID CUSTOMER_BANK_BRANCH_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(RC.CREATION_METHOD_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;MANUAL&#39;,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EBA.BANK_ACCOUNT_NUMBER,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; null) CUSTOMER_BANK_ACCOUNT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(RC.CREATION_METHOD_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;MANUAL&#39;,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EBA.BANK_ACCOUNT_NUMBER,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; null) CUSTOMER_BANK_ACCOUNT_NUM,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(RC.CREATION_METHOD_CODE, &#39;MANUAL&#39;, EBA.BANK_NAME, NULL) CUSTOMER_BANK_NAME,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(RC.CREATION_METHOD_CODE, &#39;MANUAL&#39;, EBA.BANK_BRANCH_NAME, NULL) CUSTOMER_BANK_BRANCH,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_FIRST_POSTED.BATCH_ID BATCH_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(RC.CREATION_METHOD_CODE, &#39;BR&#39;, BAT_BR.NAME, BAT.NAME) BATCH_NAME \/* 20-APR-2000 J Rautiainen BR Implementation *\/,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DIST_SET.DISTRIBUTION_SET_NAME DISTRIBUTION_SET,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.DEPOSIT_DATE DEPOSIT_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REFERENCE_TYPE REFERENCE_TYPE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.VAT_TAX_ID VAT_TAX_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VAT.TAX_RATE_CODE TAX_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.TAX_RATE TAX_RATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NVL(ARP_MISC_CASH_DIST.MISC_CASH_TAX_LINE_CCID_IN_ARD(CR.CASH_RECEIPT_ID),<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; accounts.TAX_ACCOUNT_CCID) TAX_ACCOUNT_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VAT.ALLOW_ADHOC_TAX_RATE_FLAG ADHOC_FLAG,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L_REF_TYPE.MEANING REFERENCE_TYPE_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REFERENCE_ID REFERENCE_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REMIT_BANK_ACCT_USE_ID REMIT_BANK_ACCT_USE_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BB.BANK_NAME REMIT_BANK_NAME,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BB.BRANCH_PARTY_ID REMITTANCE_BANK_BRANCH_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BB.BANK_BRANCH_NAME REMIT_BANK_BRANCH,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CBA.CURRENCY_CODE REMIT_BANK_CURRENCY,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.FACTOR_DISCOUNT_AMOUNT FACTOR_DISCOUNT_AMOUNT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PS.DUE_DATE MATURITY_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ARPT_SQL_FUNC_UTIL.get_lookup_meaning(&#39;RECEIPT_CREATION_STATUS&#39;,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.STATUS) STATE_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.STATUS STATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.GL_POSTED_DATE POSTED_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_TRX.NAME ACTIVITY,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_TRX.TAX_CODE_SOURCE TAX_CODE_SOURCE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.GL_POSTED_DATE GL_POSTED_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_CURRENT.POSTING_CONTROL_ID POSTING_CONTROL_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_FIRST_POSTED.GL_DATE GL_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REVERSAL_DATE REVERSAL_DATE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(CR.REVERSAL_CATEGORY, NULL, NULL, L_REV_CAT.MEANING) REVERSAL_CATEGORY_DSP,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REVERSAL_CATEGORY REVERSAL_CATEGORY,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(CR.REVERSAL_CATEGORY, NULL, NULL, L_REV_CAT.DESCRIPTION) CATEGORY_DESCRIPTION,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REVERSAL_COMMENTS REVERSAL_COMMENTS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(CR.REVERSAL_REASON_CODE, NULL, NULL, L_REV_REASON.MEANING) REVERSAL_REASON,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR.REVERSAL_REASON_CODE REVERSAL_REASON_CODE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECODE(CR.REVERSAL_REASON_CODE, NULL, NULL, L_REV_REASON.DESCRIPTION) REVERSAL_REASON_DESCRIPTION,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REM_BAT.NAME REMIT_BATCH,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REM_BAT.BATCH_ID REMIT_BATCH_ID,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NVL(CR.OVERRIDE_REMIT_ACCOUNT_FLAG, &#39;Y&#39;) OVERRIDE_REMIT_BANK,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NVL(- (PS.AMOUNT_APPLIED), 0) APPLIED_AMOUNT\n<\/p>\n<p>\n\t&nbsp; FROM CE_BANK_ACCOUNTS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CBA,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CE_BANK_ACCT_USES_OU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REMIT_BANK,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZX_RATES_B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VAT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ZX_ACCOUNTS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ACCOUNTS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_CUST_ACCOUNTS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CUST,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_PARTIES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PARTY,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_RECEIPT_METHODS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_METHOD,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_RECEIPT_CLASSES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RC,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_CUST_SITE_USES_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SITE_USES,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_LOOKUPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_NOTE_STATUS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_LOOKUPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L_REV_CAT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_LOOKUPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L_REV_REASON,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_LOOKUPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; L_REF_TYPE,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; GL_DAILY_CONVERSION_TYPES&nbsp;&nbsp; GL_DCT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_BATCHES_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REM_BAT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_RECEIVABLES_TRX_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REC_TRX,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_DISTRIBUTION_SETS_ALL&nbsp;&nbsp;&nbsp; DIST_SET,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_PAYMENT_SCHEDULES_ALL&nbsp;&nbsp;&nbsp; PS,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_CASH_RECEIPT_HISTORY_ALL CRH_CURRENT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_BATCHES_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BAT,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_BATCHES_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BAT_BR,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_CASH_RECEIPTS_ALL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CR,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_PARTIES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NotesBranchParty,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_PARTIES&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NotesBankParty,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HZ_RELATIONSHIPS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NotesBRRel,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CE_BANK_BRANCHES_V&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BB,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IBY_EXT_BANK_ACCOUNTS_V&nbsp;&nbsp;&nbsp;&nbsp; EBA<br \/>\n\t&nbsp;WHERE CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CUST.PARTY_ID = PARTY.PARTY_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CRH_NOTE_STATUS.LOOKUP_TYPE(+) = &#39;AR_NOTE_STATUS&#39;<br \/>\n\t&nbsp;&nbsp; AND CRH_NOTE_STATUS.LOOKUP_CODE(+) = CRH_CURRENT.NOTE_STATUS<br \/>\n\t&nbsp;&nbsp; AND REMIT_BANK.BANK_ACCT_USE_ID(+) = CR.REMIT_BANK_ACCT_USE_ID<br \/>\n\t&nbsp;&nbsp; AND REMIT_BANK.ORG_ID(+) = CR.ORG_ID<br \/>\n\t&nbsp;&nbsp; AND VAT.TAX_RATE_ID(+) = CR.VAT_TAX_ID<br \/>\n\t&nbsp;&nbsp; AND ACCOUNTS.TAX_ACCOUNT_ENTITY_ID(+) = CR.VAT_TAX_ID<br \/>\n\t&nbsp;&nbsp; AND accounts.tax_account_entity_code(+) = &#39;RATES&#39;<br \/>\n\t&nbsp;&nbsp; AND CR.RECEIPT_METHOD_ID = REC_METHOD.RECEIPT_METHOD_ID<br \/>\n\t&nbsp;&nbsp; AND REC_METHOD.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID<br \/>\n\t&nbsp;&nbsp; AND CR.CUSTOMER_SITE_USE_ID = SITE_USES.SITE_USE_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CR.ORG_ID = SITE_USES.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CR.RECEIVABLES_TRX_ID = REC_TRX.RECEIVABLES_TRX_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CR.ORG_ID = REC_TRX.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CR.DISTRIBUTION_SET_ID = DIST_SET.DISTRIBUTION_SET_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CR.ORG_ID = DIST_SET.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND L_REV_CAT.LOOKUP_TYPE(+) = &#39;REVERSAL_CATEGORY_TYPE&#39;<br \/>\n\t&nbsp;&nbsp; AND L_REV_CAT.LOOKUP_CODE(+) = CR.REVERSAL_CATEGORY<br \/>\n\t&nbsp;&nbsp; AND L_REV_REASON.LOOKUP_TYPE(+) = &#39;CKAJST_REASON&#39;<br \/>\n\t&nbsp;&nbsp; AND L_REV_REASON.LOOKUP_CODE(+) = CR.REVERSAL_REASON_CODE<br \/>\n\t&nbsp;&nbsp; AND L_REF_TYPE.LOOKUP_CODE(+) = CR.REFERENCE_TYPE<br \/>\n\t&nbsp;&nbsp; AND L_REF_TYPE.LOOKUP_TYPE(+) = &#39;CB_REFERENCE_TYPE&#39;<br \/>\n\t&nbsp;&nbsp; AND GL_DCT.CONVERSION_TYPE(+) = CR.EXCHANGE_RATE_TYPE<br \/>\n\t&nbsp;&nbsp; AND CRH_REM.CASH_RECEIPT_ID(+) = CR.CASH_RECEIPT_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_REM.ORG_ID(+) = CR.ORG_ID<br \/>\n\t&nbsp;&nbsp; AND NOT EXISTS<br \/>\n\t&nbsp;(SELECT \/*+ INDEX(CRH3 AR_CASH_RECEIPT_HISTORY_N1) *\/<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CASH_RECEIPT_HISTORY_ID<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM AR_CASH_RECEIPT_HISTORY_ALL CRH3<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE CRH3.STATUS = &#39;REMITTED&#39;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND CRH3.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND CRH3.CASH_RECEIPT_HISTORY_ID &lt;<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CRH_REM.CASH_RECEIPT_HISTORY_ID)<br \/>\n\t&nbsp;&nbsp; AND CRH_REM.STATUS(+) = &#39;REMITTED&#39;<br \/>\n\t&nbsp;&nbsp; AND CRH_REM.BATCH_ID = REM_BAT.BATCH_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CRH_REM.ORG_ID = REM_BAT.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND REM_BAT.TYPE(+) = &#39;REMITTANCE&#39;<br \/>\n\t&nbsp;&nbsp; AND PS.CASH_RECEIPT_ID(+) = CR.CASH_RECEIPT_ID<br \/>\n\t&nbsp;&nbsp; AND PS.ORG_ID(+) = CR.ORG_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_CURRENT.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_CURRENT.ORG_ID = CR.ORG_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_CURRENT.CURRENT_RECORD_FLAG = NVL(&#39;Y&#39;, CR.RECEIPT_NUMBER)<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.BATCH_ID = BAT.BATCH_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.ORG_ID = BAT.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND BAT.TYPE(+) = &#39;MANUAL&#39;<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.CASH_RECEIPT_ID(+) = CR.CASH_RECEIPT_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.ORG_ID(+) = CR.ORG_ID<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.FIRST_POSTED_RECORD_FLAG(+) = &#39;Y&#39;<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.BATCH_ID = BAT_BR.BATCH_ID(+)<br \/>\n\t&nbsp;&nbsp; AND CRH_FIRST_POSTED.ORG_ID = BAT_BR.ORG_ID(+)<br \/>\n\t&nbsp;&nbsp; AND BAT_BR.TYPE(+) = &#39;BR&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBranchParty.party_id(+) = CR.issuer_bank_branch_id<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.object_id = NotesBankParty.party_id(+)<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.subject_id(+) = NotesBranchParty.party_id<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.relationship_type(+) = &#39;BANK_AND_BRANCH&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.relationship_code(+) = &#39;BRANCH_OF&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.subject_table_name(+) = &#39;HZ_PARTIES&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.subject_type(+) = &#39;ORGANIZATION&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.object_table_name(+) = &#39;HZ_PARTIES&#39;<br \/>\n\t&nbsp;&nbsp; AND NotesBRRel.object_type(+) = &#39;ORGANIZATION&#39;<br \/>\n\t&nbsp;&nbsp; AND remit_bank.bank_account_id = CBA.bank_account_id(+)<br \/>\n\t&nbsp;&nbsp; AND BB.BRANCH_PARTY_ID(+) = CBA.BANK_BRANCH_ID<br \/>\n\t&nbsp;&nbsp; AND EBA.ext_bank_account_id(+) = CR.CUSTOMER_BANK_ACCOUNT_ID<br \/>\n\t&nbsp;&nbsp; AND cr.org_id = accounts.internal_organization_id(+)<br \/>\n\t&nbsp;&nbsp; and CR.RECEIPT_NUMBER = &#39;FL3959195-6&#39;;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT CR.CASH_RECEIPT_ID CASH_RECEIPT_ID, &nbsp;&nbsp; &hellip; <a href=\"https:\/\/www.llku.com\/?p=946\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u5e94\u6536\u6536\u6b3e\u754c\u9762\u4fe1\u606f\u83b7\u53d6<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[30],"tags":[145],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/946"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=946"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/946\/revisions"}],"predecessor-version":[{"id":949,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/946\/revisions\/949"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}