ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470EE51A9E05362FB09050512 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 Y OKL OKLCONTVIEWSNAPSHOT AR OKL لقطة عرض العقد Imported from BI Publisher Application: إدارة الإيجار Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: D OKL Vertragsansichts-Snapshot Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: E OKL Instantánea de Consulta de Contrato Imported from BI Publisher Application: Leasing and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: F OKL Cliché de la vue du contrat Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: I OKL Istantanea visualizzazione contratto Imported from BI Publisher Application: Leasing and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: JA OKL 契約ビュー・スナップショット Imported from BI Publisher Application: リースおよびファイナンス管理 Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: KO OKL 계약 조회 스냅샷 Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: PTB OKL Instantâneo de Exibição do Contrato Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: RU OKL Снимок представления контракта Imported from BI Publisher Application: Управление лизингом и финансами Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: S OKL Kontraktsvy av ögonblicksbild Imported from BI Publisher Application: Hyres- och ekonomihantering Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: TR OKL Sözleşme Görünümü Kesiti Imported from BI Publisher Application: Kiralama ve Finans Yönetimi Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: US OKL Contract View Snapshot Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: ZHS OKL 合同视图快照 Imported from BI Publisher Application: Oracle Lease and Finance Management Source: Short Name: OKLCONTVIEWSNAPSHOT DB package: BI Publisher :p_report_id