ECC Receivables, Payment Process, SQL1

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: ar-pmtproc
Query Procedure: AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: AR_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
x.*
from
(
SELECT * from (SELECT /*+ leading(rcpt_v.tmp.process_t) full(rcpt_v.tmp.process_t) */ rcpt_v.OPERATING_UNIT,
rcpt_v.LEDGER,rcpt_v.LEDGER_CURRENCY,rcpt_v.LEDGER_CURRENCY_CODE,rcpt_v.RECEIPT_METHOD,rcpt_v.ACCOUNT_NUMBER,
rcpt_v.CUSTOMER,rcpt_v.CUSTOMER_LOCATION,rcpt_v.RECEIPT_NUMBER,rcpt_v.RECEIPT_CURRENCY,rcpt_v.RECEIPT_CURRENCY_CODE,
rcpt_v.RECEIPT_AMOUNT,rcpt_v.RECEIPT_DATE,rcpt_v.UNAPPLIED_AMOUNT,rcpt_v.RECEIPT_STATUS_CODE,rcpt_v.RECEIPT_STATUS,
rcpt_v.RECEIPT_STATE_CODE,rcpt_v.RECEIPT_STATE,rcpt_v.RECEIPT_ACCOUNTED_AMOUNT,rcpt_v.UNAPPLIED_ACCOUNTED_AMOUNT,rcpt_v.ORG_ID,
rcpt_v.CASH_RECEIPT_ID,rcpt_v.ECC_SPEC_ID,rcpt_v.ECC_LAST_UPDATE_DATE,rcpt_v.RECORD_TYPE,rcpt_v.ATTRIBUTE_CATEGORY,rcpt_v.ATTRIBUTE1,
rcpt_v.ATTRIBUTE2,rcpt_v.ATTRIBUTE3,rcpt_v.ATTRIBUTE4,rcpt_v.ATTRIBUTE5,rcpt_v.ATTRIBUTE6,rcpt_v.ATTRIBUTE7,rcpt_v.ATTRIBUTE8,rcpt_v.ATTRIBUTE9,
rcpt_v.ATTRIBUTE10,rcpt_v.ATTRIBUTE11,rcpt_v.ATTRIBUTE12,rcpt_v.ATTRIBUTE13,rcpt_v.ATTRIBUTE14,rcpt_v.ATTRIBUTE15,rcpt_v.LANGUAGE
  FROM ar_ecc_receipt_v rcpt_v where rcpt_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, max(RECEIPT_STATE) as RECEIPT_STATE
          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, Payment Process, SQL2 ECC Receivables, Payment History, SQL2 ECC Lease Contracts, Lease Vendor Cash Summary ECC Receivables, Payment Process, SQL3 ECC G-Invoicing, Projects: G-Invoicing ECC Projects, Projects Costing: Transactions, SQL1 ECC Receivables, AR Closing, SQL3 ECC Receivables, AR Closing, SQL5 ECC Receivables, AR Closing, SQL4
Blitz Report™

Blitz Report™ provides multiple benefits: