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) |