ECC Lease Contracts, Lease Invoice Lines
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Line Number, Contract Number, Amount Due Original, Amount Paid, Amount Applied, Amount Credited, Tax Amount, Balance, Invoice Number ...
Columns: Ecc Spec Id, Line Number, Contract Number, Amount Due Original, Amount Paid, Amount Applied, Amount Credited, Tax Amount, Balance, Invoice Number ...
Imported from Enterprise Command Center
Dataset Key: okl-ar-trx-lines
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
Dataset Key: okl-ar-trx-lines
Query Procedure: OKL_AR_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure:
select x.* from ( SELECT * from (SELECT /*+cardinality(trxl_v.trx 10) */ trxl_v.* FROM okl_ari_ecc_trxl_v trxl_v, okl_ecc_trx_process_t trx_t WHERE trxl_v.payment_schedule_id = trx_t.payment_schedule_id AND trx_t.incremental_flag = 'N' AND language in ('US') ) PIVOT (max(STREAM_TYPE) as STREAM_TYPE, max(STREAM_PURPOSE_MEANING) as STREAM_PURPOSE_MEANING for LANGUAGE in ('US' "US")) ) x where 2=2 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Sold From Org. |
|
LOV |