OKL Contract View Snapshot

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLCONTVIEWSNAPSHOT
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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