ECC Lease Contracts, Lease Receipts

Description
Categories: Enterprise Command Center
Columns: Ledger, Ledger Currency Code, Receipt Method, Account Number, Customer, Customer Location, Receipt Number, Receipt Currency Code, Receipt Amount, Receipt Date ...
Imported from Enterprise Command Center
Dataset Key: okl-cash
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
select
x.*
from
(
SELECT * from (SELECT rcpt_v.* ,
                                    trx_t.aging_bucket as receipt_aging
 
  FROM okl_ar_ecc_receipt_v rcpt_v, okl_ecc_process_t process_t ,
       okl_ecc_trx_process_t trx_t
 
 WHERE rcpt_v.cash_receipt_id = process_t.id
   AND rcpt_v.payment_schedule_id = trx_t.payment_schedule_id
   AND trx_t.incremental_flag = 'N'
 
   AND language in ('US')
   AND process_t.record_type = 'ARCASHRCPT')
   PIVOT (max(OPERATING_UNIT) as OPERATING_UNIT, max(LEDGER_CURRENCY) as LEDGER_CURRENCY, max(RECEIPT_CURRENCY) as RECEIPT_CURRENCY,
          max(period_name) as period_name,
          max(RECEIPT_STATUS) as RECEIPT_STATUS, max(RECEIPT_STATE) as RECEIPT_STATE
          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