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 1532: ,oks_k_lines_b OKSRTL

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

Line 3635: oks_k_lines_b okslb,

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

Line 4962: oks_k_lines_b okslb,

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

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

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

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

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

Line 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

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

Line 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

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

Line 6231: ,OKS_K_LINES_B OKSLIN --11.5.10 changes

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

Line 6251: ,OKS_K_LINES_B OKSLIN --11.5.10 changes

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

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

6596: SELECT CVT.Code
6597: ,CVT.Meaning
6598: ,CVT.Description
6599: ,CVT.Importance_Level
6600: FROM OKS_K_Lines_B OKSLB
6601: ,OKS_Cov_Types_V CVT
6602: WHERE OKSLB.Cle_Id = Cx_CVL_Id
6603: AND OKSLB.Coverage_Type = CVT.Code;
6604:

Line 7041: ,oks_k_lines_b ksl

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

Line 7073: ,oks_k_lines_b ksl

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

Line 10277: ,Oks_K_Lines_B KSL

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

Line 11537: ,Oks_K_Lines_B KSL

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

Line 11586: ,Oks_K_Lines_B KSL

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

Line 11656: ,Oks_K_Lines_B KSL

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

Line 11705: ,Oks_K_Lines_B KSL

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

Line 11776: ,Oks_K_Lines_B KSL

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

Line 11826: ,Oks_K_Lines_B KSL

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

Line 11894: ,Oks_K_Lines_B KSL

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

Line 11943: ,Oks_K_Lines_B KSL

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

Line 14394: -- oks_k_lines_b okscle_cov,

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

Line 14426: oks_k_lines_b cle_ksl,

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

Line 14427: oks_k_lines_b okscle_cov,

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,
14430: okc_statuses_v sts,
14431: oks_cov_types_v cvt

Line 14460: -- oks_k_lines_b okscle_cov,

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

Line 14494: oks_k_lines_b cle_ksl,

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

Line 14495: oks_k_lines_b okscle_cov,

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,
14498: okc_statuses_v sts,
14499: oks_cov_types_v covtyp

Line 15831: FROM OKS_K_LINES_B KSL

15827: ,CVL.Start_Date CV_Start_Date
15828: ,Get_End_Date_Time(CVL.End_Date) Cv_End_Date
15829: ,Get_End_Date_Time(CVL.Date_Terminated) CV_Date_Terminated
15830: ,KSL.Standard_Cov_YN
15831: FROM OKS_K_LINES_B KSL
15832: ,Okc_K_Lines_V CVL
15833: WHERE KSL.Cle_Id = Cx_SrvLine_Id
15834: AND KSL.Coverage_Id = CVL.Id
15835: AND CVL.Lse_Id IN (2,15,20);

Line 16474: oks_k_lines_b KSL,

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

Line 16656: oks_k_lines_b okslines2

16652: okslines2.discount_percent -- rul.rule_information4 rule_information4
16653: from okc_k_lines_v lines,
16654: okc_k_lines_v lines2,
16655: okc_k_items items2,
16656: oks_k_lines_b okslines2
16657: -- okc_rule_groups_b rgp,
16658: -- okc_rules_b rul
16659: where lines.id = p_txn_grp_line_id
16660: and lines.lse_id in (3,16,21)

Line 18449: OKS_K_LINES_B KSL,

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

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

20627: Sv.Lse_Id Service_Lse_Id
20628: FROM OKC_K_HEADERS_V HD,
20629: OKC_K_LINES_V Sv,
20630: OKC_K_LINES_V Cov,
20631: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes
20632: OKC_K_LINES_V Clv,
20633: OKC_K_ITEMS items,
20634: Okx_System_Items_V sys
20635: WHERE Hd.Id = Sv.chr_id

Line 20720: oks_k_lines_b ksl,

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,
20723: OKC_K_ITEMS items,
20724: MTL_SYSTEM_ITEMS_B_KFV sys

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

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,
20723: OKC_K_ITEMS items,
20724: MTL_SYSTEM_ITEMS_B_KFV sys
20725: WHERE HDT.ID = HD.ID

Line 20809: OKS_K_LINES_B KSL,

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

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

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,
20813: OKC_K_ITEMS items,
20814: MTL_SYSTEM_ITEMS_B_KFV sys
20815: WHERE Hd.Id = Sv.chr_id

Line 20898: OKS_K_LINES_B KSL,

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

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

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,
20902: MTL_SYSTEM_ITEMS_B_KFV sys
20903: WHERE Hd.Id = Sv.chr_id
20904: AND HDT.ID = HD.ID

Line 20982: OKS_K_LINES_B KSL,

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

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

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,
20986: MTL_SYSTEM_ITEMS_B_KFV sys
20987: WHERE Hd.Id = Sv.chr_id
20988: AND HDT.ID = HD.ID

Line 21057: OKS_K_LINES_B KSL,

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

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

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
21063: WHERE Hd.Id = Sv.chr_id
21064: AND Hd.id = SV.DNZ_CHR_ID

Line 21128: oks_k_lines_b ksl,

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

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

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,
21131: MTL_SYSTEM_ITEMS_B_KFV sys
21132: WHERE Hd.Id = Sv.chr_id
21133: AND Hd.id = SV.DNZ_CHR_ID

Line 21215: oks_k_lines_b ksl,

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

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

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,
21218: MTL_SYSTEM_ITEMS_B_KFV sys
21219: WHERE Hd.Id = Sv.chr_id
21220: AND HDT.ID = HD.ID