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 OKS_K_LINES_B

Line 431: ,Oks_K_Lines_B KSL

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
435: ,G_LINE_STYLE_WARRANTY

Line 737: FROM Oks_K_Lines_B BPL

733:
734: CURSOR Lx_Csr_BPL(Cx_BPL_Id IN Gx_OKS_Id) IS
735: SELECT BPL.Offset_Duration
736: ,BPL.Offset_period
737: FROM Oks_K_Lines_B BPL
738: WHERE BPL.Cle_Id = Cx_BPL_Id;
739:
740: Lx_BPL_Id CONSTANT Gx_OKS_Id := P_BPL_Id;
741: Ld_SVL_Start CONSTANT DATE := P_SVL_Start;

Line 1529: ,oks_k_lines_b OKSRTL

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
1533: AND RTL.Cle_Id = BPL.Id

Line 3276: oks_k_lines_b okslb,

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
3280: and oct.cle_id = okclb.id;

Line 4575: oks_k_lines_b okslb,

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
4579: and oct.cle_id = okclb.id;

Line 5570: ,OKS_K_LINES_B OKSLIN -- 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
5574: AND STL.ID = LIN.LSE_ID

Line 5597: ,OKS_K_LINES_B OKSLIN -- 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
5601: AND STL.ID = LIN.LSE_ID

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

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

Line 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

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

Line 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

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

Line 5843: ,OKS_K_LINES_B OKSLIN --11.5.10 changes

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
5847: AND HDR.ID = LIN.DNZ_CHR_ID

Line 5863: ,OKS_K_LINES_B OKSLIN --11.5.10 changes

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
5867: AND HDR.ID = LIN.DNZ_CHR_ID

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 6212: FROM OKS_K_Lines_B OKSLB

6208: SELECT CVT.Code
6209: ,CVT.Meaning
6210: ,CVT.Description
6211: ,CVT.Importance_Level
6212: FROM OKS_K_Lines_B OKSLB
6213: ,OKS_Cov_Types_V CVT
6214: WHERE OKSLB.Cle_Id = Cx_CVL_Id
6215: AND OKSLB.Coverage_Type = CVT.Code;
6216:

Line 6653: ,oks_k_lines_b ksl

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
6656: AND BPL.Lse_Id IN (3,16,21)
6657: and bpl.id = cimbp.cle_id

Line 6685: ,oks_k_lines_b ksl

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
6688: AND BPL.Lse_Id IN (3,16,21)
6689: and bpl.id = cimbp.cle_id

Line 9846: ,Oks_K_Lines_B KSL

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)
9850: AND KSL.Cle_Id = SVL.Id

Line 10908: ,Oks_K_Lines_B KSL

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
10912: AND ITM.OBJECT1_ID1||'' = TO_CHAR(Cx_BP_Id)

Line 10977: ,Oks_K_Lines_B KSL

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
10981: AND ITM.OBJECT1_ID1||'' = TO_CHAR(Cx_BP_Id)

Line 11047: ,Oks_K_Lines_B KSL

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
11051: AND ITM.OBJECT1_ID1||'' = TO_CHAR(Cx_BP_Id)

Line 11114: ,Oks_K_Lines_B KSL

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
11118: AND ITM.OBJECT1_ID1||'' = TO_CHAR(Cx_BP_Id)

Line 13036: -- oks_k_lines_b okscle_cov,

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,
13040: -- oks_cov_types_v cvt

Line 13068: oks_k_lines_b cle_ksl,

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,
13072: okc_statuses_v sts,

Line 13069: oks_k_lines_b okscle_cov,

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,
13072: okc_statuses_v sts,
13073: oks_cov_types_v cvt

Line 13102: -- oks_k_lines_b okscle_cov,

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,
13106: -- oks_cov_types_v covtyp

Line 13136: oks_k_lines_b cle_ksl,

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,
13140: okc_statuses_v sts,

Line 13137: oks_k_lines_b okscle_cov,

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,
13140: okc_statuses_v sts,
13141: oks_cov_types_v covtyp

Line 14469: FROM OKS_K_LINES_B KSL

14465: ,CVL.Start_Date CV_Start_Date
14466: ,Get_End_Date_Time(CVL.End_Date) Cv_End_Date
14467: ,Get_End_Date_Time(CVL.Date_Terminated) CV_Date_Terminated
14468: ,KSL.Standard_Cov_YN
14469: FROM OKS_K_LINES_B KSL
14470: ,Okc_K_Lines_V CVL
14471: WHERE KSL.Cle_Id = Cx_SrvLine_Id
14472: AND KSL.Coverage_Id = CVL.Id
14473: AND CVL.Lse_Id IN (2,15,20);

Line 15071: oks_k_lines_b KSL,

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
15075: where lines.id = p_line_id

Line 15253: oks_k_lines_b okslines2

15249: okslines2.discount_percent -- rul.rule_information4 rule_information4
15250: from okc_k_lines_v lines,
15251: okc_k_lines_v lines2,
15252: okc_k_items items2,
15253: oks_k_lines_b okslines2
15254: -- okc_rule_groups_b rgp,
15255: -- okc_rules_b rul
15256: where lines.id = p_txn_grp_line_id
15257: and lines.lse_id in (3,16,21)

Line 16605: OKS_K_LINES_B KSL,

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
16609: AND lines1.lse_id IN (1,14,19)

Line 18343: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

18339: Sv.Lse_Id Service_Lse_Id
18340: FROM OKC_K_HEADERS_V HD,
18341: OKC_K_LINES_V Sv,
18342: OKC_K_LINES_V Cov,
18343: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
18344: OKC_K_LINES_V Clv,
18345: OKC_K_ITEMS items,
18346: Okx_System_Items_V sys
18347: WHERE Hd.Id = Sv.chr_id

Line 18432: oks_k_lines_b ksl,

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,
18435: OKC_K_ITEMS items,
18436: MTL_SYSTEM_ITEMS_B_KFV sys

Line 18433: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes

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,
18435: OKC_K_ITEMS items,
18436: MTL_SYSTEM_ITEMS_B_KFV sys
18437: WHERE HDT.ID = HD.ID

Line 18521: OKS_K_LINES_B KSL,

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,
18525: OKC_K_ITEMS items,

Line 18523: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes

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,
18525: OKC_K_ITEMS items,
18526: MTL_SYSTEM_ITEMS_B_KFV sys
18527: WHERE Hd.Id = Sv.chr_id

Line 18610: OKS_K_LINES_B KSL,

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,
18614: MTL_SYSTEM_ITEMS_B_KFV sys

Line 18612: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes

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,
18614: MTL_SYSTEM_ITEMS_B_KFV sys
18615: WHERE Hd.Id = Sv.chr_id
18616: AND HDT.ID = HD.ID

Line 18694: OKS_K_LINES_B KSL,

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,
18698: MTL_SYSTEM_ITEMS_B_KFV sys

Line 18696: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

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,
18698: MTL_SYSTEM_ITEMS_B_KFV sys
18699: WHERE Hd.Id = Sv.chr_id
18700: AND HDT.ID = HD.ID

Line 18776: oks_k_lines_b ksl,

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,
18779: MTL_SYSTEM_ITEMS_B_KFV sys
18780: WHERE Hd.Id = Sv.chr_id

Line 18777: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

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,
18779: MTL_SYSTEM_ITEMS_B_KFV sys
18780: WHERE Hd.Id = Sv.chr_id
18781: AND Hd.id = SV.DNZ_CHR_ID

Line 18863: oks_k_lines_b ksl,

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,
18866: MTL_SYSTEM_ITEMS_B_KFV sys
18867: WHERE Hd.Id = Sv.chr_id

Line 18864: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

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,
18866: MTL_SYSTEM_ITEMS_B_KFV sys
18867: WHERE Hd.Id = Sv.chr_id
18868: AND HDT.ID = HD.ID