ECC Receivables, Payment Process, SQL2

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