OKS Service Contracts Detail

➜ Back to Library
Description
Categories: BI Publisher
Application: Service Contracts
Source: Service Contracts Detail Report (XML)
Short Name: OKSCODET_XML
DB package: OKS_OKSCODET_XMLP_PKG

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
               SL.Dnz_Chr_Id SL_Dnz_Chr_Id
              ,SL.Id  SL_Id
              ,SL.Lse_Id SL_Lse_Id
              ,SL.Line_Number SL_Line_Number
              ,TO_NUMBER(SL.Line_Number) SL_Line_No
              ,SL.Start_Date SL_Start_Date
              ,SL.End_Date SL_End_Date
              ,CL.Line_Number CL_Line_Number
              ,TO_NUMBER(CL.Line_Number) CL_Line_No
              ,CL.Id CL_Id
              ,CL.Start_Date CL_Start_Date
              ,CL.End_Date CL_End_Date
              ,CL.Price_Negotiated
              ,ST.STE_Code CL_STE_Code
              ,ST.Meaning STS_Code
              ,SL.Price_Negotiated SL_Price_Negotiated,
                OKS_OKSCODET_XMLP_PKG.cf_service_levelformula(SL.Lse_Id, SL.Id) CF_Service_Level,
                OKS_OKSCODET_XMLP_PKG.cf_srv_price_roundformula(SL.Price_Negotiated, :CURRENCY_CODE) CF_Srv_Price_Round,
                OKS_OKSCODET_XMLP_PKG.cf_price_negotiated_roundformu(CL.Price_Negotiated, :CURRENCY_CODE) CF_Price_Negotiated_Round,
                OKS_OKSCODET_XMLP_PKG.cf_cancelled_valueformula(ST.STE_Code, CL.Price_Negotiated) CF_Cancelled_value,
                OKS_OKSCODET_XMLP_PKG.cf_total_valueformula(ST.STE_Code, CL.Price_Negotiated) CF_Total_value,
                OKS_OKSCODET_XMLP_PKG.cf_product_detailsformula(CL.Id) CF_Product_Details,
                OKS_OKSCODET_XMLP_PKG.CP_Prod_Name_p CP_Prod_Name,
                OKS_OKSCODET_XMLP_PKG.CP_CSI_p CP_CSI,
                OKS_OKSCODET_XMLP_PKG.CP_Prod_Serial_No_p CP_Prod_Serial_No,
                OKS_OKSCODET_XMLP_PKG.CP_Prod_Ref_No_p CP_Prod_Ref_No,
                OKS_OKSCODET_XMLP_PKG.CP_Prod_Qty_p CP_Prod_Qty,
                OKS_OKSCODET_XMLP_PKG.CP_Num_Of_Users_p CP_Num_Of_Users,
                OKS_OKSCODET_XMLP_PKG.CP_Pricing_Lic_Lvl_p CP_Pricing_Lic_Lvl,
                OKS_OKSCODET_XMLP_PKG.CP_Lic_Lvl_p CP_Lic_Lvl
            FROM
               OKC_K_Lines_B SL
              ,OKC_K_Lines_B CL
              ,OKC_STATUSES_V ST
            WHERE  SL.Lse_ID IN  (14, 19)
                 AND  SL.Cle_Id IS NULL
                 AND  CL.Cle_Id = SL.Id
                 AND  CL.Lse_Id IN (18, 25)
                 AND  ST.CODE = CL.STS_CODE
             and SL.Dnz_Chr_Id = :Id10
            ORDER By
            SL_Line_No, SL_Line_Number, SL_Start_Date, SL_End_Date, SL_Dnz_Chr_Id,
            SL_Id, SL_Lse_Id, CL_STE_Code, STS_Code, CL_Line_No, CL_Line_Number,
            CL_Start_Date, CL_End_Date,
            TO_NUMBER(SL.Line_Number)
            ,TO_NUMBER(CL.Line_Number)
Parameter Name SQL text Validation
Contract Group 
 
 LOV Oracle
Contract # 
 
 LOV Oracle
Customer 
 
 LOV Oracle
Status Type 
 
 LOV Oracle
Status Code 
 
 LOV Oracle
Start Date From 
 
 Date
Start Date To 
 
 Date
End Date From 
 
 Date
End Date To 
 
 Date
Operating Unit 
 
 LOV Oracle
Download
 
Related Blitz Reports
OKS Service Contracts Billing Schedule OKC Contract Lines Summary OKL Termination Quotes OKS Service Contracts Billing History OKL Lease Property Tax ECC Project Manufacturing Genealogy & Trace, Project Contracts PON Solicitation data template OKL Billing Inquiry Data OKL Equipment Exchange Request
Blitz Report™

Blitz Report™ provides multiple benefits: