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 936: FROM Okc_K_Lines_B BPL,

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

Line 937: Okc_K_Lines_B CVL

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

Line 1527: FROM Okc_K_Lines_B RTL

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

Line 1528: ,Okc_K_Lines_B BPL

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

Line 3275: from okc_k_lines_b okclb,

3271: select oct.id,
3272: oct.timezone_id,
3273: oct.default_yn,
3274: okslb.APPLY_DEFAULT_TIMEZONE
3275: from okc_k_lines_b okclb,
3276: oks_k_lines_b okslb,
3277: oks_coverage_timezones oct
3278: where okclb.id = P_BPL_Id
3279: and okslb.cle_id = okclb.id

Line 4574: from okc_k_lines_b okclb,

4570: select oct.id,
4571: oct.timezone_id,
4572: oct.default_yn,
4573: okslb.APPLY_DEFAULT_TIMEZONE
4574: from okc_k_lines_b okclb,
4575: oks_k_lines_b okslb,
4576: oks_coverage_timezones oct
4577: where okclb.id = P_BPL_Id
4578: and okslb.cle_id = okclb.id

Line 5569: ,OKC_K_LINES_B LIN

5565: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5566: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5567: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5568: ,OKC_LINE_STYLES_V STL
5569: ,OKC_K_LINES_B LIN
5570: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5571: WHERE LIN.ID = Cx_Cle_Id --Commented by Jvorugan NVL(Cx_Cle_Id, LIN.ID)
5572: AND LIN.START_DATE IS NOT NULL
5573: AND LIN.END_DATE IS NOT NULL

Line 5596: ,OKC_K_LINES_B LIN

5592: ,OKSLIN.discount_list discount_list -- 11.5.10 changes
5593: ,LIN.price_list_id price_list_id -- 11.5.10 changes
5594: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5595: ,OKC_LINE_STYLES_V STL
5596: ,OKC_K_LINES_B LIN
5597: ,OKS_K_LINES_B OKSLIN -- 11.5.10 changes
5598: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5599: LIN.START_DATE IS NOT NULL
5600: AND LIN.END_DATE IS NOT NULL

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

5620: Li_TableIdx := 0;
5621:
5622: /* Added by Jvorugan for perf bug:4998337.
5623: If lx_cle_id is not null then only passing the value.
5624: This is to avoid full table scan on okc_k_headers_all_b, okc_k_lines_b, oks_k_lines_b
5625: */
5626:
5627: IF Lx_Cle_Id IS NULL
5628: THEN

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

5641: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5642: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
5643: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5644: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5645: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5646: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5647: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5648: 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
5649: 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 5647: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

5643: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5644: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5645: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5646: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5647: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5648: 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
5649: 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
5650: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5651: 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 5649: 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

5645: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5646: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5647: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5648: 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
5649: 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
5650: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5651: 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
5652: 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
5653: 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 5681: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id

5677: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5678: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
5679: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5680: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5681: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5682: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5683: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5684: 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
5685: 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 5683: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

5679: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5680: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5681: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5682: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5683: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5684: 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
5685: 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
5686: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5687: 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 5685: 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

5681: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5682: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5683: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5684: 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
5685: 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
5686: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5687: 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
5688: 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
5689: 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 5718: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id

5714: Lx_Contract_Lines(Li_TableIdx).Start_Date_Active := Idx.Start_Date;
5715: Lx_Contract_Lines(Li_TableIdx).End_Date_Active := Idx.End_Date;
5716: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5717: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5718: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5719: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5720: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5721: 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
5722: 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 5720: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id

5716: Lx_Contract_Lines(Li_TableIdx).Line_Name := Idx.Name;
5717: Lx_Contract_Lines(Li_TableIdx).Bill_To_Site_Use_Id := Idx.Bill_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5718: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5719: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5720: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5721: 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
5722: 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
5723: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5724: 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 5722: 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

5718: --(NULL,Idx.Id,'OKX_BILLTO')); -- okc_k_lines_b.bill_to_site_use_id
5719: Lx_Contract_Lines(Li_TableIdx).Ship_To_Site_Use_Id := Idx.Ship_To_Site_Use_Id; --TO_NUMBER(OKS_ENT_UTIL_PVT.Get_BilltoShipto
5720: --(NULL,Idx.Id,'OKX_SHIPTO')); --okc_k_lines_b.ship_to_site_use_id
5721: 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
5722: 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
5723: Lx_Contract_Lines(Li_TableIdx).Price_Negotiated := Idx.Price_Negotiated;
5724: 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
5725: 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
5726: 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 5842: ,OKC_K_LINES_B LIN

5838: ,HDR.AUTHORING_ORG_ID ORG_ID
5839: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5840: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5841: ,OKC_LINE_STYLES_V STL
5842: ,OKC_K_LINES_B LIN
5843: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5844: WHERE LIN.ID = Cx_Cle_Id -- COmmented by Jvorugan for bug:4998337 NVL(Cx_Cle_Id, LIN.ID)
5845: AND LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
5846: AND STL.ID = LIN.LSE_ID

Line 5862: ,OKC_K_LINES_B LIN

5858: ,HDR.AUTHORING_ORG_ID ORG_ID
5859: ,HDR.INV_ORGANIZATION_ID ORGANIZATION_ID
5860: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5861: ,OKC_LINE_STYLES_V STL
5862: ,OKC_K_LINES_B LIN
5863: ,OKS_K_LINES_B OKSLIN --11.5.10 changes
5864: WHERE -- LIN.ID = NVL(Cx_Cle_Id, LIN.ID)
5865: LIN.LSE_ID IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
5866: AND STL.ID = LIN.LSE_ID

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

5917: Li_TableIdx := 0;
5918:
5919: /* Modified by Jvorugan for perg bug:4998337.
5920: If lx_cle_id is not null, then only passing the value.
5921: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition
5922: */
5923:
5924: IF Lx_Cle_Id IS NULL
5925: THEN

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

5942: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
5943: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
5944: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
5945:
5946: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
5947: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
5948:
5949: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
5950: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

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

6005: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6006: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6007: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6008:
6009: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6010: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6011:
6012: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6013: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

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

6068: Lx_Party_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Party(Idx.Id);
6069: Lx_CustAc_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Customer(Idx.Id);
6070: Lx_Site_Rec := OKS_ENT_UTIL_PVT.Get_CLvl_Site(Idx.Id, Idx.Org_Id);
6071:
6072: -- Lx_QtyRate_Rec := OKS_ENT_UTIL_PVT.Get_QtyRate_Rule(Idx.Id); --null oks_k_lines_b , okc_k_lines_b
6073: -- Ln_ListPrice := TO_NUMBER(OKS_ENT_UTIL_PVT.Get_PriceList(NULL,Idx.Id,'P'));
6074:
6075: Lx_Covered_Levels(Li_TableIdx).Row_Id := Idx.RowId;
6076: Lx_Covered_Levels(Li_TableIdx).Line_Id := Idx.Id;

Line 6573: ,OKC_K_Lines_B BPL

6569: ,con.resource_class
6570: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6571: ,OKC_Contacts CON
6572: ,OKC_K_Party_Roles_B ROL
6573: ,OKC_K_Lines_B BPL
6574: ,OKC_K_Lines_B SBL
6575: ,OKC_K_Lines_B COV
6576: ,okc_k_items cimbp
6577: WHERE SBL.Id = Cx_SBL_Id

Line 6574: ,OKC_K_Lines_B SBL

6570: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6571: ,OKC_Contacts CON
6572: ,OKC_K_Party_Roles_B ROL
6573: ,OKC_K_Lines_B BPL
6574: ,OKC_K_Lines_B SBL
6575: ,OKC_K_Lines_B COV
6576: ,okc_k_items cimbp
6577: WHERE SBL.Id = Cx_SBL_Id
6578: AND SBL.Lse_Id IN (1,14,19)

Line 6575: ,OKC_K_Lines_B COV

6571: ,OKC_Contacts CON
6572: ,OKC_K_Party_Roles_B ROL
6573: ,OKC_K_Lines_B BPL
6574: ,OKC_K_Lines_B SBL
6575: ,OKC_K_Lines_B COV
6576: ,okc_k_items cimbp
6577: WHERE SBL.Id = Cx_SBL_Id
6578: AND SBL.Lse_Id IN (1,14,19)
6579: and cov.cle_id = sbl.id

Line 6606: ,OKC_K_Lines_B BPL

6602: ,con.resource_class
6603: FROM OKS_Resource_Groups_V RSG
6604: ,OKC_Contacts CON
6605: ,OKC_K_Party_Roles_B ROL
6606: ,OKC_K_Lines_B BPL
6607: ,OKC_K_Lines_B SBL
6608: ,OKC_K_Lines_B COV
6609: ,okc_k_items cimbp
6610: WHERE SBL.Id = Cx_SBL_Id

Line 6607: ,OKC_K_Lines_B SBL

6603: FROM OKS_Resource_Groups_V RSG
6604: ,OKC_Contacts CON
6605: ,OKC_K_Party_Roles_B ROL
6606: ,OKC_K_Lines_B BPL
6607: ,OKC_K_Lines_B SBL
6608: ,OKC_K_Lines_B COV
6609: ,okc_k_items cimbp
6610: WHERE SBL.Id = Cx_SBL_Id
6611: AND SBL.Lse_Id IN (1,14,19)

Line 6608: ,OKC_K_Lines_B COV

6604: ,OKC_Contacts CON
6605: ,OKC_K_Party_Roles_B ROL
6606: ,OKC_K_Lines_B BPL
6607: ,OKC_K_Lines_B SBL
6608: ,OKC_K_Lines_B COV
6609: ,okc_k_items cimbp
6610: WHERE SBL.Id = Cx_SBL_Id
6611: AND SBL.Lse_Id IN (1,14,19)
6612: and cov.cle_id = sbl.id

Line 6651: ,OKC_K_Lines_B BPL

6647:
6648: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC
6649: ,OKC_Contacts CON
6650: ,OKC_K_Party_Roles_B ROL
6651: ,OKC_K_Lines_B BPL
6652: ,okc_k_items cimbp
6653: ,oks_k_lines_b ksl
6654: WHERE ksl.cle_id = Cx_SBL_Id
6655: AND BPL.cle_id = ksl.Coverage_Id

Line 6683: ,OKC_K_Lines_B BPL

6679:
6680: FROM OKS_Resource_Groups_V RSG
6681: ,OKC_Contacts CON
6682: ,OKC_K_Party_Roles_B ROL
6683: ,OKC_K_Lines_B BPL
6684: ,okc_k_items cimbp
6685: ,oks_k_lines_b ksl
6686: WHERE ksl.cle_id = Cx_SBL_Id
6687: AND BPL.cle_id = ksl.Coverage_Id

Line 7135: FROM Okc_K_lines_B cle

7131:
7132:
7133: CURSOR Lx_Csr_dnz_Chr(Cx_Cle_Id IN Gx_OKS_Id) IS
7134: SELECT CLE.DNZ_CHR_ID CONTRACT_ID
7135: FROM Okc_K_lines_B cle
7136: WHERE cle.id = Cx_Cle_Id
7137: AND rownum = 1;
7138:
7139: -- for category 'SUPPLIER_CONTACT'

Line 9494: FROM Okc_K_Lines_B

9490: IS
9491:
9492: CURSOR Lx_Csr_Contracts(Cx_CovLvlLine_Id IN Gx_OKS_Id) IS
9493: SELECT Dnz_Chr_Id, Id
9494: FROM Okc_K_Lines_B
9495: WHERE Id = Cx_CovLvlLine_Id
9496: AND Lse_Id In (7,8,9,10,11,35,18,25);
9497:
9498: Lx_CovLvlLine_Id CONSTANT Gx_OKS_Id := P_CovLvlLine_Id;

Line 9562: FROM Okc_K_Lines_B

9558: IS
9559:
9560: CURSOR Lx_Csr_Contracts(Cx_SrvLine_Id IN Gx_OKS_Id) IS
9561: SELECT Dnz_Chr_Id, Id
9562: FROM Okc_K_Lines_B
9563: WHERE Id = Cx_SrvLine_Id
9564: AND Lse_Id In (1,14,19);
9565:
9566: Lx_SrvLine_Id CONSTANT Gx_OKS_Id := P_SrvLine_Id;

Line 9715: ,Okc_K_Lines_B SV

9711: ,Get_End_Date_Time(SV.End_Date) End_Date
9712: ,Get_End_Date_Time(SV.Date_Terminated) Date_Terminated
9713: FROM Okx_System_Items_V XI
9714: ,Okc_K_Items IT
9715: ,Okc_K_Lines_B SV
9716: WHERE SV.Id = Cx_SrvLine_Id
9717: AND SV.Lse_Id IN (1,14,19)
9718: AND IT.Cle_Id = SV.Id
9719: -- AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')

Line 9845: FROM Okc_K_Lines_B SVL

9841: ,KSL.Standard_COV_YN
9842: ,SVL.Start_Date
9843: ,Get_End_Date_Time(SVL.End_Date) End_Date
9844: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
9845: FROM Okc_K_Lines_B SVL
9846: ,Oks_K_Lines_B KSL
9847: ,Okc_K_Lines_V COV
9848: WHERE SVL.Id = Cx_SrvLine_Id
9849: AND SVL.Lse_Id in (1,14,19)

Line 10162: ,Okc_K_Lines_B CL

10158: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10159: ,Okc_Line_Styles_B SB
10160: ,Okc_Line_Styles_TL ST
10161: ,Okc_K_Items IT
10162: ,Okc_K_Lines_B CL
10163: WHERE CL.Id = NVL(Cx_Cle_Id, CL.Id)
10164: AND CL.Dnz_Chr_Id = Cx_Chr_Id
10165: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
10166: AND IT.Cle_Id = CL.Id

Line 10890: ,Okc_K_Lines_B SV

10886: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10887: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10888: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10889: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10890: ,Okc_K_Lines_B SV
10891: ,Okc_K_Lines_B CL
10892: WHERE HD.Id = Cx_Chr_Id
10893: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
10894: AND HD.Id > -1

Line 10891: ,Okc_K_Lines_B CL

10887: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10888: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10889: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10890: ,Okc_K_Lines_B SV
10891: ,Okc_K_Lines_B CL
10892: WHERE HD.Id = Cx_Chr_Id
10893: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
10894: AND HD.Id > -1
10895: AND HD.Template_YN <> 'Y'

Line 10907: ,Okc_K_Lines_B BPL

10903: AND (Cx_BP_Id IS NULL
10904: OR
10905: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
10906: FROM Okc_K_Items ITM
10907: ,Okc_K_Lines_B BPL
10908: ,Oks_K_Lines_B KSL
10909: WHERE KSL.Cle_Id = SV.Id
10910: AND BPL.Cle_Id = KSL.Coverage_ID
10911: AND ITM.Cle_Id = BPL.Id

Line 10921: -- ,Okc_K_Lines_B BPL

10917: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
10918: --
10919: -- EXISTS (SELECT '*'
10920: -- FROM Okc_K_Items ITM
10921: -- ,Okc_K_Lines_B BPL
10922: -- ,Okc_K_Lines_B CV
10923: -- WHERE CV.Cle_Id = SV.Id
10924: -- AND CV.Lse_Id IN (2,15,20)
10925: -- AND BPL.Cle_Id = CV.Id

Line 10922: -- ,Okc_K_Lines_B CV

10918: --
10919: -- EXISTS (SELECT '*'
10920: -- FROM Okc_K_Items ITM
10921: -- ,Okc_K_Lines_B BPL
10922: -- ,Okc_K_Lines_B CV
10923: -- WHERE CV.Cle_Id = SV.Id
10924: -- AND CV.Lse_Id IN (2,15,20)
10925: -- AND BPL.Cle_Id = CV.Id
10926: -- AND ITM.Cle_Id = BPL.Id

Line 10959: ,Okc_K_Lines_B SV

10955: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10956: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10957: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10958: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10959: ,Okc_K_Lines_B SV
10960: ,Okc_K_Lines_B CL
10961: WHERE HD.Id = Cx_Chr_Id
10962: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
10963: AND HD.Id > -1

Line 10960: ,Okc_K_Lines_B CL

10956: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10957: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10958: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10959: ,Okc_K_Lines_B SV
10960: ,Okc_K_Lines_B CL
10961: WHERE HD.Id = Cx_Chr_Id
10962: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
10963: AND HD.Id > -1
10964: AND HD.Template_YN <> 'Y'

Line 10976: ,Okc_K_Lines_B BPL

10972: AND (Cx_BP_Id IS NULL
10973: OR
10974: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
10975: FROM Okc_K_Items ITM
10976: ,Okc_K_Lines_B BPL
10977: ,Oks_K_Lines_B KSL
10978: WHERE KSL.Cle_Id = SV.Id
10979: AND BPL.Cle_Id = KSL.Coverage_ID
10980: AND ITM.Cle_Id = BPL.Id

Line 10990: -- ,Okc_K_Lines_B BPL

10986: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
10987: --
10988: -- EXISTS (SELECT '*'
10989: -- FROM Okc_K_Items ITM
10990: -- ,Okc_K_Lines_B BPL
10991: -- ,Okc_K_Lines_B CV
10992: -- WHERE CV.Cle_Id = SV.Id
10993: -- AND CV.Lse_Id IN (2,15,20)
10994: -- AND BPL.Cle_Id = CV.Id

Line 10991: -- ,Okc_K_Lines_B CV

10987: --
10988: -- EXISTS (SELECT '*'
10989: -- FROM Okc_K_Items ITM
10990: -- ,Okc_K_Lines_B BPL
10991: -- ,Okc_K_Lines_B CV
10992: -- WHERE CV.Cle_Id = SV.Id
10993: -- AND CV.Lse_Id IN (2,15,20)
10994: -- AND BPL.Cle_Id = CV.Id
10995: -- AND ITM.Cle_Id = BPL.Id

Line 11028: ,Okc_K_Lines_B SV

11024: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11025: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11026: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11027: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11028: ,Okc_K_Lines_B SV
11029: ,Okc_K_Lines_B CL
11030: WHERE HD.Id = Cx_Chr_Id
11031: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11032: AND HD.Id > -1

Line 11029: ,Okc_K_Lines_B CL

11025: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11026: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11027: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11028: ,Okc_K_Lines_B SV
11029: ,Okc_K_Lines_B CL
11030: WHERE HD.Id = Cx_Chr_Id
11031: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11032: AND HD.Id > -1
11033: AND HD.Template_YN <> 'Y'

Line 11046: ,Okc_K_Lines_B BPL

11042: AND (Cx_BP_Id IS NULL
11043: OR
11044: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11045: FROM Okc_K_Items ITM
11046: ,Okc_K_Lines_B BPL
11047: ,Oks_K_Lines_B KSL
11048: WHERE KSL.Cle_Id = SV.Id
11049: AND BPL.Cle_Id = KSL.Coverage_ID
11050: AND ITM.Cle_Id = BPL.Id

Line 11060: -- ,Okc_K_Lines_B BPL

11056: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11057: --
11058: -- EXISTS (SELECT '*'
11059: -- FROM Okc_K_Items ITM
11060: -- ,Okc_K_Lines_B BPL
11061: -- ,Okc_K_Lines_B CV
11062: -- WHERE CV.Cle_Id = SV.Id
11063: -- AND CV.Lse_Id IN (2,15,20)
11064: -- AND BPL.Cle_Id = CV.Id

Line 11061: -- ,Okc_K_Lines_B CV

11057: --
11058: -- EXISTS (SELECT '*'
11059: -- FROM Okc_K_Items ITM
11060: -- ,Okc_K_Lines_B BPL
11061: -- ,Okc_K_Lines_B CV
11062: -- WHERE CV.Cle_Id = SV.Id
11063: -- AND CV.Lse_Id IN (2,15,20)
11064: -- AND BPL.Cle_Id = CV.Id
11065: -- AND ITM.Cle_Id = BPL.Id

Line 11097: ,Okc_K_Lines_B SV

11093: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11094: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11095: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11096: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11097: ,Okc_K_Lines_B SV
11098: ,Okc_K_Lines_B CL
11099: WHERE HD.Id = Cx_Chr_Id
11100: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11101: AND HD.Id > -1

Line 11098: ,Okc_K_Lines_B CL

11094: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11095: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11096: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11097: ,Okc_K_Lines_B SV
11098: ,Okc_K_Lines_B CL
11099: WHERE HD.Id = Cx_Chr_Id
11100: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11101: AND HD.Id > -1
11102: AND HD.Template_YN <> 'Y'

Line 11113: ,Okc_K_Lines_B BPL

11109: AND (Cx_BP_Id IS NULL
11110: OR
11111: EXISTS (SELECT '*' -- Modified for 12.0 Coverage Rearch project (JVARGHES)
11112: FROM Okc_K_Items ITM
11113: ,Okc_K_Lines_B BPL
11114: ,Oks_K_Lines_B KSL
11115: WHERE KSL.Cle_Id = SV.Id
11116: AND BPL.Cle_Id = KSL.Coverage_ID
11117: AND ITM.Cle_Id = BPL.Id

Line 11128: -- ,Okc_K_Lines_B BPL

11124: --
11125: --
11126: -- EXISTS (SELECT '*'
11127: -- FROM Okc_K_Items ITM
11128: -- ,Okc_K_Lines_B BPL
11129: -- ,Okc_K_Lines_B CV
11130: -- WHERE CV.Cle_Id = SV.Id
11131: -- AND CV.Lse_Id IN (2,15,20)
11132: -- AND BPL.Cle_Id = CV.Id

Line 11129: -- ,Okc_K_Lines_B CV

11125: --
11126: -- EXISTS (SELECT '*'
11127: -- FROM Okc_K_Items ITM
11128: -- ,Okc_K_Lines_B BPL
11129: -- ,Okc_K_Lines_B CV
11130: -- WHERE CV.Cle_Id = SV.Id
11131: -- AND CV.Lse_Id IN (2,15,20)
11132: -- AND BPL.Cle_Id = CV.Id
11133: -- AND ITM.Cle_Id = BPL.Id

Line 11784: FROM Okc_K_lines_B

11780: IS
11781:
11782: CURSOR Lx_SrvLine(Cx_SrvLine_Id IN Gx_OKS_Id) IS
11783: SELECT Dnz_Chr_Id
11784: FROM Okc_K_lines_B
11785: WHERE Id = Cx_SrvLine_Id;
11786:
11787: Lx_Inp_Rec CONSTANT Inp_rec_getcont02 := P_Inp_Rec;
11788:

Line 12400: ,Okc_K_Lines_B SV

12396: OR
12397: HB.Id IN ( SELECT SV.Chr_Id
12398: FROM Okx_System_Items_V XI
12399: ,Okc_K_Items IT
12400: ,Okc_K_Lines_B SV
12401: WHERE SV.Lse_ID IN (1,14,19) --SV.Chr_Id = HB.Id
12402: AND IT.Cle_Id = SV.Id
12403: AND IT.Object1_Id1 = NVL(Cv_Service_Item_Id,IT.Object1_Id1)
12404: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')

Line 13034: -- okc_k_lines_b cle,

13030: -- cvt.importance_level,
13031: -- okh.estimated_amount,
13032: -- okh.sts_code
13033: -- from OKC_K_HEADERS_ALL_B okh,
13034: -- okc_k_lines_b cle,
13035: -- okc_k_lines_b cle_cov,
13036: -- oks_k_lines_b okscle_cov,
13037: -- okc_k_lines_b cle_cvl,
13038: -- okc_k_items cim,

Line 13035: -- okc_k_lines_b cle_cov,

13031: -- okh.estimated_amount,
13032: -- okh.sts_code
13033: -- from OKC_K_HEADERS_ALL_B okh,
13034: -- okc_k_lines_b cle,
13035: -- okc_k_lines_b cle_cov,
13036: -- oks_k_lines_b okscle_cov,
13037: -- okc_k_lines_b cle_cvl,
13038: -- okc_k_items cim,
13039: -- okc_statuses_v sts,

Line 13037: -- okc_k_lines_b cle_cvl,

13033: -- from OKC_K_HEADERS_ALL_B okh,
13034: -- okc_k_lines_b cle,
13035: -- okc_k_lines_b cle_cov,
13036: -- oks_k_lines_b okscle_cov,
13037: -- okc_k_lines_b cle_cvl,
13038: -- okc_k_items cim,
13039: -- okc_statuses_v sts,
13040: -- oks_cov_types_v cvt
13041: -- where cle.chr_id = okh.id

Line 13067: okc_k_lines_b cle,

13063: cvt.importance_level,
13064: okh.estimated_amount,
13065: okh.sts_code
13066: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
13067: okc_k_lines_b cle,
13068: oks_k_lines_b cle_ksl,
13069: oks_k_lines_b okscle_cov,
13070: okc_k_lines_b cle_cvl,
13071: okc_k_items cim,

Line 13070: okc_k_lines_b cle_cvl,

13066: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
13067: okc_k_lines_b cle,
13068: oks_k_lines_b cle_ksl,
13069: oks_k_lines_b okscle_cov,
13070: okc_k_lines_b cle_cvl,
13071: okc_k_items cim,
13072: okc_statuses_v sts,
13073: oks_cov_types_v cvt
13074: where cle.chr_id = okh.id

Line 13100: -- okc_k_lines_b cle,

13096: -- covtyp.importance_level importance_level,
13097: -- okh.estimated_amount,
13098: -- okh.sts_code
13099: -- from OKC_K_HEADERS_ALL_B okh,
13100: -- okc_k_lines_b cle,
13101: -- okc_k_lines_b cle_cov,
13102: -- oks_k_lines_b okscle_cov,
13103: -- okc_k_lines_b cle_cvl,
13104: -- okc_k_items cim,

Line 13101: -- okc_k_lines_b cle_cov,

13097: -- okh.estimated_amount,
13098: -- okh.sts_code
13099: -- from OKC_K_HEADERS_ALL_B okh,
13100: -- okc_k_lines_b cle,
13101: -- okc_k_lines_b cle_cov,
13102: -- oks_k_lines_b okscle_cov,
13103: -- okc_k_lines_b cle_cvl,
13104: -- okc_k_items cim,
13105: -- okc_statuses_v sts,

Line 13103: -- okc_k_lines_b cle_cvl,

13099: -- from OKC_K_HEADERS_ALL_B okh,
13100: -- okc_k_lines_b cle,
13101: -- okc_k_lines_b cle_cov,
13102: -- oks_k_lines_b okscle_cov,
13103: -- okc_k_lines_b cle_cvl,
13104: -- okc_k_items cim,
13105: -- okc_statuses_v sts,
13106: -- oks_cov_types_v covtyp
13107: -- where cle.chr_id = okh.id

Line 13135: okc_k_lines_b cle,

13131: covtyp.importance_level importance_level,
13132: okh.estimated_amount,
13133: okh.sts_code
13134: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
13135: okc_k_lines_b cle,
13136: oks_k_lines_b cle_ksl,
13137: oks_k_lines_b okscle_cov,
13138: okc_k_lines_b cle_cvl,
13139: okc_k_items cim,

Line 13138: okc_k_lines_b cle_cvl,

13134: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)
13135: okc_k_lines_b cle,
13136: oks_k_lines_b cle_ksl,
13137: oks_k_lines_b okscle_cov,
13138: okc_k_lines_b cle_cvl,
13139: okc_k_items cim,
13140: okc_statuses_v sts,
13141: oks_cov_types_v covtyp
13142: where cle.chr_id = okh.id

Line 13923: FROM OKC_K_LINES_B CVL,

13919: IS
13920:
13921: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
13922: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
13923: FROM OKC_K_LINES_B CVL,
13924: OKC_K_LINES_B BPL,
13925: OKC_K_PARTY_ROLES_B CPL,
13926: OKC_CONTACTS CON
13927: WHERE CVL.ID = p_coverage_id

Line 13924: OKC_K_LINES_B BPL,

13920:
13921: CURSOR Check_Preferred_Group(p_coverage_id IN Gx_OKS_Id,p_chr_id in Gx_OKS_Id) IS
13922: SELECT COUNT(*) Pref_Grp_Cnt --CON.OBJECT1_ID1
13923: FROM OKC_K_LINES_B CVL,
13924: OKC_K_LINES_B BPL,
13925: OKC_K_PARTY_ROLES_B CPL,
13926: OKC_CONTACTS CON
13927: WHERE CVL.ID = p_coverage_id
13928: AND BPL.CLE_ID = CVL.ID

Line 15070: from okc_k_lines_b lines,

15066: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
15067: to_number(items.object1_id1) object1_id1,
15068: lines.dnz_chr_id,
15069: ksl.Standard_Cov_YN Standard_Cov_YN
15070: from okc_k_lines_b lines,
15071: oks_k_lines_b KSL,
15072: okc_k_lines_v lines2,
15073: okc_k_items items,
15074: cs_business_processes bp

Line 15434: ,Okc_K_Lines_B SV

15430: ,CAT.meaning HD_cat_meaning
15431: ,STS.meaning HD_sts_meaning
15432: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
15433: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15434: ,Okc_K_Lines_B SV
15435: ,Okc_K_Lines_B CL
15436: ,okc_subclasses_v CAT
15437: ,okc_statuses_v STS
15438: WHERE HD.Id = Cx_Chr_Id

Line 15435: ,Okc_K_Lines_B CL

15431: ,STS.meaning HD_sts_meaning
15432: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
15433: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15434: ,Okc_K_Lines_B SV
15435: ,Okc_K_Lines_B CL
15436: ,okc_subclasses_v CAT
15437: ,okc_statuses_v STS
15438: WHERE HD.Id = Cx_Chr_Id
15439: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 16554: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines

16550: k NUMBER;
16551:
16552: CURSOR CUR_GET_ORG_ID(l_contract_line_id IN NUMBER) IS
16553: SELECT hdr.AUTHORING_ORG_ID, hdr.INV_ORGANIZATION_ID
16554: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines
16555: WHERE lines.id = l_contract_line_id
16556: AND lines.chr_id = hdr.id ;
16557:
16558:

Line 16573: FROM OKC_K_LINES_B lines1,

16569: lines2.id bp_line_id,
16570: lines2.start_date start_date,
16571: lines2.end_date end_date,
16572: items.object1_id1
16573: FROM OKC_K_LINES_B lines1,
16574: OKC_K_LINES_B lines2,
16575: OKC_K_LINES_B lines3,
16576: OKC_K_ITEMS items
16577: WHERE lines1.id = p_contract_line_id

Line 16574: OKC_K_LINES_B lines2,

16570: lines2.start_date start_date,
16571: lines2.end_date end_date,
16572: items.object1_id1
16573: FROM OKC_K_LINES_B lines1,
16574: OKC_K_LINES_B lines2,
16575: OKC_K_LINES_B lines3,
16576: OKC_K_ITEMS items
16577: WHERE lines1.id = p_contract_line_id
16578: AND lines2.cle_id = lines1.id

Line 16575: OKC_K_LINES_B lines3,

16571: lines2.end_date end_date,
16572: items.object1_id1
16573: FROM OKC_K_LINES_B lines1,
16574: OKC_K_LINES_B lines2,
16575: OKC_K_LINES_B lines3,
16576: OKC_K_ITEMS items
16577: WHERE lines1.id = p_contract_line_id
16578: AND lines2.cle_id = lines1.id
16579: AND lines2.lse_id IN (2,15,20)

Line 16604: FROM OKC_K_LINES_B lines1,

16600: decode(KSL.Standard_Cov_YN,'Y', lines1.start_date,lines3.start_date) start_date
16601: ,decode(KSL.Standard_Cov_YN,'Y', lines1.end_date,lines3.end_date) end_date
16602: , lines3.id bpl_id
16603: , ksl.Standard_Cov_YN Standard_Cov_YN
16604: FROM OKC_K_LINES_B lines1,
16605: OKS_K_LINES_B KSL,
16606: OKC_K_LINES_B lines3,
16607: OKC_K_ITEMS items
16608: WHERE lines1.id = p_contract_line_id

Line 16606: OKC_K_LINES_B lines3,

16602: , lines3.id bpl_id
16603: , ksl.Standard_Cov_YN Standard_Cov_YN
16604: FROM OKC_K_LINES_B lines1,
16605: OKS_K_LINES_B KSL,
16606: OKC_K_LINES_B lines3,
16607: OKC_K_ITEMS items
16608: WHERE lines1.id = p_contract_line_id
16609: AND lines1.lse_id IN (1,14,19)
16610: and ksl.cle_id = lines1.id

Line 16733: FROM OKC_K_LINES_B lines1,

16729: CURSOR CUR_GET_COVLEVELS(l_contract_line_id IN NUMBER, l_object1_id1 IN VARCHAR2, l_object1_id2 IN VARCHAR2,
16730: l_object_code IN VARCHAR2) IS
16731:
16732: SELECT 'X'
16733: FROM OKC_K_LINES_B lines1,
16734: OKC_K_LINES_B lines2,
16735: OKC_K_ITEMS items
16736: WHERE lines1.id = l_contract_line_id
16737: AND lines2.cle_id = lines1.id

Line 16734: OKC_K_LINES_B lines2,

16730: l_object_code IN VARCHAR2) IS
16731:
16732: SELECT 'X'
16733: FROM OKC_K_LINES_B lines1,
16734: OKC_K_LINES_B lines2,
16735: OKC_K_ITEMS items
16736: WHERE lines1.id = l_contract_line_id
16737: AND lines2.cle_id = lines1.id
16738: AND lines2.dnz_chr_id = lines1.chr_id

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

18208: Li_TableIdx BINARY_INTEGER;
18209: Li_TableIdx_Out BINARY_INTEGER;
18210: Li_TableIdx_In BINARY_INTEGER;
18211:
18212: Lv_Compare_Val1 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
18213: Lv_Compare_Val2 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
18214: K NUMBER;
18215: L_Found VARCHAR2(1);
18216:

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

18209: Li_TableIdx_Out BINARY_INTEGER;
18210: Li_TableIdx_In BINARY_INTEGER;
18211:
18212: Lv_Compare_Val1 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
18213: Lv_Compare_Val2 OKC_K_LINES_B.ID%TYPE;--VARCHAR2(300);
18214: K NUMBER;
18215: L_Found VARCHAR2(1);
18216:
18217: BEGIN

Line 18430: OKC_K_LINES_B Sv,

18426: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18427: Sv.Lse_Id Service_Lse_Id
18428: FROM OKC_K_HEADERS_ALL_B HD,
18429: OKC_K_HEADERS_TL HDT, /*bug 7412576 OKC_K_HEADERS_V HD,*/
18430: OKC_K_LINES_B Sv,
18431: OKC_K_LINES_V Cov,
18432: oks_k_lines_b ksl,
18433: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18434: OKC_K_LINES_B Clv,

Line 18434: OKC_K_LINES_B Clv,

18430: OKC_K_LINES_B Sv,
18431: OKC_K_LINES_V Cov,
18432: oks_k_lines_b ksl,
18433: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18434: OKC_K_LINES_B Clv,
18435: OKC_K_ITEMS items,
18436: MTL_SYSTEM_ITEMS_B_KFV sys
18437: WHERE HDT.ID = HD.ID
18438: AND HDT.LANGUAGE = USERENV('LANG')

Line 18520: OKC_K_LINES_B Sv,

18516: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18517: Sv.Lse_Id Service_Lse_Id
18518: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
18519: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
18520: OKC_K_LINES_B Sv,
18521: OKS_K_LINES_B KSL,
18522: OKC_K_LINES_V Cov,
18523: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18524: OKC_K_LINES_B Clv,

Line 18524: OKC_K_LINES_B Clv,

18520: OKC_K_LINES_B Sv,
18521: OKS_K_LINES_B KSL,
18522: OKC_K_LINES_V Cov,
18523: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes
18524: OKC_K_LINES_B Clv,
18525: OKC_K_ITEMS items,
18526: MTL_SYSTEM_ITEMS_B_KFV sys
18527: WHERE Hd.Id = Sv.chr_id
18528: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)

Line 18609: OKC_K_LINES_B Sv,

18605: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18606: Sv.Lse_Id Service_Lse_Id
18607: FROM OKC_K_HEADERS_ALL_B HD,
18608: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18609: OKC_K_LINES_B Sv,
18610: OKS_K_LINES_B KSL,
18611: OKC_K_LINES_V Cov,
18612: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes
18613: OKC_K_ITEMS items,

Line 18693: OKC_K_LINES_B Sv,

18689: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18690: Sv.Lse_Id Service_Lse_Id
18691: FROM OKC_K_HEADERS_ALL_B HD,
18692: OKC_K_HEADERS_TL HDT,/*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18693: OKC_K_LINES_B Sv,
18694: OKS_K_LINES_B KSL,
18695: OKC_K_LINES_V Cov,
18696: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18697: OKC_K_ITEMS items,

Line 18774: OKC_K_LINES_B Sv,

18770: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18771: Sv.Lse_Id Service_Lse_Id
18772: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)
18773: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
18774: OKC_K_LINES_B Sv,
18775: OKC_K_LINES_V Cov,
18776: oks_k_lines_b ksl,
18777: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18778: OKC_K_ITEMS items,

Line 18861: OKC_K_LINES_B Sv,

18857: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18858: Sv.Lse_Id Service_Lse_Id
18859: FROM OKC_K_HEADERS_ALL_B HD,
18860: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/
18861: OKC_K_LINES_B Sv,
18862: OKC_K_LINES_V Cov,
18863: oks_k_lines_b ksl,
18864: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18865: OKC_K_ITEMS items,