ECC Lease Contracts, Lease Unapplied Cash

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Txn Type Code, Ledger, Ledger Currency Code, Account Number, Trx Date, Original Amount, Amount Due Remaining, Applied Amount, Document Number ...
Imported from Enterprise Command Center
Dataset Key: okl-unapp-cash
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
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