ECC Receivables, Payment History, SQL2
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
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 |
|
LOV |