eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_K_LINES_B

Line 430: FROM Okc_K_Lines_B SVL

426: ,Get_End_Date_Time(SVL.End_Date) End_Date
427: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
428: ,KSL.Coverage_Id
429: ,KSL.Standard_Cov_YN
430: FROM Okc_K_Lines_B SVL
431: ,Oks_K_Lines_B KSL
432: WHERE SVL.Id = Cx_SVL_Id
433: AND SVL.Id = KSL.Cle_ID
434: AND SVL.Lse_Id IN (G_LINE_STYLE_SERVICE

Line 557: -- FROM Okc_K_Lines_B CVL

553: --SELECT CVL.Id
554: -- , CVL.Start_Date
555: -- , Get_End_Date_Time(CVL.End_Date) End_Date
556: -- , Get_End_Date_Time(CVL.Date_Terminated) Date_Terminated
557: -- FROM Okc_K_Lines_B CVL
558: -- WHERE CVL.Cle_id = Cx_SVL_Id
559: -- AND Lse_Id IN (G_LINE_STYLE_SRV_COVERAGE
560: -- ,G_LINE_STYLE_WAR_COVERAGE
561: -- ,G_LINE_STYLE_EWT_COVERAGE);

Line 568: -- FROM Okc_K_Lines_B CVL

564: --SELECT CVL.Id
565: -- , CVL.Start_Date
566: -- , Get_End_Date_Time(CVL.End_Date) End_Date
567: -- , Get_End_Date_Time(CVL.Date_Terminated) Date_Terminated
568: -- FROM Okc_K_Lines_B CVL
569: -- WHERE CVL.Id = Cx_COV_Id
570: -- AND Lse_Id IN (G_LINE_STYLE_SRV_COVERAGE
571: -- ,G_LINE_STYLE_WAR_COVERAGE
572: -- ,G_LINE_STYLE_EWT_COVERAGE);

Line 581: FROM Okc_K_Lines_B CVL

577: CURSOR Lx_Csr_CVL(Cx_CVL_Id IN Gx_OKS_Id) IS
578: SELECT CVL.Start_Date
579: ,Get_End_Date_Time(CVL.End_Date) End_Date
580: ,Get_End_Date_Time(CVL.Date_Terminated) Date_Terminated
581: FROM Okc_K_Lines_B CVL
582: WHERE CVL.Id = Cx_CVL_Id
583: AND Lse_Id IN (G_LINE_STYLE_SRV_COVERAGE
584: ,G_LINE_STYLE_WAR_COVERAGE
585: ,G_LINE_STYLE_EWT_COVERAGE);

Line 821: FROM Okc_K_Lines_B BPL

817: CURSOR Lx_Csr_BPL(Cx_BPL_Id IN Gx_OKS_Id) IS
818: SELECT BPL.Start_Date
819: ,Get_End_Date_Time(BPL.End_Date) End_Date
820: ,Get_End_Date_Time(BPL.Date_Terminated) Date_Terminated
821: FROM Okc_K_Lines_B BPL
822: WHERE BPL.Id = Cx_BPL_Id
823: AND BPL.Lse_Id IN (3,16,21);
824:
825: Lx_BPL_Id CONSTANT Gx_OKS_Id := P_BPL_Id;

Line 937: FROM Okc_K_Lines_B BPL,

933: SELECT BPL.Id
934: ,BPL.Start_Date
935: ,Get_End_Date_Time(BPL.End_Date) End_Date
936: ,Get_End_Date_Time(BPL.Date_Terminated) Date_Terminated
937: FROM Okc_K_Lines_B BPL,
938: Okc_K_Lines_B CVL
939: WHERE CVL.id = Cx_CVL_Id
940: AND BPL.Cle_Id = CVL.Id
941: AND EXISTS ( SELECT '*'

Line 938: Okc_K_Lines_B CVL

934: ,BPL.Start_Date
935: ,Get_End_Date_Time(BPL.End_Date) End_Date
936: ,Get_End_Date_Time(BPL.Date_Terminated) Date_Terminated
937: FROM Okc_K_Lines_B BPL,
938: Okc_K_Lines_B CVL
939: WHERE CVL.id = Cx_CVL_Id
940: AND BPL.Cle_Id = CVL.Id
941: AND EXISTS ( SELECT '*'
942: FROM Okc_K_Items ITM

Line 1530: FROM Okc_K_Lines_B RTL

1526: ,RTL.Start_Date
1527: ,Get_End_Date_Time(RTL.End_Date) End_Date
1528: ,Get_End_Date_Time(RTL.Date_Terminated) Date_Terminated
1529: ,OKSRTL.Work_Thru_YN Work_Through_YN
1530: FROM Okc_K_Lines_B RTL
1531: ,Okc_K_Lines_B BPL
1532: ,oks_k_lines_b OKSRTL
1533: ,oks_action_time_types ACT
1534: ,oks_action_times ACM

Line 1531: ,Okc_K_Lines_B BPL

1527: ,Get_End_Date_Time(RTL.End_Date) End_Date
1528: ,Get_End_Date_Time(RTL.Date_Terminated) Date_Terminated
1529: ,OKSRTL.Work_Thru_YN Work_Through_YN
1530: FROM Okc_K_Lines_B RTL
1531: ,Okc_K_Lines_B BPL
1532: ,oks_k_lines_b OKSRTL
1533: ,oks_action_time_types ACT
1534: ,oks_action_times ACM
1535: WHERE BPL.Id = Cx_BPL_Id

Line 3634: from okc_k_lines_b okclb,

3630: select oct.id,
3631: oct.timezone_id,
3632: oct.default_yn,
3633: okslb.APPLY_DEFAULT_TIMEZONE
3634: from okc_k_lines_b okclb,
3635: oks_k_lines_b okslb,
3636: oks_coverage_timezones oct
3637: where okclb.id = P_BPL_Id
3638: and okslb.cle_id = okclb.id

Line 4961: from okc_k_lines_b okclb,

4957: select oct.id,
4958: oct.timezone_id,
4959: oct.default_yn,
4960: okslb.APPLY_DEFAULT_TIMEZONE
4961: from okc_k_lines_b okclb,
4962: oks_k_lines_b okslb,
4963: oks_coverage_timezones oct
4964: where okclb.id = P_BPL_Id
4965: and okslb.cle_id = okclb.id

Line 5957: ,OKC_K_LINES_B LIN

5953: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5954: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5955: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5956: ,OKC_LINE_STYLES_V STL
5957: ,OKC_K_LINES_B LIN
5958: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5959: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5960: AND LIN.START_DATE IS NOT NULL
5961: AND LIN.END_DATE IS NOT NULL

Line 5984: ,OKC_K_LINES_B LIN

5980: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5981: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5982: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5983: ,OKC_LINE_STYLES_V STL
5984: ,OKC_K_LINES_B LIN
5985: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5986: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5987: LIN.START_DATE IS NOT NULL
5988: AND LIN.END_DATE IS NOT NULL

Line 6012: This is to avoid full table scan on okc_k_headers_all_b, okc_k_lines_b, oks_k_lines_b

6008: Li_TableIdx := 0;
6009:
6010: /* Added by Jvorugan for perf bug:4998337.
6011: If lx_cle_id is not null then only passing the value.
6012: This is to avoid full table scan on okc_k_headers_all_b, okc_k_lines_b, oks_k_lines_b
6013: */
6014:
6015: IF Lx_Cle_Id IS NULL
6016: THEN

Line 6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id

6029: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6030: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6031: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

Line 6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

6031: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6032: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

Line 6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6033: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6034: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6035: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6036: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6037: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6038: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6039: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6040: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6041: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id

6065: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6066: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6067: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

Line 6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

6067: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6068: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

Line 6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6069: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6070: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6071: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6072: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6073: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6074: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6075: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6076: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6077: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id

6102: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
6103: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
6104: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

Line 6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

6104: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
6105: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null

Line 6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id

6106: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
6107: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
6108: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
6109: Lx_Contract_Lines(Li_TableIdx).Modifier := Idx.discount_list; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_Discount(NULL,Idx.Id)); --oks_k_lines_b.discount_list
6110: Lx_Contract_Lines(Li_TableIdx).Price_List_Id := Idx.price_list_id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P')); --okc_k_lines_b.price_list_id
6111: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
6112: Lx_Contract_Lines(Li_TableIdx).Billing_Profile_Id := null; -- does not exist in 11.5.10 --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BillingProfile(NULL,Idx.Id)); --null
6113: Lx_Contract_Lines(Li_TableIdx).Billing_Frequency := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'F'),1,25); --null
6114: Lx_Contract_Lines(Li_TableIdx).Billing_Method := null; -- does not exist in 11.5.10 --SUBSTR(OKS_ENT_UTIL_PVT.Get_BillingSchedule(NULL,Idx.Id,'M'),1,3); --null

Line 6230: ,OKC_K_LINES_B LIN

6226: ,HDR.AUTHORING_ORG_ID ORG_ID
6227: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6228: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6229: ,OKC_LINE_STYLES_V STL
6230: ,OKC_K_LINES_B LIN
6231: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6232: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
6233: AND LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
6234: AND STL.ID = LIN.LSE_ID

Line 6250: ,OKC_K_LINES_B LIN

6246: ,HDR.AUTHORING_ORG_ID ORG_ID
6247: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
6248: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6249: ,OKC_LINE_STYLES_V STL
6250: ,OKC_K_LINES_B LIN
6251: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
6252: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
6253: LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
6254: AND STL.ID = LIN.LSE_ID

Line 6309: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition

6305: Li_TableIdx := 0;
6306:
6307: /* Modified by Jvorugan for perg bug:4998337.
6308: If lx_cle_id is not null, then only passing the value.
6309: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition
6310: */
6311:
6312: IF Lx_Cle_Id IS NULL
6313: THEN

Line 6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6330: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6331: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6332: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6333:
6334: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6335: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6336:
6337: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6338: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6393: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6394: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6395: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6396:
6397: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6398: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6399:
6400: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6401: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b

6456: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6457: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6458: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6459:
6460: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6461: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6462:
6463: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6464: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6961: ,OKC_K_Lines_B BPL

6957: ,con.resource_class
6958: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6959: ,OKC_Contacts CON
6960: ,OKC_K_Party_Roles_B ROL
6961: ,OKC_K_Lines_B BPL
6962: ,OKC_K_Lines_B SBL
6963: ,OKC_K_Lines_B COV
6964: ,okc_k_items cimbp
6965: WHERE SBL.Id = Cx_SBL_Id

Line 6962: ,OKC_K_Lines_B SBL

6958: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6959: ,OKC_Contacts CON
6960: ,OKC_K_Party_Roles_B ROL
6961: ,OKC_K_Lines_B BPL
6962: ,OKC_K_Lines_B SBL
6963: ,OKC_K_Lines_B COV
6964: ,okc_k_items cimbp
6965: WHERE SBL.Id = Cx_SBL_Id
6966: AND SBL.Lse_Id IN (1,14,19)

Line 6963: ,OKC_K_Lines_B COV

6959: ,OKC_Contacts CON
6960: ,OKC_K_Party_Roles_B ROL
6961: ,OKC_K_Lines_B BPL
6962: ,OKC_K_Lines_B SBL
6963: ,OKC_K_Lines_B COV
6964: ,okc_k_items cimbp
6965: WHERE SBL.Id = Cx_SBL_Id
6966: AND SBL.Lse_Id IN (1,14,19)
6967: and cov.cle_id = sbl.id

Line 6994: ,OKC_K_Lines_B BPL

6990: ,con.resource_class
6991: FROM OKS_Resource_Groups_V RSG
6992: ,OKC_Contacts CON
6993: ,OKC_K_Party_Roles_B ROL
6994: ,OKC_K_Lines_B BPL
6995: ,OKC_K_Lines_B SBL
6996: ,OKC_K_Lines_B COV
6997: ,okc_k_items cimbp
6998: WHERE SBL.Id = Cx_SBL_Id

Line 6995: ,OKC_K_Lines_B SBL

6991: FROM OKS_Resource_Groups_V RSG
6992: ,OKC_Contacts CON
6993: ,OKC_K_Party_Roles_B ROL
6994: ,OKC_K_Lines_B BPL
6995: ,OKC_K_Lines_B SBL
6996: ,OKC_K_Lines_B COV
6997: ,okc_k_items cimbp
6998: WHERE SBL.Id = Cx_SBL_Id
6999: AND SBL.Lse_Id IN (1,14,19)

Line 6996: ,OKC_K_Lines_B COV

6992: ,OKC_Contacts CON
6993: ,OKC_K_Party_Roles_B ROL
6994: ,OKC_K_Lines_B BPL
6995: ,OKC_K_Lines_B SBL
6996: ,OKC_K_Lines_B COV
6997: ,okc_k_items cimbp
6998: WHERE SBL.Id = Cx_SBL_Id
6999: AND SBL.Lse_Id IN (1,14,19)
7000: and cov.cle_id = sbl.id

Line 7039: ,OKC_K_Lines_B BPL

7035:
7036: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
7037: ,OKC_Contacts CON
7038: ,OKC_K_Party_Roles_B ROL
7039: ,OKC_K_Lines_B BPL
7040: ,okc_k_items cimbp
7041: ,oks_k_lines_b ksl
7042: WHERE ksl.cle_id = Cx_SBL_Id
7043: AND BPL.cle_id = ksl.Coverage_Id

Line 7071: ,OKC_K_Lines_B BPL

7067:
7068: FROM OKS_Resource_Groups_V RSG
7069: ,OKC_Contacts CON
7070: ,OKC_K_Party_Roles_B ROL
7071: ,OKC_K_Lines_B BPL
7072: ,okc_k_items cimbp
7073: ,oks_k_lines_b ksl
7074: WHERE ksl.cle_id = Cx_SBL_Id
7075: AND BPL.cle_id = ksl.Coverage_Id

Line 7523: FROM Okc_K_lines_B cle

7519:
7520:
7521: CURSOR Lx_Csr_dnz_Chr(Cx_Cle_Id IN Gx_OKS_Id) IS
7522: SELECT CLE.DNZ_CHR_ID CONTRACT_ID
7523: FROM Okc_K_lines_B cle
7524: WHERE cle.id = Cx_Cle_Id
7525: AND rownum = 1;
7526:
7527: -- for category 'SUPPLIER_CONTACT'

Line 9925: FROM Okc_K_Lines_B

9921: IS
9922:
9923: CURSOR Lx_Csr_Contracts(Cx_CovLvlLine_Id IN Gx_OKS_Id) IS
9924: SELECT Dnz_Chr_Id, Id
9925: FROM Okc_K_Lines_B
9926: WHERE Id = Cx_CovLvlLine_Id
9927: AND Lse_Id In (7,8,9,10,11,35,18,25);
9928:
9929: Lx_CovLvlLine_Id CONSTANT Gx_OKS_Id := P_CovLvlLine_Id;

Line 9993: FROM Okc_K_Lines_B

9989: IS
9990:
9991: CURSOR Lx_Csr_Contracts(Cx_SrvLine_Id IN Gx_OKS_Id) IS
9992: SELECT Dnz_Chr_Id, Id
9993: FROM Okc_K_Lines_B
9994: WHERE Id = Cx_SrvLine_Id
9995: AND Lse_Id In (1,14,19);
9996:
9997: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;

Line 10146: ,Okc_K_Lines_B SV

10142: ,Get_End_Date_Time(SV.End_Date) End_Date
10143: ,Get_End_Date_Time(SV.Date_Terminated) Date_Terminated
10144: FROM Okx_System_Items_V XI
10145: ,Okc_K_Items IT
10146: ,Okc_K_Lines_B SV
10147: WHERE SV.Id = Cx_SrvLine_Id
10148: AND SV.Lse_Id IN (1,14,19)
10149: AND IT.Cle_Id = SV.Id
10150: -- AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')

Line 10276: FROM Okc_K_Lines_B SVL

10272: ,KSL.Standard_COV_YN
10273: ,SVL.Start_Date
10274: ,Get_End_Date_Time(SVL.End_Date) End_Date
10275: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
10276: FROM Okc_K_Lines_B SVL
10277: ,Oks_K_Lines_B KSL
10278: ,Okc_K_Lines_V COV
10279: WHERE SVL.Id = Cx_SrvLine_Id
10280: AND SVL.Lse_Id in (1,14,19)

Line 10593: ,Okc_K_Lines_B CL

10589: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10590: ,Okc_Line_Styles_B SB
10591: ,Okc_Line_Styles_TL ST
10592: ,Okc_K_Items IT
10593: ,Okc_K_Lines_B CL
10594: WHERE CL.Id = NVL(Cx_Cle_Id, CL.Id)
10595: AND CL.Dnz_Chr_Id = Cx_Chr_Id
10596: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
10597: AND IT.Cle_Id = CL.Id

Line 10638: ,Okc_K_Lines_B CL

10634: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10635: ,Okc_Line_Styles_B SB
10636: ,Okc_Line_Styles_TL ST
10637: ,Okc_K_Items IT
10638: ,Okc_K_Lines_B CL
10639: WHERE CL.Id = NVL(Cx_Cle_Id, CL.Id)
10640: AND CL.Dnz_Chr_Id = Cx_Chr_Id
10641: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
10642: AND IT.Cle_Id = CL.Id

Line 11519: ,Okc_K_Lines_B SV

11515: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11516: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11517: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11518: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11519: ,Okc_K_Lines_B SV
11520: ,Okc_K_Lines_B CL
11521: WHERE HD.Id = Cx_Chr_Id
11522: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11523: AND HD.Id > -1

Line 11520: ,Okc_K_Lines_B CL

11516: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11517: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11518: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11519: ,Okc_K_Lines_B SV
11520: ,Okc_K_Lines_B CL
11521: WHERE HD.Id = Cx_Chr_Id
11522: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11523: AND HD.Id > -1
11524: AND HD.Template_YN <> 'Y'

Line 11536: ,Okc_K_Lines_B BPL

11532: AND (Cx_BP_Id IS NULL
11533: OR
11534: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11535: FROM Okc_K_Items ITM
11536: ,Okc_K_Lines_B BPL
11537: ,Oks_K_Lines_B KSL
11538: WHERE KSL.Cle_Id = SV.Id
11539: AND BPL.Cle_Id = KSL.Coverage_ID
11540: AND ITM.Cle_Id = BPL.Id

Line 11568: ,Okc_K_Lines_B SV

11564: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11565: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11566: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11567: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11568: ,Okc_K_Lines_B SV
11569: ,Okc_K_Lines_B CL
11570: WHERE HD.Id = Cx_Chr_Id
11571: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11572: AND HD.Id > -1

Line 11569: ,Okc_K_Lines_B CL

11565: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11566: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11567: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11568: ,Okc_K_Lines_B SV
11569: ,Okc_K_Lines_B CL
11570: WHERE HD.Id = Cx_Chr_Id
11571: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11572: AND HD.Id > -1
11573: AND HD.Template_YN <> 'Y'

Line 11585: ,Okc_K_Lines_B BPL

11581: AND (Cx_BP_Id IS NULL
11582: OR
11583: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11584: FROM Okc_K_Items ITM
11585: ,Okc_K_Lines_B BPL
11586: ,Oks_K_Lines_B KSL
11587: WHERE KSL.Cle_Id = SV.Id
11588: AND BPL.Cle_Id = KSL.Coverage_ID
11589: AND ITM.Cle_Id = BPL.Id

Line 11600: -- ,Okc_K_Lines_B BPL

11596: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11597: --
11598: -- EXISTS (SELECT '*'
11599: -- FROM Okc_K_Items ITM
11600: -- ,Okc_K_Lines_B BPL
11601: -- ,Okc_K_Lines_B CV
11602: -- WHERE CV.Cle_Id = SV.Id
11603: -- AND CV.Lse_Id IN (2,15,20)
11604: -- AND BPL.Cle_Id = CV.Id

Line 11601: -- ,Okc_K_Lines_B CV

11597: --
11598: -- EXISTS (SELECT '*'
11599: -- FROM Okc_K_Items ITM
11600: -- ,Okc_K_Lines_B BPL
11601: -- ,Okc_K_Lines_B CV
11602: -- WHERE CV.Cle_Id = SV.Id
11603: -- AND CV.Lse_Id IN (2,15,20)
11604: -- AND BPL.Cle_Id = CV.Id
11605: -- AND ITM.Cle_Id = BPL.Id

Line 11638: ,Okc_K_Lines_B SV

11634: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11635: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11636: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11637: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11638: ,Okc_K_Lines_B SV
11639: ,Okc_K_Lines_B CL
11640: WHERE HD.Id = Cx_Chr_Id
11641: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11642: AND HD.Id > -1

Line 11639: ,Okc_K_Lines_B CL

11635: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11636: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11637: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11638: ,Okc_K_Lines_B SV
11639: ,Okc_K_Lines_B CL
11640: WHERE HD.Id = Cx_Chr_Id
11641: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11642: AND HD.Id > -1
11643: AND HD.Template_YN <> 'Y'

Line 11655: ,Okc_K_Lines_B BPL

11651: AND (Cx_BP_Id IS NULL
11652: OR
11653: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11654: FROM Okc_K_Items ITM
11655: ,Okc_K_Lines_B BPL
11656: ,Oks_K_Lines_B KSL
11657: WHERE KSL.Cle_Id = SV.Id
11658: AND BPL.Cle_Id = KSL.Coverage_ID
11659: AND ITM.Cle_Id = BPL.Id

Line 11687: ,Okc_K_Lines_B SV

11683: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11684: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11685: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11686: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11687: ,Okc_K_Lines_B SV
11688: ,Okc_K_Lines_B CL
11689: WHERE HD.Id = Cx_Chr_Id
11690: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') -------Modified condition for ER9681794
11691: AND HD.Id > -1

Line 11688: ,Okc_K_Lines_B CL

11684: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11685: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11686: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11687: ,Okc_K_Lines_B SV
11688: ,Okc_K_Lines_B CL
11689: WHERE HD.Id = Cx_Chr_Id
11690: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') -------Modified condition for ER9681794
11691: AND HD.Id > -1
11692: AND HD.Template_YN <> 'Y'

Line 11704: ,Okc_K_Lines_B BPL

11700: AND (Cx_BP_Id IS NULL
11701: OR
11702: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11703: FROM Okc_K_Items ITM
11704: ,Okc_K_Lines_B BPL
11705: ,Oks_K_Lines_B KSL
11706: WHERE KSL.Cle_Id = SV.Id
11707: AND BPL.Cle_Id = KSL.Coverage_ID
11708: AND ITM.Cle_Id = BPL.Id

Line 11719: -- ,Okc_K_Lines_B BPL

11715: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11716: --
11717: -- EXISTS (SELECT '*'
11718: -- FROM Okc_K_Items ITM
11719: -- ,Okc_K_Lines_B BPL
11720: -- ,Okc_K_Lines_B CV
11721: -- WHERE CV.Cle_Id = SV.Id
11722: -- AND CV.Lse_Id IN (2,15,20)
11723: -- AND BPL.Cle_Id = CV.Id

Line 11720: -- ,Okc_K_Lines_B CV

11716: --
11717: -- EXISTS (SELECT '*'
11718: -- FROM Okc_K_Items ITM
11719: -- ,Okc_K_Lines_B BPL
11720: -- ,Okc_K_Lines_B CV
11721: -- WHERE CV.Cle_Id = SV.Id
11722: -- AND CV.Lse_Id IN (2,15,20)
11723: -- AND BPL.Cle_Id = CV.Id
11724: -- AND ITM.Cle_Id = BPL.Id

Line 11757: ,Okc_K_Lines_B SV

11753: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11754: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11755: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11756: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11757: ,Okc_K_Lines_B SV
11758: ,Okc_K_Lines_B CL
11759: WHERE HD.Id = Cx_Chr_Id
11760: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11761: AND HD.Id > -1

Line 11758: ,Okc_K_Lines_B CL

11754: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11755: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11756: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11757: ,Okc_K_Lines_B SV
11758: ,Okc_K_Lines_B CL
11759: WHERE HD.Id = Cx_Chr_Id
11760: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11761: AND HD.Id > -1
11762: AND HD.Template_YN <> 'Y'

Line 11775: ,Okc_K_Lines_B BPL

11771: AND (Cx_BP_Id IS NULL
11772: OR
11773: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11774: FROM Okc_K_Items ITM
11775: ,Okc_K_Lines_B BPL
11776: ,Oks_K_Lines_B KSL
11777: WHERE KSL.Cle_Id = SV.Id
11778: AND BPL.Cle_Id = KSL.Coverage_ID
11779: AND ITM.Cle_Id = BPL.Id

Line 11807: ,Okc_K_Lines_B SV

11803: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11804: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11805: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11806: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11807: ,Okc_K_Lines_B SV
11808: ,Okc_K_Lines_B CL
11809: WHERE HD.Id = Cx_Chr_Id
11810: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11811: AND HD.Id > -1

Line 11808: ,Okc_K_Lines_B CL

11804: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11805: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11806: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11807: ,Okc_K_Lines_B SV
11808: ,Okc_K_Lines_B CL
11809: WHERE HD.Id = Cx_Chr_Id
11810: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11811: AND HD.Id > -1
11812: AND HD.Template_YN <> 'Y'

Line 11825: ,Okc_K_Lines_B BPL

11821: AND (Cx_BP_Id IS NULL
11822: OR
11823: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11824: FROM Okc_K_Items ITM
11825: ,Okc_K_Lines_B BPL
11826: ,Oks_K_Lines_B KSL
11827: WHERE KSL.Cle_Id = SV.Id
11828: AND BPL.Cle_Id = KSL.Coverage_ID
11829: AND ITM.Cle_Id = BPL.Id

Line 11840: -- ,Okc_K_Lines_B BPL

11836: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11837: --
11838: -- EXISTS (SELECT '*'
11839: -- FROM Okc_K_Items ITM
11840: -- ,Okc_K_Lines_B BPL
11841: -- ,Okc_K_Lines_B CV
11842: -- WHERE CV.Cle_Id = SV.Id
11843: -- AND CV.Lse_Id IN (2,15,20)
11844: -- AND BPL.Cle_Id = CV.Id

Line 11841: -- ,Okc_K_Lines_B CV

11837: --
11838: -- EXISTS (SELECT '*'
11839: -- FROM Okc_K_Items ITM
11840: -- ,Okc_K_Lines_B BPL
11841: -- ,Okc_K_Lines_B CV
11842: -- WHERE CV.Cle_Id = SV.Id
11843: -- AND CV.Lse_Id IN (2,15,20)
11844: -- AND BPL.Cle_Id = CV.Id
11845: -- AND ITM.Cle_Id = BPL.Id

Line 11877: ,Okc_K_Lines_B SV

11873: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11874: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11875: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11876: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11877: ,Okc_K_Lines_B SV
11878: ,Okc_K_Lines_B CL
11879: WHERE HD.Id = Cx_Chr_Id
11880: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11881: AND HD.Id > -1

Line 11878: ,Okc_K_Lines_B CL

11874: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11875: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11876: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11877: ,Okc_K_Lines_B SV
11878: ,Okc_K_Lines_B CL
11879: WHERE HD.Id = Cx_Chr_Id
11880: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11881: AND HD.Id > -1
11882: AND HD.Template_YN <> 'Y'

Line 11893: ,Okc_K_Lines_B BPL

11889: AND (Cx_BP_Id IS NULL
11890: OR
11891: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11892: FROM Okc_K_Items ITM
11893: ,Okc_K_Lines_B BPL
11894: ,Oks_K_Lines_B KSL
11895: WHERE KSL.Cle_Id = SV.Id
11896: AND BPL.Cle_Id = KSL.Coverage_ID
11897: AND ITM.Cle_Id = BPL.Id

Line 11926: ,Okc_K_Lines_B SV

11922: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11923: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11924: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11925: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11926: ,Okc_K_Lines_B SV
11927: ,Okc_K_Lines_B CL
11928: WHERE HD.Id = Cx_Chr_Id
11929: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11930: AND HD.Id > -1

Line 11927: ,Okc_K_Lines_B CL

11923: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11924: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11925: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11926: ,Okc_K_Lines_B SV
11927: ,Okc_K_Lines_B CL
11928: WHERE HD.Id = Cx_Chr_Id
11929: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11930: AND HD.Id > -1
11931: AND HD.Template_YN <> 'Y'

Line 11942: ,Okc_K_Lines_B BPL

11938: AND (Cx_BP_Id IS NULL
11939: OR
11940: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11941: FROM Okc_K_Items ITM
11942: ,Okc_K_Lines_B BPL
11943: ,Oks_K_Lines_B KSL
11944: WHERE KSL.Cle_Id = SV.Id
11945: AND BPL.Cle_Id = KSL.Coverage_ID
11946: AND ITM.Cle_Id = BPL.Id

Line 11958: -- ,Okc_K_Lines_B BPL

11954: --
11955: --
11956: -- EXISTS (SELECT '*'
11957: -- FROM Okc_K_Items ITM
11958: -- ,Okc_K_Lines_B BPL
11959: -- ,Okc_K_Lines_B CV
11960: -- WHERE CV.Cle_Id = SV.Id
11961: -- AND CV.Lse_Id IN (2,15,20)
11962: -- AND BPL.Cle_Id = CV.Id

Line 11959: -- ,Okc_K_Lines_B CV

11955: --
11956: -- EXISTS (SELECT '*'
11957: -- FROM Okc_K_Items ITM
11958: -- ,Okc_K_Lines_B BPL
11959: -- ,Okc_K_Lines_B CV
11960: -- WHERE CV.Cle_Id = SV.Id
11961: -- AND CV.Lse_Id IN (2,15,20)
11962: -- AND BPL.Cle_Id = CV.Id
11963: -- AND ITM.Cle_Id = BPL.Id

Line 13027: FROM Okc_K_lines_B

13023: IS
13024:
13025: CURSOR Lx_SrvLine(Cx_SrvLine_Id IN Gx_OKS_Id) IS
13026: SELECT Dnz_Chr_Id
13027: FROM Okc_K_lines_B
13028: WHERE Id = Cx_SrvLine_Id;
13029:
13030: Lx_Inp_Rec CONSTANT Inp_rec_getcont02 := P_Inp_Rec;
13031:

Line 13651: ,Okc_K_Lines_B SV

13647: OR
13648: HB.Id IN ( SELECT SV.Chr_Id
13649: FROM Okx_System_Items_V XI
13650: ,Okc_K_Items IT
13651: ,Okc_K_Lines_B SV
13652: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
13653: AND IT.Cle_Id = SV.Id
13654: AND IT.Object1_Id1 = NVL(Cv_Service_Item_Id,IT.Object1_Id1)
13655: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')

Line 13698: ,Okc_K_Lines_B SV

13694: OR
13695: HB.Id IN ( SELECT SV.Chr_Id
13696: FROM Okx_System_Items_V XI
13697: ,Okc_K_Items IT
13698: ,Okc_K_Lines_B SV
13699: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
13700: AND IT.Cle_Id = SV.Id
13701: AND IT.Object1_Id1 = NVL(Cv_Service_Item_Id,IT.Object1_Id1)
13702: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')

Line 14392: -- okc_k_lines_b cle,

14388: -- cvt.importance_level,
14389: -- okh.estimated_amount,
14390: -- okh.sts_code
14391: -- from OKC_K_HEADERS_ALL_B okh,
14392: -- okc_k_lines_b cle,
14393: -- okc_k_lines_b cle_cov,
14394: -- oks_k_lines_b okscle_cov,
14395: -- okc_k_lines_b cle_cvl,
14396: -- okc_k_items cim,

Line 14393: -- okc_k_lines_b cle_cov,

14389: -- okh.estimated_amount,
14390: -- okh.sts_code
14391: -- from OKC_K_HEADERS_ALL_B okh,
14392: -- okc_k_lines_b cle,
14393: -- okc_k_lines_b cle_cov,
14394: -- oks_k_lines_b okscle_cov,
14395: -- okc_k_lines_b cle_cvl,
14396: -- okc_k_items cim,
14397: -- okc_statuses_v sts,

Line 14395: -- okc_k_lines_b cle_cvl,

14391: -- from OKC_K_HEADERS_ALL_B okh,
14392: -- okc_k_lines_b cle,
14393: -- okc_k_lines_b cle_cov,
14394: -- oks_k_lines_b okscle_cov,
14395: -- okc_k_lines_b cle_cvl,
14396: -- okc_k_items cim,
14397: -- okc_statuses_v sts,
14398: -- oks_cov_types_v cvt
14399: -- where cle.chr_id = okh.id

Line 14425: okc_k_lines_b cle,

14421: cvt.importance_level,
14422: okh.estimated_amount,
14423: okh.sts_code
14424: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
14425: okc_k_lines_b cle,
14426: oks_k_lines_b cle_ksl,
14427: oks_k_lines_b okscle_cov,
14428: okc_k_lines_b cle_cvl,
14429: okc_k_items cim,

Line 14428: okc_k_lines_b cle_cvl,

14424: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
14425: okc_k_lines_b cle,
14426: oks_k_lines_b cle_ksl,
14427: oks_k_lines_b okscle_cov,
14428: okc_k_lines_b cle_cvl,
14429: okc_k_items cim,
14430: okc_statuses_v sts,
14431: oks_cov_types_v cvt
14432: where cle.chr_id = okh.id

Line 14458: -- okc_k_lines_b cle,

14454: -- covtyp.importance_level importance_level,
14455: -- okh.estimated_amount,
14456: -- okh.sts_code
14457: -- from OKC_K_HEADERS_ALL_B okh,
14458: -- okc_k_lines_b cle,
14459: -- okc_k_lines_b cle_cov,
14460: -- oks_k_lines_b okscle_cov,
14461: -- okc_k_lines_b cle_cvl,
14462: -- okc_k_items cim,

Line 14459: -- okc_k_lines_b cle_cov,

14455: -- okh.estimated_amount,
14456: -- okh.sts_code
14457: -- from OKC_K_HEADERS_ALL_B okh,
14458: -- okc_k_lines_b cle,
14459: -- okc_k_lines_b cle_cov,
14460: -- oks_k_lines_b okscle_cov,
14461: -- okc_k_lines_b cle_cvl,
14462: -- okc_k_items cim,
14463: -- okc_statuses_v sts,

Line 14461: -- okc_k_lines_b cle_cvl,

14457: -- from OKC_K_HEADERS_ALL_B okh,
14458: -- okc_k_lines_b cle,
14459: -- okc_k_lines_b cle_cov,
14460: -- oks_k_lines_b okscle_cov,
14461: -- okc_k_lines_b cle_cvl,
14462: -- okc_k_items cim,
14463: -- okc_statuses_v sts,
14464: -- oks_cov_types_v covtyp
14465: -- where cle.chr_id = okh.id

Line 14493: okc_k_lines_b cle,

14489: covtyp.importance_level importance_level,
14490: okh.estimated_amount,
14491: okh.sts_code
14492: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
14493: okc_k_lines_b cle,
14494: oks_k_lines_b cle_ksl,
14495: oks_k_lines_b okscle_cov,
14496: okc_k_lines_b cle_cvl,
14497: okc_k_items cim,

Line 14496: okc_k_lines_b cle_cvl,

14492: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
14493: okc_k_lines_b cle,
14494: oks_k_lines_b cle_ksl,
14495: oks_k_lines_b okscle_cov,
14496: okc_k_lines_b cle_cvl,
14497: okc_k_items cim,
14498: okc_statuses_v sts,
14499: oks_cov_types_v covtyp
14500: where cle.chr_id = okh.id

Line 15281: FROM OKC_K_LINES_B CVL,

15277: IS
15278:
15279: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
15280: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
15281: FROM OKC_K_LINES_B CVL,
15282: OKC_K_LINES_B BPL,
15283: OKC_K_PARTY_ROLES_B CPL,
15284: OKC_CONTACTS CON
15285: WHERE CVL.ID = p_coverage_id

Line 15282: OKC_K_LINES_B BPL,

15278:
15279: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
15280: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
15281: FROM OKC_K_LINES_B CVL,
15282: OKC_K_LINES_B BPL,
15283: OKC_K_PARTY_ROLES_B CPL,
15284: OKC_CONTACTS CON
15285: WHERE CVL.ID = p_coverage_id
15286: AND BPL.CLE_ID = CVL.ID

Line 16473: from okc_k_lines_b lines,

16469: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
16470: to_number(items.object1_id1) object1_id1,
16471: lines.dnz_chr_id,
16472: ksl.Standard_Cov_YN Standard_Cov_YN
16473: from okc_k_lines_b lines,
16474: oks_k_lines_b KSL,
16475: okc_k_lines_v lines2,
16476: okc_k_items items,
16477: cs_business_processes bp

Line 16837: ,Okc_K_Lines_B SV

16833: ,CAT.meaning HD_cat_meaning
16834: ,STS.meaning HD_sts_meaning
16835: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16836: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16837: ,Okc_K_Lines_B SV
16838: ,Okc_K_Lines_B CL
16839: ,okc_subclasses_v CAT
16840: ,okc_statuses_v STS
16841: WHERE HD.Id = Cx_Chr_Id

Line 16838: ,Okc_K_Lines_B CL

16834: ,STS.meaning HD_sts_meaning
16835: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16836: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16837: ,Okc_K_Lines_B SV
16838: ,Okc_K_Lines_B CL
16839: ,okc_subclasses_v CAT
16840: ,okc_statuses_v STS
16841: WHERE HD.Id = Cx_Chr_Id
16842: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 16913: ,Okc_K_Lines_B SV

16909: ,CAT.meaning HD_cat_meaning
16910: ,STS.meaning HD_sts_meaning
16911: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16912: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16913: ,Okc_K_Lines_B SV
16914: ,Okc_K_Lines_B CL
16915: ,okc_subclasses_v CAT
16916: ,okc_statuses_v STS
16917: WHERE HD.Id = Cx_Chr_Id

Line 16914: ,Okc_K_Lines_B CL

16910: ,STS.meaning HD_sts_meaning
16911: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16912: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16913: ,Okc_K_Lines_B SV
16914: ,Okc_K_Lines_B CL
16915: ,okc_subclasses_v CAT
16916: ,okc_statuses_v STS
16917: WHERE HD.Id = Cx_Chr_Id
16918: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794

Line 18398: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines

18394: k NUMBER;
18395:
18396: CURSOR CUR_GET_ORG_ID(l_contract_line_id IN NUMBER) IS
18397: SELECT hdr.AUTHORING_ORG_ID, hdr.INV_ORGANIZATION_ID
18398: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines
18399: WHERE lines.id = l_contract_line_id
18400: AND lines.chr_id = hdr.id ;
18401:
18402:

Line 18417: FROM OKC_K_LINES_B lines1,

18413: lines2.id bp_line_id,
18414: lines2.start_date start_date,
18415: lines2.end_date end_date,
18416: items.object1_id1
18417: FROM OKC_K_LINES_B lines1,
18418: OKC_K_LINES_B lines2,
18419: OKC_K_LINES_B lines3,
18420: OKC_K_ITEMS items
18421: WHERE lines1.id = p_contract_line_id

Line 18418: OKC_K_LINES_B lines2,

18414: lines2.start_date start_date,
18415: lines2.end_date end_date,
18416: items.object1_id1
18417: FROM OKC_K_LINES_B lines1,
18418: OKC_K_LINES_B lines2,
18419: OKC_K_LINES_B lines3,
18420: OKC_K_ITEMS items
18421: WHERE lines1.id = p_contract_line_id
18422: AND lines2.cle_id = lines1.id

Line 18419: OKC_K_LINES_B lines3,

18415: lines2.end_date end_date,
18416: items.object1_id1
18417: FROM OKC_K_LINES_B lines1,
18418: OKC_K_LINES_B lines2,
18419: OKC_K_LINES_B lines3,
18420: OKC_K_ITEMS items
18421: WHERE lines1.id = p_contract_line_id
18422: AND lines2.cle_id = lines1.id
18423: AND lines2.lse_id IN (2,15,20)

Line 18448: FROM OKC_K_LINES_B lines1,

18444: decode(KSL.Standard_Cov_YN,'Y', lines1.start_date,lines3.start_date) start_date
18445: ,decode(KSL.Standard_Cov_YN,'Y', lines1.end_date,lines3.end_date) end_date
18446: , lines3.id bpl_id
18447: , ksl.Standard_Cov_YN Standard_Cov_YN
18448: FROM OKC_K_LINES_B lines1,
18449: OKS_K_LINES_B KSL,
18450: OKC_K_LINES_B lines3,
18451: OKC_K_ITEMS items
18452: WHERE lines1.id = p_contract_line_id

Line 18450: OKC_K_LINES_B lines3,

18446: , lines3.id bpl_id
18447: , ksl.Standard_Cov_YN Standard_Cov_YN
18448: FROM OKC_K_LINES_B lines1,
18449: OKS_K_LINES_B KSL,
18450: OKC_K_LINES_B lines3,
18451: OKC_K_ITEMS items
18452: WHERE lines1.id = p_contract_line_id
18453: AND lines1.lse_id IN (1,14,19)
18454: and ksl.cle_id = lines1.id

Line 18577: FROM OKC_K_LINES_B lines1,

18573: CURSOR CUR_GET_COVLEVELS(l_contract_line_id IN NUMBER, l_object1_id1 IN VARCHAR2, l_object1_id2 IN VARCHAR2,
18574: l_object_code IN VARCHAR2) IS
18575:
18576: SELECT 'X'
18577: FROM OKC_K_LINES_B lines1,
18578: OKC_K_LINES_B lines2,
18579: OKC_K_ITEMS items
18580: WHERE lines1.id = l_contract_line_id
18581: AND lines2.cle_id = lines1.id

Line 18578: OKC_K_LINES_B lines2,

18574: l_object_code IN VARCHAR2) IS
18575:
18576: SELECT 'X'
18577: FROM OKC_K_LINES_B lines1,
18578: OKC_K_LINES_B lines2,
18579: OKC_K_ITEMS items
18580: WHERE lines1.id = l_contract_line_id
18581: AND lines2.cle_id = lines1.id
18582: AND lines2.dnz_chr_id = lines1.chr_id

Line 20500: Lv_Compare_Val1 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);

20496: Li_TableIdx BINARY_INTEGER;
20497: Li_TableIdx_Out BINARY_INTEGER;
20498: Li_TableIdx_In BINARY_INTEGER;
20499:
20500: Lv_Compare_Val1 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
20501: Lv_Compare_Val2 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
20502: K NUMBER;
20503: L_Found VARCHAR2(1);
20504:

Line 20501: Lv_Compare_Val2 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);

20497: Li_TableIdx_Out BINARY_INTEGER;
20498: Li_TableIdx_In BINARY_INTEGER;
20499:
20500: Lv_Compare_Val1 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
20501: Lv_Compare_Val2 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
20502: K NUMBER;
20503: L_Found VARCHAR2(1);
20504:
20505: BEGIN

Line 20718: OKC_K_LINES_B Sv,

20714: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
20715: Sv.Lse_Id Service_Lse_Id
20716: FROM OKC_K_HEADERS_ALL_B HD,
20717: OKC_K_HEADERS_TL HDT, /*bug 7412576 OKC_K_HEADERS_V HD,*/
20718: OKC_K_LINES_B Sv,
20719: OKC_K_LINES_V Cov,
20720: oks_k_lines_b ksl,
20721: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20722: OKC_K_LINES_B Clv,

Line 20722: OKC_K_LINES_B Clv,

20718: OKC_K_LINES_B Sv,
20719: OKC_K_LINES_V Cov,
20720: oks_k_lines_b ksl,
20721: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20722: OKC_K_LINES_B Clv,
20723: OKC_K_ITEMS items,
20724: MTL_SYSTEM_ITEMS_B_KFV sys
20725: WHERE HDT.ID = HD.ID
20726: AND HDT.LANGUAGE = USERENV('LANG')

Line 20808: OKC_K_LINES_B Sv,

20804: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
20805: Sv.Lse_Id Service_Lse_Id
20806: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
20807: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
20808: OKC_K_LINES_B Sv,
20809: OKS_K_LINES_B KSL,
20810: OKC_K_LINES_V Cov,
20811: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20812: OKC_K_LINES_B Clv,

Line 20812: OKC_K_LINES_B Clv,

20808: OKC_K_LINES_B Sv,
20809: OKS_K_LINES_B KSL,
20810: OKC_K_LINES_V Cov,
20811: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
20812: OKC_K_LINES_B Clv,
20813: OKC_K_ITEMS items,
20814: MTL_SYSTEM_ITEMS_B_KFV sys
20815: WHERE Hd.Id = Sv.chr_id
20816: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)

Line 20897: OKC_K_LINES_B Sv,

20893: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
20894: Sv.Lse_Id Service_Lse_Id
20895: FROM OKC_K_HEADERS_ALL_B HD,
20896: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
20897: OKC_K_LINES_B Sv,
20898: OKS_K_LINES_B KSL,
20899: OKC_K_LINES_V Cov,
20900: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
20901: OKC_K_ITEMS items,

Line 20981: OKC_K_LINES_B Sv,

20977: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
20978: Sv.Lse_Id Service_Lse_Id
20979: FROM OKC_K_HEADERS_ALL_B HD,
20980: OKC_K_HEADERS_TL HDT,/*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
20981: OKC_K_LINES_B Sv,
20982: OKS_K_LINES_B KSL,
20983: OKC_K_LINES_V Cov,
20984: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20985: OKC_K_ITEMS items,

Line 21056: OKC_K_LINES_B Sv,

21052: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
21053: Sv.Lse_Id Service_Lse_Id
21054: FROM OKC_K_HEADERS_ALL_B HD, /*modified for bug:8700389*/
21055: OKC_K_HEADERS_TL HDT,
21056: OKC_K_LINES_B Sv,
21057: OKS_K_LINES_B KSL,
21058: OKC_K_LINES_B Cov,
21059: OKC_K_LINES_TL COVTL,
21060: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

Line 21058: OKC_K_LINES_B Cov,

21054: FROM OKC_K_HEADERS_ALL_B HD, /*modified for bug:8700389*/
21055: OKC_K_HEADERS_TL HDT,
21056: OKC_K_LINES_B Sv,
21057: OKS_K_LINES_B KSL,
21058: OKC_K_LINES_B Cov,
21059: OKC_K_LINES_TL COVTL,
21060: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21061: OKC_K_ITEMS items,
21062: MTL_SYSTEM_ITEMS_B_KFV sys

Line 21126: OKC_K_LINES_B Sv,

21122: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
21123: Sv.Lse_Id Service_Lse_Id
21124: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
21125: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
21126: OKC_K_LINES_B Sv,
21127: OKC_K_LINES_V Cov,
21128: oks_k_lines_b ksl,
21129: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21130: OKC_K_ITEMS items,

Line 21213: OKC_K_LINES_B Sv,

21209: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
21210: Sv.Lse_Id Service_Lse_Id
21211: FROM OKC_K_HEADERS_ALL_B HD,
21212: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
21213: OKC_K_LINES_B Sv,
21214: OKC_K_LINES_V Cov,
21215: oks_k_lines_b ksl,
21216: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
21217: OKC_K_ITEMS items,