ECC Receivables, Payment Process, SQL3

➜ 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
Run ECC Receivables, Payment Process, SQL3 and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from (SELECT /*+ leading(rmtbatch_v.temp.process_t) full(rmtbatch_v.temp.process_t)no_push_pred(rmtbatch_v.temp) */  rmtbatch_v.OPERATING_UNIT
, rmtbatch_v.LEDGER_CURRENCY
, rmtbatch_v.LEDGER_CURRENCY_CODE
, rmtbatch_v.LEDGER
, rmtbatch_v.RECEIPT_METHOD
, rmtbatch_v.REMITTANCE_BATCH_NUMBER
, rmtbatch_v.REMITTANCE_METHOD
, rmtbatch_v.REMIT_BATCH_PROCESS_STATUS
, rmtbatch_v.MEDIA_REFERENCE
, rmtbatch_v.BANK_NAME
, rmtbatch_v.BANK_BRANCH
, rmtbatch_v.BANK_ACCOUNT_NUMBER
, rmtbatch_v.REMITTANCE_BATCH_DATE
, rmtbatch_v.REMITTANCE_ACTUAL_COUNT
, rmtbatch_v.REMITTANCE_CONTROL_COUNT
, rmtbatch_v.REMITTANCE_BATCH_CURRENCY
, rmtbatch_v.REMITTANCE_BATCH_CURRENCY_CODE
, rmtbatch_v.REMITTANCE_BATCH_ID
, rmtbatch_v.ORG_ID
, rmtbatch_v.ECC_SPEC_ID
, rmtbatch_v.ECC_LAST_UPDATE_DATE
, rmtbatch_v.RECORD_TYPE
, rmtbatch_v.LANGUAGE
  FROM ar_ecc_remittance_batch_v rmtbatch_v
  WHERE rmtbatch_v.language in ('US'))
   PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(REMITTANCE_METHOD) as REMITTANCE_METHOD,
   max(REMIT_BATCH_PROCESS_STATUS) as REMIT_BATCH_PROCESS_STATUS, max(REMITTANCE_BATCH_CURRENCY) as REMITTANCE_BATCH_CURRENCY
   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
AR Bills Receivable Remittance Batch Management AR Miscellaneous Receipts AR Receipt Register AR Receipts Awaiting Remittance CE General Ledger Reconciliation CE Cleared Transactions AR Remittance Batch Management ECC Receivables, Payment Process, SQL2 ECC Receivables, Billing Process, SQL1
Blitz Report™

Blitz Report™ provides multiple benefits: