OKS Service Contracts Detail

Description
Categories: BI Publisher, Service
Application: Service Contracts
Source: Service Contracts Detail Report (XML)
Short Name: OKSCODET_XML
DB package: OKS_OKSCODET_XMLP_PKG
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
Operating Unit
 
LOV Oracle
End Date To
 
Date
End Date From
 
Date
Start Date To
 
Date
Start Date From
 
Date
Status Code
 
LOV Oracle
Status Type
 
LOV Oracle
Customer
 
LOV Oracle
Contract #
 
LOV Oracle
Contract Group
 
LOV Oracle
Ask a question