ECC Lease Contracts, Lease Unapplied Cash

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: okl-unapp-cash
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Run ECC Lease Contracts, Lease Unapplied Cash and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * from (SELECT rcpt_v.*,trx_t.org_id org_id,
                                    trx_t.aging_bucket as receipt_aging  
  FROM OKL_ECC_OPEN_ITEMS_V rcpt_v, okl_ecc_process_t process_t,
       okl_ecc_trx_process_t trx_t
 
 WHERE rcpt_v.transaction_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(CUSTOMER) as CUSTOMER,
          max(TXN_TYPE) as TXN_TYPE,
          max(TRANSACTION_CURRENCY) as TRANSACTION_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