ECC Receivables, Payment Process, SQL3

Description
Categories: Enterprise Command Center
Columns: Ledger Currency Code, Ledger, Receipt Method, Remittance Batch Number, Media Reference, Bank Name, Bank Branch, Bank Account Number, Remittance Batch Date, Remittance Actual Count ...
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(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