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 927: index on ITM.cle_id be used to improve the cardinality on OKC_K_ITEMS during row source operation.

923: IS
924:
925: /**
926: bug 3202650: The purpose is to suppress index on ITM.object1_id1,ITM.jtot_object1_code and let
927: index on ITM.cle_id be used to improve the cardinality on OKC_K_ITEMS during row source operation.
928:
929: **/
930:
931: 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) IS

Line 941: FROM Okc_K_Items ITM

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

Line 6576: ,okc_k_items cimbp

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

Line 6609: ,okc_k_items cimbp

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

Line 6652: ,okc_k_items cimbp

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

Line 6684: ,okc_k_items cimbp

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

Line 8782: FROM OKC_K_ITEMS IT

8778: CURSOR Lx_Csr_CovLvlOthr_Contracts(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
8779: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
8780: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
8781: SELECT DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
8782: FROM OKC_K_ITEMS IT
8783: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
8784: AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#')
8785: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code;
8786:

Line 8791: FROM OKC_K_ITEMS IT

8787: CURSOR Lx_Csr_CovLvlItem_Contracts(Cx_CovLevel_Obj_Id1 IN Gx_OKS_Id
8788: ,Cv_CovLevel_Obj_Id2 IN VARCHAR2
8789: ,Cx_CovLevel_Obj_Code IN Gx_JTOT_ObjCode) IS
8790: SELECT DISTINCT IT.Dnz_Chr_Id Dnz_Chr_Id, IT.Cle_Id
8791: FROM OKC_K_ITEMS IT
8792: WHERE IT.Object1_Id1 = TO_CHAR(Cx_CovLevel_Obj_Id1)
8793: -- AND (IT.Object1_Id2 = Cv_CovLevel_Obj_Id2 OR Cv_CovLevel_Obj_Id2 = '#') -- BUG# 4735542
8794: AND IT.Jtot_Object1_Code = Cx_CovLevel_Obj_Code
8795: AND EXISTS (SELECT '*'

Line 9714: ,Okc_K_Items IT

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

Line 10161: ,Okc_K_Items IT

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

Line 10906: FROM Okc_K_Items ITM

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

Line 10920: -- FROM Okc_K_Items ITM

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

Line 10975: FROM Okc_K_Items ITM

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

Line 10989: -- FROM Okc_K_Items ITM

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

Line 11045: FROM Okc_K_Items ITM

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

Line 11059: -- FROM Okc_K_Items ITM

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

Line 11112: FROM Okc_K_Items ITM

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

Line 11127: -- FROM Okc_K_Items ITM

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

Line 12399: ,Okc_K_Items IT

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

Line 13038: -- okc_k_items cim,

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

Line 13071: okc_k_items cim,

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

Line 13104: -- okc_k_items cim,

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

Line 13139: okc_k_items cim,

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

Line 13290: okc_k_items cim,

13286:
13287: CURSOR Check_update_only(p_coverage_id IN Gx_OKS_Id) IS
13288: SELECT 'Y'
13289: FROM okc_k_lines_v bp,
13290: okc_k_items cim,
13291: cs_business_processes cbp
13292: WHERE bp.cle_id = p_coverage_id
13293: AND cim.cle_id = bp.id
13294: AND cbp.business_process_id = cim.object1_id1

Line 14484: ,Okc_K_Items IT

14480: CURSOR Lx_Csr_SrvItem (Cx_SrvLine_Id In Gx_OKS_Id, Cn_Organization_Id IN NUMBER) IS
14481: SELECT mtl.concatenated_segments Name
14482: ,mtl.description Description
14483: FROM mtl_system_items_b_kfv mtl
14484: ,Okc_K_Items IT
14485: WHERE IT.Cle_Id = Cx_SrvLine_Id
14486: AND IT.Jtot_Object1_Code IN ('OKX_SERVICE','OKX_WARRANTY')
14487: AND mtl.inventory_item_id = IT.Object1_Id1
14488: AND mtl.organization_id = IT.Object1_Id2

Line 15035: -- okc_k_items items,

15031: -- to_number(items.object1_id1) object1_id1 ,
15032: -- lines2.dnz_chr_id
15033: -- from okc_k_lines_v lines,
15034: -- okc_k_lines_v lines2,
15035: -- okc_k_items items,
15036: -- cs_business_processes bp
15037: -- where lines.cle_id = p_line_id
15038: -- and lines.id = lines2.cle_id
15039: -- and lines.lse_id in (2,15,20)

Line 15073: okc_k_items items,

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

Line 15252: okc_k_items items2,

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

Line 16576: OKC_K_ITEMS items

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

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

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

Line 16607: OKC_K_ITEMS items

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

Line 16735: OKC_K_ITEMS items

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

Line 18345: OKC_K_ITEMS items,

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

Line 18435: OKC_K_ITEMS items,

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

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

18486: P_Bill_To IN VARCHAR2,
18487: P_Ship_To IN VARCHAR2,
18488: P_renewal_code IN VARCHAR2,
18489: p_authoring_org_id in number) IS
18490: SELECT /*+ leading(clv) use_nl(clv sv items sys hd cov okscov) index(items okc_k_items_n1)*/
18491: Hd.Id Id,
18492: Hd.Contract_Number Contract_Number,
18493: Hd.Contract_Number_Modifier Contract_Number_Modifier,
18494: HdT.Short_Description Short_Description, -- HdT.Short_Description -- Modified for 12.0 MOAC project (JVARGHES)

Line 18525: OKC_K_ITEMS items,

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

Line 18613: OKC_K_ITEMS items,

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

Line 18697: OKC_K_ITEMS items,

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

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

18744: P_Bill_To IN VARCHAR2,
18745: P_Ship_To IN VARCHAR2,
18746: P_renewal_code IN VARCHAR2,
18747: p_authoring_org_id in number) IS
18748: SELECT /*+ leading(sv) use_nl(sv items sys hd cov okscov) index(items okc_k_items_n1)*/
18749: Hd.Id Id,
18750: Hd.Contract_Number Contract_Number,
18751: Hd.Contract_Number_Modifier Contract_Number_Modifier,
18752: HdT.Short_Description Short_Description, -- HdT.Short_Description -- Modified for 12.0 MOAC project (JVARGHES)

Line 18778: OKC_K_ITEMS items,

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

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

18828: P_Bill_To IN VARCHAR2,
18829: P_Ship_To IN VARCHAR2,
18830: P_renewal_code IN VARCHAR2,
18831: p_authoring_org_id in number) IS
18832: SELECT /*+ leading(hd) use_nl(hd sv items sys cov okscov) index(items okc_k_items_n1)*/
18833: Hd.Id Id,
18834: Hd.Contract_Number Contract_Number,
18835: Hd.Contract_Number_Modifier Contract_Number_Modifier,
18836: HdT.Short_Description Short_Description, /*bug 7412576*/

Line 18865: OKC_K_ITEMS items,

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

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

19077: IF Lv_Contracts.COUNT = 0 THEN
19078: /*Added for bug:6767455*/
19079: /* Added by Jvorugan for Bug:4991724
19080: If service_item_id is not null, then only passing the value.
19081: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
19082:
19083: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
19084: THEN
19085: open get_Contract_noclvl_noitem_cur(NULL,

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

19253: If Get_Line_Processed (p_line_id => Lv_Contracts(i).Rx_Cle_ID,
19254: p_line_id_tbl => l_line_id_tbl) = 'N' then
19255: /* Added for Bug:6767455
19256: If service_item_id is not null, then only passing the value.
19257: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
19258:
19259: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
19260: THEN
19261: open get_Contract_noitem_cur(Lv_Contracts(i).Rx_Chr_ID,

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

19547: IF Lv_Contracts.COUNT > 0 and Lv_covlevel_lines_passed = 'N' THEN
19548: FOR I In Lv_Contracts.FIRST .. Lv_Contracts.LAST LOOP
19549: /* Added by Jvorugan for Bug:4991724
19550: If service_item_id is not null, then only passing the value.
19551: This is to avoid full table scan on okc_k_items due to nvl condition on service_item_id*/
19552:
19553: IF Lv_Contract_line_Rec.Service_Item_ID IS NULL
19554: THEN
19555: