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 ...
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:
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 |
|
LOV |