OKL Contract View Snapshot

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLCONTVIEWSNAPSHOT
DB package:
Run OKL Contract View Snapshot and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT * FROM 
(
    SELECT  REPORT_STREAM_ID
           ,ASSET_NUMBER
           ,STREAM_TYPE
           ,STREAM_STATUS
           ,STREAM_TYPE_PURPOSE
           ,TO_CHAR (STREAM_DUE_DATE
                    ,'DD-MON-YYYY') STREAM_DUE_DATE
           ,STREAM_DUE_DATE STREAM_DUE_DATE1
           ,PURPOSE
           ,STREAM_AMOUNT
           ,BILLED
           ,ACCRUED
    FROM    OKL_ECC_CV_STREAMS
    WHERE   REPORT_ID = :P_REPORT_ID
    UNION ALL
    SELECT  NULL  REPORT_STREAM_ID
           ,ASSET_NUMBER
           ,STREAM_TYPE
           ,NULL  STREAM_STATUS
           ,NULL  STREAM_TYPE_PURPOSE
           ,NULL  STREAM_DUE_DATE
           ,NULL  STREAM_DUE_DATE1
           ,PURPOSE
           ,SUM(STREAM_AMOUNT)  STREAM_AMOUNT
           ,NULL  BILLED
           ,NULL  ACCRUED
    FROM    OKL_ECC_CV_STREAMS
    WHERE   REPORT_ID = :P_REPORT_ID
    GROUP BY ASSET_NUMBER
            ,STREAM_TYPE
            ,PURPOSE
)
ORDER BY 3,2,8,7
Download
Related Blitz Reports
ECC Lease Contracts, Streams ECC Lease Contracts, Payments ECC Lease Contracts, Contracts (1) OKL Contract NIV Compare ECC Lease Contracts, Service ECC Lease Contracts, Manual Rebooks ECC Lease Contracts, Fees ECC Lease Contracts, Assets OKL Termination Quotes
Blitz Report™

Blitz Report™ provides multiple benefits: