ECC Receivables, Payment Process, SQL2

Description
Categories: Enterprise Command Center
Columns: Ledger Currency Code, Ledger, Receipt Method, Receipt Batch Number, Receipt Batch Source, Receipt Batch Date, Receipt Batch Currency Code, Recipt Control Count, Recipt Actual Count, Org Id ...
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
select
x.*
from
(
select * from (SELECT /*+ leading(rcptbatch_v.temp.process_t) full(rcptbatch_v.temp.process_t) no_push_pred(rcptbatch_v.temp) */ rcptbatch_v.OPERATING_UNIT
, rcptbatch_v.LEDGER_CURRENCY
, rcptbatch_v.LEDGER_CURRENCY_CODE
, rcptbatch_v.LEDGER
, rcptbatch_v.RECEIPT_METHOD
, rcptbatch_v.RECEIPT_BATCH_NUMBER
, rcptbatch_v.RECEIPT_BATCH_SOURCE
, rcptbatch_v.RECEIPT_BATCH_DATE
, rcptbatch_v.RECEIPT_BATCH_STATUS
, rcptbatch_v.RECEIPT_BATCH_PROCESS_STATUS as RCPT_BATCH_PROC_STAT
, rcptbatch_v.RECEIPT_BATCH_TYPE
, rcptbatch_v.RECEIPT_BATCH_CURRENCY
, rcptbatch_v.RECEIPT_BATCH_CURRENCY_CODE
, rcptbatch_v.RECIPT_CONTROL_COUNT
, rcptbatch_v.RECIPT_ACTUAL_COUNT
, rcptbatch_v.ORG_ID
, rcptbatch_v.RECEIPT_BATCH_ID
, rcptbatch_v.ECC_SPEC_ID
, rcptbatch_v.ECC_LAST_UPDATE_DATE
, rcptbatch_v.RECORD_TYPE
, rcptbatch_v.LANGUAGE
  FROM ar_ecc_receipt_batch_v rcptbatch_v
  WHERE rcptbatch_v.language in ('US'))
   PIVOT(max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(RECEIPT_BATCH_CURRENCY) as RECEIPT_BATCH_CURRENCY,
   max(RECEIPT_BATCH_STATUS) as RECEIPT_BATCH_STATUS,max(RCPT_BATCH_PROC_STAT) as RCPT_BATCH_PROC_STAT,
   max(RECEIPT_BATCH_TYPE) as RECEIPT_BATCH_TYPE
   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