ECC Receivables, Payment History, SQL2

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ar-history
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Receivables, Payment History, SQL2 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT /*+ leading(rcpt_hist_v.process_t) full(rcpt_hist_v.process_t) */
rcpt_hist_v.OPERATING_UNIT,rcpt_hist_v.LEDGER_CURRENCY,rcpt_hist_v.LEDGER_CURRENCY_CODE,rcpt_hist_v.LEDGER,rcpt_hist_v.CUSTOMER,
rcpt_hist_v.ACCOUNT_NUMBER,rcpt_hist_v.RECEIPT_NUMBER,rcpt_hist_v.RECEIPT_CURRENCY,rcpt_hist_v.RECEIPT_CURRENCY_CODE,rcpt_hist_v.RECEIPT_AMOUNT,
rcpt_hist_v.RECEIPT_DATE,rcpt_hist_v.APPLICATION_DATE,rcpt_hist_v.RECEIPT_CLASS,rcpt_hist_v.RECEIPT_METHOD,rcpt_hist_v.RECEIPT_STATUS,rcpt_hist_v.RECEIPT_STATUS_CODE,
rcpt_hist_v.ACCOUNTED_AMOUNT,rcpt_hist_v.TRANSACTION_NUMBER,rcpt_hist_v.ORG_ID,rcpt_hist_v.CASH_RECEIPT_ID,rcpt_hist_v.ECC_SPEC_ID,rcpt_hist_v.ECC_LAST_UPDATE_DATE,
rcpt_hist_v.RECORD_TYPE,rcpt_hist_v.ATTRIBUTE_CATEGORY,rcpt_hist_v.ATTRIBUTE1,rcpt_hist_v.ATTRIBUTE2,rcpt_hist_v.ATTRIBUTE3,rcpt_hist_v.ATTRIBUTE4,rcpt_hist_v.ATTRIBUTE5,
rcpt_hist_v.ATTRIBUTE6,rcpt_hist_v.ATTRIBUTE7,rcpt_hist_v.ATTRIBUTE8,rcpt_hist_v.ATTRIBUTE9,rcpt_hist_v.ATTRIBUTE10,rcpt_hist_v.ATTRIBUTE11,rcpt_hist_v.ATTRIBUTE12,
rcpt_hist_v.ATTRIBUTE13,rcpt_hist_v.ATTRIBUTE14,rcpt_hist_v.ATTRIBUTE15,rcpt_hist_v.LANGUAGE
  FROM ar_ecc_receipt_history_v rcpt_hist_v where rcpt_hist_v.language in ('US'))
   PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(RECEIPT_CURRENCY) as RECEIPT_CURRENCY,
   max(RECEIPT_STATUS) as RECEIPT_STATUS
   for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Operating Unit 
x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:operating_unit)
 LOV
Download
Related Blitz Reports
ECC Receivables, AR Closing, SQL4 ECC Receivables, AR Closing, SQL5 ECC Receivables, AR Closing, SQL3 ECC G-Invoicing, Projects: G-Invoicing AR Miscellaneous Receipts CE General Ledger Reconciliation CE Cleared Transactions ECC Receivables, Payment Process, SQL2 AR Bills Receivable Remittance Batch Management
Blitz Report™

Blitz Report™ provides multiple benefits: