OKL Contract View Snapshot
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLCONTVIEWSNAPSHOT
DB package:
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 |