ECC Receivables, Payment Process, SQL3

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
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