ECC Lease Contracts, Contract Details

➜ Back to Library
Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Description: Lease Contract Details
Dataset Key: okl_arcon_dtls
Query Procedure: okl_ecc_arcon_pkg.ecc_acct_recon_data_load
Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues
Run ECC Lease Contracts, Contract Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
SELECT * FROM
( SELECT spec_id ECC_SPEC_ID,
        contract_id,
        contract_number,
        event_id,
        code_combination_id,
        gl_account,
        accounted_dr,
        accounted_cr,
        gl_acct_description,
        flv.meaning TRX_NAME,
        nvl(flv.language,'US') language_code,
        ear.customer_name,
        ear.stream_code,
        ear.transaction_number,
        currency_code,
        booked_amount,
        ear.party_id,
        ear.trx_type_id,
        khr_sts.meaning contract_status,
        stream_type_purpose,
        stream_balance,
        org_id,
        ledger_name,
        conversion_rate_date,
        conversion_type,
        conversion_rate,
        entered_dr,
        entered_cr,
        ledger_currency,
        decode(fund_req_num,'0',null,fund_req_num) fund_req_num,
        decode(funded_amount,0,null,funded_amount) funded_amount,
        receipt_amt_applied
FROM    okl_ecc_acct_recon    ear,
        fnd_lookup_values flv
        ,okc_statuses_tl           khr_sts  --bug 30786225
WHERE   flv.lookup_code = ear.trx_name
AND     khr_sts.code = ear.contract_status
AND     flv.language= khr_sts.language
and    flv.lookup_type = 'OKL_TRANSACTION_TYPE_CLASS'
--and    nvl(trx_type_id,1) <>0
and    nvl(flv.language,'US') in('US')
and    ear.processing_status_flag ='N')
PIVOT  (MAX(TRX_NAME) AS TRX_NAME,
        MAX(CONTRACT_STATUS) AS CONTRACT_STATUS
FOR language_code 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
Download
 
Related Blitz Reports
ECC Lease Contracts, Lease Contract Quote Details ECC Lease Contracts, Lease Vendor Cash Flow OKL Termination Quotes GL Account Analysis ECC Lease Contracts, Revision History ECC Contract Lifecycle Management, Acquisitions ECC Contract Lifecycle Management, Solicitation Forms CAC Accounting Period Status ECC Receivables, AR Closing, SQL5
Blitz Report™

Blitz Report™ provides multiple benefits: