[Home] [Help]
5752: ,OKSHDR.tax_status tax_status -- 11.5.10 changes
5753: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5754: FROM OKC_K_PARTY_ROLES_B PTY
5755: ,OKC_K_HEADERS_TL HDT
5756: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5757: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5758: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)
5759: AND HDR.END_DATE = NVL(Cd_Chr_EndDate,HDR.END_DATE)
5760: AND HDR.STS_CODE = NVL(Cx_Chr_Sts_Code,HDR.STS_CODE)
5951: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5952: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5953: ,OKSLIN.discount_list discount_list -- 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)
5978: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5979: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5980: ,OKSLIN.discount_list discount_list -- 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)
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
6224: ,LIN.PRICE_NEGOTIATED
6225: ,STL.NAME
6226: ,HDR.AUTHORING_ORG_ID ORG_ID
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)
6244: ,LIN.PRICE_NEGOTIATED
6245: ,STL.NAME
6246: ,HDR.AUTHORING_ORG_ID ORG_ID
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)
6305: Li_TableIdx := 0;
6306:
6307: /* Modified by Jvorugan for perg bug:4998337.
6308: If lx_cle_id is not null, then only passing the value.
6309: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition
6310: */
6311:
6312: IF Lx_Cle_Id IS NULL
6313: THEN
7361: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7362: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7363: ,OKC_CONTACTS CO
7364: ,OKC_K_PARTY_ROLES_B PR
7365: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7366: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7367:
7368: -- Modified for 12.0 MOAC project (JVARGHES)
7369: AND HDR.ID = Cx_Chr_Id
7411: ,JTF_RS_SALESREPS S
7412: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7413: ,OKC_CONTACTS CO
7414: ,OKC_K_PARTY_ROLES_B PR
7415: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7416: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7417: AND co.dnz_chr_id = pr.dnz_chr_id
7418: AND CO.CPL_ID = PR.ID
7419: AND CO.OBJECT1_ID1 = S.SALESREP_ID --CS.ID1
7443: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7444: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7445: ,OKC_CONTACTS CO
7446: ,OKC_K_PARTY_ROLES_B PR
7447: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7448: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7449: and PR.CLE_ID = Cx_Cle_Id
7450:
7451: -- Modified for 12.0 MOAC project (JVARGHES)
7496: ,JTF_RS_SALESREPS S
7497: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7498: ,OKC_CONTACTS CO
7499: ,OKC_K_PARTY_ROLES_B PR
7500: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7501: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7502: and PR.CLE_ID = Cx_Cle_Id
7503: and co.dnz_chr_id = pr.dnz_chr_id
7504: AND CO.CPL_ID = PR.ID
10059: -- cursor modified to fix bug 3041443
10060:
10061: CURSOR Lx_Csr_Contracts(Cv_Contract_Num IN VARCHAR2, Cv_Contract_Num_Modifier IN VARCHAR2) IS
10062: SELECT Id
10063: FROM OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10064: WHERE Contract_Number = Cv_Contract_Num
10065: --AND (Cv_Contract_Num_Modifier IS NULL OR Contract_Number_Modifier = Cv_Contract_Num_Modifier);
10066: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,-99)
10067: AND nvl(Contract_Number_Modifier,'#') = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,'#'));
10585: ,Get_End_Date_Time(CL.End_Date) End_Date
10586: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10587: ,IT.Object1_Id1 Coverage_Level_Id
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
10630: ,Get_End_Date_Time(CL.End_Date) End_Date
10631: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10632: ,IT.Object1_Id1 Coverage_Level_Id
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
11514: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11515: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11516: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11517: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11518: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11519: ,Okc_K_Lines_B SV
11520: ,Okc_K_Lines_B CL
11521: WHERE HD.Id = Cx_Chr_Id
11522: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11563: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11564: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11565: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11566: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11567: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11568: ,Okc_K_Lines_B SV
11569: ,Okc_K_Lines_B CL
11570: WHERE HD.Id = Cx_Chr_Id
11571: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11633: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11634: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11635: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11636: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11637: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11638: ,Okc_K_Lines_B SV
11639: ,Okc_K_Lines_B CL
11640: WHERE HD.Id = Cx_Chr_Id
11641: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11682: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11683: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11684: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11685: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11686: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11687: ,Okc_K_Lines_B SV
11688: ,Okc_K_Lines_B CL
11689: WHERE HD.Id = Cx_Chr_Id
11690: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') -------Modified condition for ER9681794
11752: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11753: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11754: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11755: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11756: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11757: ,Okc_K_Lines_B SV
11758: ,Okc_K_Lines_B CL
11759: WHERE HD.Id = Cx_Chr_Id
11760: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11802: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11803: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11804: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11805: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11806: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11807: ,Okc_K_Lines_B SV
11808: ,Okc_K_Lines_B CL
11809: WHERE HD.Id = Cx_Chr_Id
11810: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
11872: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11873: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11874: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11875: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11876: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11877: ,Okc_K_Lines_B SV
11878: ,Okc_K_Lines_B CL
11879: WHERE HD.Id = Cx_Chr_Id
11880: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
11921: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11922: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11923: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11924: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11925: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11926: ,Okc_K_Lines_B SV
11927: ,Okc_K_Lines_B CL
11928: WHERE HD.Id = Cx_Chr_Id
11929: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
13628: ,HB.Start_Date Contract_Start_Date
13629: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
13630: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
13631: FROM Okc_K_Headers_TL HT
13632: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
13633: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
13634: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
13635: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13636: AND (Cv_Con_Cusomer_Id IS NULL
13675: ,HB.Start_Date Contract_Start_Date
13676: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
13677: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
13678: FROM Okc_K_Headers_TL HT
13679: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
13680: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
13681: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
13682: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
13683: AND (Cv_Con_Cusomer_Id IS NULL
14387: -- cvt.meaning,
14388: -- cvt.importance_level,
14389: -- okh.estimated_amount,
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,
14420: cvt.meaning,
14421: cvt.importance_level,
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,
14453: -- covtyp.meaning,
14454: -- covtyp.importance_level importance_level,
14455: -- okh.estimated_amount,
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,
14488: covtyp.meaning,
14489: covtyp.importance_level importance_level,
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,
16503: CURSOR cur_hdr (p_line_id in number) is
16504: select hdr.id id,
16505: hdr.start_date start_date,
16506: hdr.end_date end_date
16507: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
16508: okc_k_lines_v lines
16509: where lines.chr_id = hdr.id
16510: and lines.dnz_chr_id = hdr.id
16511: and lines.id = p_line_id;
16831: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
16832: ,HD.currency_code HD_currency_code
16833: ,CAT.meaning HD_cat_meaning
16834: ,STS.meaning HD_sts_meaning
16835: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16836: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16837: ,Okc_K_Lines_B SV
16838: ,Okc_K_Lines_B CL
16839: ,okc_subclasses_v CAT
16907: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
16908: ,HD.currency_code HD_currency_code
16909: ,CAT.meaning HD_cat_meaning
16910: ,STS.meaning HD_sts_meaning
16911: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16912: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16913: ,Okc_K_Lines_B SV
16914: ,Okc_K_Lines_B CL
16915: ,okc_subclasses_v CAT
16972: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
16973: ,HD.currency_code HD_currency_code
16974: ,CAT.meaning HD_cat_meaning
16975: ,STS.meaning HD_sts_meaning
16976: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16977: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16978: ,okc_subclasses_v CAT
16979: ,okc_statuses_v STS
16980: WHERE HD.Id = Cx_Chr_Id -- Modified for Bug#13840327
17026: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
17027: ,HD.currency_code HD_currency_code
17028: ,CAT.meaning HD_cat_meaning
17029: ,STS.meaning HD_sts_meaning
17030: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
17031: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
17032: ,okc_subclasses_v CAT
17033: ,okc_statuses_v STS
17034: WHERE HD.Id = nvl(Cx_Chr_Id,HD.Id)
17082: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
17083: ,HD.currency_code HD_currency_code
17084: ,CAT.meaning HD_cat_meaning
17085: ,STS.meaning HD_sts_meaning
17086: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
17087: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
17088: ,okc_subclasses_v CAT
17089: ,okc_statuses_v STS
17090: WHERE HD.Scs_Code IN ('SERVICE','WARRANTY')
18095: IS
18096:
18097: CURSOR KHDR_Date IS
18098: select end_date
18099: from OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B -- Modified for 12.0 MOAC project (JVARGHES)
18100: where id = p_contract_id;
18101:
18102: Lx_CHR_Id CONSTANT Gx_OKS_Id := p_contract_id;
18103:
18394: k NUMBER;
18395:
18396: CURSOR CUR_GET_ORG_ID(l_contract_line_id IN NUMBER) IS
18397: SELECT hdr.AUTHORING_ORG_ID, hdr.INV_ORGANIZATION_ID
18398: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines
18399: WHERE lines.id = l_contract_line_id
18400: AND lines.chr_id = hdr.id ;
18401:
18402:
19244: Cv_contract_grp_id in number) IS
19245: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19246: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19247: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19248: FROM OKC_K_HEADERS_ALL_B B, --Okc_K_Headers_B B, /*Bug:6767455*/
19249: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19250: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
19251: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
19252: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
19272: /*Bug:6767455*/
19273: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19274: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19275: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19276: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project /*Bug:6767455*/
19277: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19278: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
19279: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
19280: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To
19298: SELECT /*+ leading(b) use_nl(b oksb) */
19299: b.Id Id, -- 11.5.10 rule rearchitecture changes
19300: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
19301: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
19302: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19303: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19304: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
19305: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19306: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))
19381: SELECT /*+ leading(b) use_nl(b oksb) */
19382: b.Id Id, -- 11.5.10 rule rearchitecture changes
19383: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
19384: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
19385: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19386: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19387: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
19388: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19389: AND ( (Cv_Contract_Num_Modifier IS NULL)
19432: Cv_contract_grp_id in number) IS
19433: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19434: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19435: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19436: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19437: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19438: Okc_K_Party_Roles_B PR
19439: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19440: AND PR.Object1_Id2 = '#'
19475: Cv_contract_grp_id in number) IS
19476: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19477: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19478: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19479: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19480: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19481: Okc_K_Party_Roles_B PR
19482: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19483: AND PR.Object1_Id2 = '#'
19518: Cv_contract_grp_id in number) IS
19519: SELECT /*+ leading(grpng) use_nl(grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19520: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19521: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19522: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19523: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
19524: Okc_K_grpings grpng
19525: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
19526: AND B.ID = grpng.included_chr_id
19559: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19560:
19561: FROM Okc_K_Party_Roles_B PR,
19562: Okc_K_grpings grpng,
19563: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19564: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19565:
19566: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19567: AND PR.Object1_Id2 = '#'
19606: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19607:
19608: FROM Okc_K_Party_Roles_B PR,
19609: Okc_K_grpings grpng,
19610: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19611: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19612:
19613: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
19614: AND PR.Object1_Id2 = '#'
19652: Cv_contract_grp_id in number) IS
19653: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19654: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19655: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19656: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19657: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19658: WHERE Contract_Number = Cv_Contract_Num
19659: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
19660: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier
19716: Cv_contract_grp_id in number) IS
19717: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19718: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19719: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19720: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19721: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19722: WHERE Contract_Number = Cv_Contract_Num
19723: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
19724: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier
19780: Cv_contract_grp_id in number) IS
19781: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19782: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19783: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19784: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19785: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19786: WHERE Contract_Number = Cv_Contract_Num
19787: /*and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
19788: AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))*/
19856: Cv_contract_grp_id in number) IS
19857: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
19858: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
19859: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
19860: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
19861: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
19862: WHERE Contract_Number = Cv_Contract_Num
19863: and b.id = oksb.chr_id
19864: AND B.Start_Date >= NVL(trunc(Cv_Start_Date_From),B.Start_Date)
20712: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
20713: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
20714: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
20715: Sv.Lse_Id Service_Lse_Id
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,
20802: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
20803: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
20804: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,
20891: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
20892: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
20893: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,
20975: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
20976: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
20977: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,
21050: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
21051: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
21052: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,
21120: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
21121: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
21122: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
21123: Sv.Lse_Id Service_Lse_Id
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,
21207: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
21208: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
21209: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
21210: Sv.Lse_Id Service_Lse_Id
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,