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_ITEMS

Line 928: index on ITM.cle_id be used to improve the cardinality on OKC_K_ITEMS during row source operation.

924: IS
925:
926: /**
927: bug 3202650: The purpose is to suppress index on ITM.object1_id1,ITM.jtot_object1_code and let
928: index on ITM.cle_id be used to improve the cardinality on OKC_K_ITEMS during row source operation.
929:
930: **/
931:
932: CURSOR Lx_Csr_BPL(Cx_CVL_Id IN Gx_OKS_Id,Cx_BP_Id IN Gx_BusProcess_Id,Cx_BP_ObjCode IN Gx_JTOT_ObjCode,Cx_Req_Date IN DATE) IS --ansraj

Line 942: FROM Okc_K_Items ITM

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
943: WHERE ITM.Cle_id = BPL.Id
944: AND ITM.Object1_Id1 = Cx_BP_Id -- TO_CHAR(Cx_BP_Id) commented due to bug 3202650
945: AND ITM.Object1_Id2 = '#'
946: AND ITM.Jtot_Object1_Code = Cx_BP_ObjCode)

Line 6964: ,okc_k_items cimbp

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
6968: and cov.lse_id in (2,15,20)

Line 6997: ,okc_k_items cimbp

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
7001: and cov.lse_id in (2,15,20)

Line 7040: ,okc_k_items cimbp

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
7044: AND BPL.Lse_Id IN (3,16,21)

Line 7072: ,okc_k_items cimbp

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
7076: AND BPL.Lse_Id IN (3,16,21)

Line 9170: FROM OKC_K_ITEMS IT

9166: CURSOR Lx_Csr_CovLvlOthr_Contracts(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
9167: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
9168: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
9169: SELECT DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
9170: FROM OKC_K_ITEMS IT
9171: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9172: AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#')
9173: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code;
9174:

Line 9179: SELECT /+ index(IT OKC_K_ITEMS_N2) / DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id

9175: --bug 9083530 Added hints to the query to improve performance.
9176: CURSOR Lx_Csr_CovLvlItem_Contracts(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
9177: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
9178: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
9179: SELECT /*+ index(IT OKC_K_ITEMS_N2) */ DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
9180: FROM OKC_K_ITEMS IT
9181: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9182: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9183: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code

Line 9180: FROM OKC_K_ITEMS IT

9176: CURSOR Lx_Csr_CovLvlItem_Contracts(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
9177: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
9178: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
9179: SELECT /*+ index(IT OKC_K_ITEMS_N2) */ DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
9180: FROM OKC_K_ITEMS IT
9181: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9182: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9183: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
9184: AND EXISTS (SELECT/*+ push_subq no_unnest */ '*'

Line 9197: SELECT /+ index(IT OKC_K_ITEMS_N2) / DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id

9193:
9194: CURSOR Lx_Csr_CovLvlItem_Contracts1(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
9195: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
9196: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
9197: SELECT /*+ index(IT OKC_K_ITEMS_N2) */ DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
9198: FROM OKC_K_ITEMS IT
9199: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9200: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9201: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code

Line 9198: FROM OKC_K_ITEMS IT

9194: CURSOR Lx_Csr_CovLvlItem_Contracts1(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
9195: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
9196: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
9197: SELECT /*+ index(IT OKC_K_ITEMS_N2) */ DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
9198: FROM OKC_K_ITEMS IT
9199: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
9200: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
9201: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
9202: AND EXISTS (SELECT/*+ push_subq no_unnest */ '*'

Line 10145: ,Okc_K_Items IT

10141: ,SV.Start_Date
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

Line 10592: ,Okc_K_Items IT

10588: ,DECODE(SB.Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
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)

Line 10637: ,Okc_K_Items IT

10633: ,DECODE(SB.Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
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)

Line 11535: FROM Okc_K_Items ITM

11531: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
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

Line 11584: FROM Okc_K_Items ITM

11580: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
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

Line 11599: -- FROM Okc_K_Items ITM

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

Line 11654: FROM Okc_K_Items ITM

11650: AND CL.Id = Cx_CovLvlLine_Id
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

Line 11703: FROM Okc_K_Items ITM

11699: AND CL.Id = Cx_CovLvlLine_Id
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

Line 11718: -- FROM Okc_K_Items ITM

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

Line 11774: FROM Okc_K_Items ITM

11770: AND CL.Id = Cx_CovLvlLine_Id
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

Line 11824: FROM Okc_K_Items ITM

11820: AND CL.Id = Cx_CovLvlLine_Id
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

Line 11839: -- FROM Okc_K_Items ITM

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

Line 11892: FROM Okc_K_Items ITM

11888: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
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

Line 11941: FROM Okc_K_Items ITM

11937: AND CL.Lse_ID IN (7,8,9,10,11,35,18,25)
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

Line 11957: -- FROM Okc_K_Items ITM

11953: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
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)

Line 13650: ,Okc_K_Items IT

13646: AND (Cv_Service_Item_Id IS NULL
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)

Line 13697: ,Okc_K_Items IT

13693: AND (Cv_Service_Item_Id IS NULL
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)

Line 14396: -- okc_k_items cim,

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
14400: -- and okh.sts_code = sts.code

Line 14429: okc_k_items cim,

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
14433: and okh.sts_code = sts.code

Line 14462: -- okc_k_items cim,

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
14466: -- and okh.sts_code = sts.code

Line 14497: okc_k_items cim,

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
14501: and okh.sts_code = sts.code

Line 14648: okc_k_items cim,

14644:
14645: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
14646: SELECT 'Y'
14647: FROM okc_k_lines_v bp,
14648: okc_k_items cim,
14649: cs_business_processes cbp
14650: WHERE bp.cle_id = p_coverage_id
14651: AND cim.cle_id = bp.id
14652: AND cbp.business_process_id = cim.object1_id1

Line 15846: ,Okc_K_Items IT

15842: CURSOR Lx_Csr_SrvItem (Cx_SrvLine_Id In Gx_OKS_Id, Cn_Organization_Id IN NUMBER) IS
15843: SELECT mtl.concatenated_segments Name
15844: ,mtl.description Description
15845: FROM mtl_system_items_b_kfv mtl
15846: ,Okc_K_Items IT
15847: WHERE IT.Cle_Id = Cx_SrvLine_Id
15848: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')
15849: AND mtl.inventory_item_id = IT.Object1_Id1
15850: AND mtl.organization_id = IT.Object1_Id2

Line 16438: -- okc_k_items items,

16434: -- to_number(items.object1_id1) object1_id1 ,
16435: -- lines2.dnz_chr_id
16436: -- from okc_k_lines_v lines,
16437: -- okc_k_lines_v lines2,
16438: -- okc_k_items items,
16439: -- cs_business_processes bp
16440: -- where lines.cle_id = p_line_id
16441: -- and lines.id = lines2.cle_id
16442: -- and lines.lse_id in (2,15,20)

Line 16476: okc_k_items items,

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
16479: and lines.lse_id in (1,14,19)
16480: and KSL.cle_id = lines.id

Line 16655: okc_k_items items2,

16651: okslines2.discount_amount, -- rul.rule_information2 rule_information2,
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

Line 18420: OKC_K_ITEMS items

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)
18424: AND lines3.cle_id = lines2.id

Line 18443: SELECT /+ ordered use_nl(lines1,KSL,lines3,items) index(items okc_k_items_n1) / -- Bug Fix:5694209

18439: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
18440: --
18441:
18442: CURSOR CUR_GET_BP(p_contract_line_id IN NUMBER) IS
18443: SELECT /*+ ordered use_nl(lines1,KSL,lines3,items) index(items okc_k_items_n1) */ -- Bug Fix:5694209
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

Line 18451: OKC_K_ITEMS items

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
18455: AND lines3.cle_id = KSL.Coverage_Id

Line 18579: OKC_K_ITEMS items

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
18583: AND items.cle_id = lines2.id

Line 20633: OKC_K_ITEMS items,

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
20636: AND Hd.Id = nvl(P_Id,Hd.Id)
20637: and hd.authoring_org_id = nvl(p_authoring_org_id,hd.authoring_org_id) -- multi org security check

Line 20723: OKC_K_ITEMS items,

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')
20727: AND Hd.Id = Sv.chr_id

Line 20778: SELECT /+ leading(clv) use_nl(clv sv items sys hd cov okscov) index(items okc_k_items_n1)/

20774: P_Bill_To IN VARCHAR2,
20775: P_Ship_To IN VARCHAR2,
20776: P_renewal_code IN VARCHAR2,
20777: p_authoring_org_id in number) IS
20778: SELECT /*+ leading(clv) use_nl(clv sv items sys hd cov okscov) index(items okc_k_items_n1)*/
20779: Hd.Id Id,
20780: Hd.Contract_Number Contract_Number,
20781: Hd.Contract_Number_Modifier Contract_Number_Modifier,
20782: HdT.Short_Description Short_Description, -- HdT.Short_Description -- Modified for 12.0 MOAC project (JVARGHES)

Line 20813: OKC_K_ITEMS items,

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)
20817: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 20901: OKC_K_ITEMS items,

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
20905: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/

Line 20985: OKC_K_ITEMS items,

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
20989: AND HDT.LANGUAGE = USERENV('LANG')

Line 21061: OKC_K_ITEMS items,

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
21065: AND Hd.Id = P_ID -- nvl(P_Id,Hd.Id)

Line 21100: SELECT /+ leading(sv) use_nl(sv items sys hd cov okscov) index(items okc_k_items_n1)/

21096: P_Bill_To IN VARCHAR2,
21097: P_Ship_To IN VARCHAR2,
21098: P_renewal_code IN VARCHAR2,
21099: p_authoring_org_id in number) IS
21100: SELECT /*+ leading(sv) use_nl(sv items sys hd cov okscov) index(items okc_k_items_n1)*/
21101: Hd.Id Id,
21102: Hd.Contract_Number Contract_Number,
21103: Hd.Contract_Number_Modifier Contract_Number_Modifier,
21104: HdT.Short_Description Short_Description, -- HdT.Short_Description -- Modified for 12.0 MOAC project (JVARGHES)

Line 21130: OKC_K_ITEMS items,

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
21134: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)

Line 21184: SELECT /+ leading(hd) use_nl(hd sv items sys cov okscov) index(items okc_k_items_n1)/

21180: P_Bill_To IN VARCHAR2,
21181: P_Ship_To IN VARCHAR2,
21182: P_renewal_code IN VARCHAR2,
21183: p_authoring_org_id in number) IS
21184: SELECT /*+ leading(hd) use_nl(hd sv items sys cov okscov) index(items okc_k_items_n1)*/
21185: Hd.Id Id,
21186: Hd.Contract_Number Contract_Number,
21187: Hd.Contract_Number_Modifier Contract_Number_Modifier,
21188: HdT.Short_Description Short_Description, /*bug 7412576*/

Line 21217: OKC_K_ITEMS items,

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
21221: AND HDT.LANGUAGE = USERENV('LANG') /*bug 7412576*/

Line 21433: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/

21429: IF Lv_Contracts.COUNT = 0 THEN
21430: /*Added for bug:6767455*/
21431: /* Added by Jvorugan for Bug:4991724
21432: If service_item_id is not null, then only passing the value.
21433: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
21434:
21435: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
21436: THEN
21437: open get_Contract_noclvl_noitem_cur(NULL,

Line 21609: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/

21605: If Get_Line_Processed (p_line_id => Lv_Contracts(i).Rx_Cle_ID,
21606: p_line_id_tbl => l_line_id_tbl) = 'N' then
21607: /* Added for Bug:6767455
21608: If service_item_id is not null, then only passing the value.
21609: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
21610:
21611: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
21612: THEN
21613: open get_Contract_noitem_cur(Lv_Contracts(i).Rx_Chr_ID,

Line 21904: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/

21900: IF Lv_Contracts.COUNT > 0 and Lv_covlevel_lines_passed = 'N' THEN
21901: FOR I In Lv_Contracts.FIRST .. Lv_Contracts.LAST LOOP
21902: /* Added by Jvorugan for Bug:4991724
21903: If service_item_id is not null, then only passing the value.
21904: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
21905:
21906: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
21907: THEN
21908: