OKL Contract View Snapshot

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
Blitz Report™