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_HEADERS_ALL_B

Line 5368: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

5364: ,OKSHDR.tax_status tax_status -- 11.5.10 changes
5365: ,HDR.conversion_type conversion_type -- 11.5.10 changes
5366: FROM OKC_K_PARTY_ROLES_B PTY
5367: ,OKC_K_HEADERS_TL HDT
5368: ,OKC_K_HEADERS_ALL_B HDR --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
5369: ,OKS_K_HEADERS_B OKSHDR -- 11.5.10 changes
5370: WHERE HDR.ID = NVL(Cx_Chr_Id,HDR.ID)
5371: AND HDR.END_DATE = NVL(Cd_Chr_EndDate,HDR.END_DATE)
5372: AND HDR.STS_CODE = NVL(Cx_Chr_Sts_Code,HDR.STS_CODE)

Line 5567: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

5563: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5564: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5565: ,OKSLIN.discount_list discount_list -- 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)

Line 5594: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

5590: ,LIN.bill_to_site_use_id bill_to_site_use_id -- 11.5.10 changes
5591: ,LIN.ship_to_site_use_id ship_to_site_use_id -- 11.5.10 changes
5592: ,OKSLIN.discount_list discount_list -- 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)

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 5840: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

5836: ,LIN.PRICE_NEGOTIATED
5837: ,STL.NAME
5838: ,HDR.AUTHORING_ORG_ID ORG_ID
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)

Line 5860: FROM OKC_K_HEADERS_ALL_B HDR -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

5856: ,LIN.PRICE_NEGOTIATED
5857: ,STL.NAME
5858: ,HDR.AUTHORING_ORG_ID ORG_ID
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)

Line 5921: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition

5917: Li_TableIdx := 0;
5918:
5919: /* Modified by Jvorugan for perg bug:4998337.
5920: If lx_cle_id is not null, then only passing the value.
5921: This is to avoid full table scan on okc_k_headers_all_b,okc_k_lines_b due to nvl condition
5922: */
5923:
5924: IF Lx_Cle_Id IS NULL
5925: THEN

Line 6977: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

6973: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
6974: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
6975: ,OKC_CONTACTS CO
6976: ,OKC_K_PARTY_ROLES_B PR
6977: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
6978: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
6979:
6980: -- Modified for 12.0 MOAC project (JVARGHES)
6981: AND HDR.ID = Cx_Chr_Id

Line 7027: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

7023: ,JTF_RS_SALESREPS S
7024: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7025: ,OKC_CONTACTS CO
7026: ,OKC_K_PARTY_ROLES_B PR
7027: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7028: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7029: AND co.dnz_chr_id = pr.dnz_chr_id
7030: AND CO.CPL_ID = PR.ID
7031: AND CO.OBJECT1_ID1 = S.SALESREP_ID --CS.ID1

Line 7059: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

7055: ,HDR.ORG_ID ORG_ID -- Modified for 12.0 MOAC project (JVARGHES)
7056: FROM JTF_RS_RESOURCE_EXTNS CS --OKX_RESOURCES_V CS
7057: ,OKC_CONTACTS CO
7058: ,OKC_K_PARTY_ROLES_B PR
7059: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7060: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7061: and PR.CLE_ID = Cx_Cle_Id
7062:
7063: -- Modified for 12.0 MOAC project (JVARGHES)

Line 7112: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

7108: ,JTF_RS_SALESREPS S
7109: ,JTF_RS_RESOURCE_EXTNS_TL TL -- Bug Fix #5442182 hmnair
7110: ,OKC_CONTACTS CO
7111: ,OKC_K_PARTY_ROLES_B PR
7112: ,OKC_K_HEADERS_ALL_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
7113: WHERE PR.DNZ_CHR_ID = Cx_Chr_Id
7114: and PR.CLE_ID = Cx_Cle_Id
7115: and co.dnz_chr_id = pr.dnz_chr_id
7116: AND CO.CPL_ID = PR.ID

Line 9632: FROM OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

9628: -- cursor modified to fix bug 3041443
9629:
9630: CURSOR Lx_Csr_Contracts(Cv_Contract_Num IN VARCHAR2, Cv_Contract_Num_Modifier IN VARCHAR2) IS
9631: SELECT Id
9632: FROM OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
9633: WHERE Contract_Number = Cv_Contract_Num
9634: --AND (Cv_Contract_Num_Modifier IS NULL OR Contract_Number_Modifier = Cv_Contract_Num_Modifier);
9635: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,-99)
9636: AND nvl(Contract_Number_Modifier,'#') = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,'#'));

Line 10158: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

10154: ,Get_End_Date_Time(CL.End_Date) End_Date
10155: ,Get_End_Date_Time(CL.Date_Terminated) Date_Terminated
10156: ,IT.Object1_Id1 Coverage_Level_Id
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

Line 10889: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

10885: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
10886: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10887: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10888: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10889: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10890: ,Okc_K_Lines_B SV
10891: ,Okc_K_Lines_B CL
10892: WHERE HD.Id = Cx_Chr_Id
10893: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 10958: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

10954: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
10955: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
10956: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
10957: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
10958: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
10959: ,Okc_K_Lines_B SV
10960: ,Okc_K_Lines_B CL
10961: WHERE HD.Id = Cx_Chr_Id
10962: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 11027: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

11023: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11024: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11025: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11026: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11027: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11028: ,Okc_K_Lines_B SV
11029: ,Okc_K_Lines_B CL
11030: WHERE HD.Id = Cx_Chr_Id
11031: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 11096: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

11092: ,Get_End_Date_Time(CL.End_Date) CL_End_Date
11093: ,Get_End_Date_Time(CL.Date_Terminated) CL_Date_Terminated
11094: -- ,DECODE(SV.Lse_Id,14,'Y','N') Warranty_Flag
11095: ,DECODE(SV.Lse_Id, 14, 'Y', 15, 'Y', 16, 'Y', 17, 'Y', 18, 'Y', 'N') Warranty_Flag
11096: FROM OKC_K_HEADERS_ALL_B HD -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
11097: ,Okc_K_Lines_B SV
11098: ,Okc_K_Lines_B CL
11099: WHERE HD.Id = Cx_Chr_Id
11100: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 12381: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)

12377: ,HB.Start_Date Contract_Start_Date
12378: ,Get_End_Date_Time(HB.End_Date) Contract_End_Date
12379: ,Get_End_Date_Time(HB.Date_Terminated) Contract_Terminated_Date
12380: FROM Okc_K_Headers_TL HT
12381: ,OKC_K_HEADERS_ALL_B HB -- OKC_K_HEADERS_B HB -- Modified for 12.0 MOAC project (JVARGHES)
12382: WHERE HB.Id = NVL(Cx_Chr_Id,HB.Id)
12383: AND HB.Contract_Number = NVL(Cv_Con_Number,HB.Contract_Number)
12384: AND (Cv_Con_Number_Modifier IS NULL OR HB.Contract_Number_Modifier = Cv_Con_Number_Modifier)
12385: AND (Cv_Con_Cusomer_Id IS NULL

Line 13033: -- from OKC_K_HEADERS_ALL_B okh,

13029: -- cvt.meaning,
13030: -- cvt.importance_level,
13031: -- okh.estimated_amount,
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,

Line 13066: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

13062: cvt.meaning,
13063: cvt.importance_level,
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,

Line 13099: -- from OKC_K_HEADERS_ALL_B okh,

13095: -- covtyp.meaning,
13096: -- covtyp.importance_level importance_level,
13097: -- okh.estimated_amount,
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,

Line 13134: from OKC_K_HEADERS_ALL_B okh, -- OKC_K_HEADERS_B okh -- Modified for 12.0 MOAC project (JVARGHES)

13130: covtyp.meaning,
13131: covtyp.importance_level importance_level,
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,

Line 15104: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)

15100: CURSOR cur_hdr (p_line_id in number) is
15101: select hdr.id id,
15102: hdr.start_date start_date,
15103: hdr.end_date end_date
15104: from OKC_K_HEADERS_ALL_B hdr, --,OKC_K_HEADERS_B HDR -- Modified for 12.0 MOAC project (JVARGHES)
15105: okc_k_lines_v lines
15106: where lines.chr_id = hdr.id
15107: and lines.dnz_chr_id = hdr.id
15108: and lines.id = p_line_id;

Line 15432: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)

15428: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
15429: ,HD.currency_code HD_currency_code
15430: ,CAT.meaning HD_cat_meaning
15431: ,STS.meaning HD_sts_meaning
15432: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
15433: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15434: ,Okc_K_Lines_B SV
15435: ,Okc_K_Lines_B CL
15436: ,okc_subclasses_v CAT

Line 15497: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)

15493: ,HDT.short_description short_description -- HD.short_description -- Modified for 12.0 MOAC project (JVARGHES)
15494: ,HD.currency_code HD_currency_code
15495: ,CAT.meaning HD_cat_meaning
15496: ,STS.meaning HD_sts_meaning
15497: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
15498: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15499: ,okc_subclasses_v CAT
15500: ,okc_statuses_v STS
15501: WHERE HD.Id = nvl(Cx_Chr_Id,HD.Id)

Line 16255: from OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B -- Modified for 12.0 MOAC project (JVARGHES)

16251: IS
16252:
16253: CURSOR KHDR_Date IS
16254: select end_date
16255: from OKC_K_HEADERS_ALL_B -- OKC_K_HEADERS_B -- Modified for 12.0 MOAC project (JVARGHES)
16256: where id = p_contract_id;
16257:
16258: Lx_CHR_Id CONSTANT Gx_OKS_Id := p_contract_id;
16259:

Line 16554: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines

16550: k NUMBER;
16551:
16552: CURSOR CUR_GET_ORG_ID(l_contract_line_id IN NUMBER) IS
16553: SELECT hdr.AUTHORING_ORG_ID, hdr.INV_ORGANIZATION_ID
16554: FROM OKC_K_HEADERS_ALL_B hdr, OKC_K_LINES_B lines
16555: WHERE lines.id = l_contract_line_id
16556: AND lines.chr_id = hdr.id ;
16557:
16558:

Line 17404: FROM OKC_K_HEADERS_ALL_B B, --Okc_K_Headers_B B, /Bug:6767455/

17400: Cv_contract_grp_id in number) IS
17401: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17402: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17403: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17404: FROM OKC_K_HEADERS_ALL_B B, --Okc_K_Headers_B B, /*Bug:6767455*/
17405: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17406: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
17407: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
17408: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To

Line 17432: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project /Bug:6767455/

17428: /*Bug:6767455*/
17429: SELECT /*+ leading(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17430: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17431: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17432: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project /*Bug:6767455*/
17433: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17434: WHERE b.id = oksb.chr_id -- 11.5.10 rule rearchitecture changes
17435: AND B.Start_Date BETWEEN Cv_Start_Date_From AND Cv_Start_Date_to
17436: AND B.End_Date BETWEEN Cv_End_Date_From AND Cv_End_Date_To

Line 17458: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17454: SELECT /*+ leading(b) use_nl(b oksb) */
17455: b.Id Id, -- 11.5.10 rule rearchitecture changes
17456: b.renewal_type_code, -- Added by Jvorugan for perf bug:4991724
17457: oksb.electronic_renewal_flag -- Added by Jvorugan for perf bug:4991724
17458: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17459: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17460: WHERE B.Id = Cv_Contract_Id --B.Id --nvl(Cv_Contract_Id,B.Id) /*Added for Bug:6767455*/
17461: and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
17462: --AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))

Line 17538: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17534: Cv_contract_grp_id in number) IS
17535: SELECT /*+ leading(pr) use_nl(pr b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17536: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17537: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17538: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17539: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17540: Okc_K_Party_Roles_B PR
17541: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
17542: AND PR.Object1_Id2 = '#'

Line 17581: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17577: Cv_contract_grp_id in number) IS
17578: SELECT /*+ leading(grpng) use_nl(grpng b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17579: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17580: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17581: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17582: oks_k_headers_b oksb, -- 11.5.10 rule rearchitecture changes
17583: Okc_K_grpings grpng
17584: WHERE grpng.cgp_parent_id = Cv_contract_grp_id
17585: AND B.ID = grpng.included_chr_id

Line 17622: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17618: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17619:
17620: FROM Okc_K_Party_Roles_B PR,
17621: Okc_K_grpings grpng,
17622: OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17623: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17624:
17625: WHERE PR.Object1_Id1 = TO_CHAR(Cv_Cont_Pty_Id)
17626: AND PR.Object1_Id2 = '#'

Line 17667: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17663: Cv_contract_grp_id in number) IS
17664: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17665: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17666: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17667: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17668: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17669: WHERE Contract_Number = Cv_Contract_Num
17670: -- AND ( (Cv_Contract_Num_Modifier IS NULL)
17671: AND Contract_Number_Modifier = Cv_Contract_Num_Modifier

Line 17730: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)

17726: Cv_contract_grp_id in number) IS
17727: SELECT /*+ leadin(b) use_nl(b oksb) */ b.Id Id, -- 11.5.10 rule rearchitecture changes
17728: b.renewal_type_code, -- Added by Jyothi for perf bug:4991724
17729: oksb.electronic_renewal_flag -- Added by Jyothi for perf bug:4991724
17730: FROM OKC_K_HEADERS_ALL_B B, -- OKC_K_HEADERS_B B -- Modified for 12.0 MOAC project (JVARGHES)
17731: oks_k_headers_b oksb -- 11.5.10 rule rearchitecture changes
17732: WHERE Contract_Number = Cv_Contract_Num
17733: /*and Contract_Number = nvl(Cv_Contract_Num,Contract_Number)
17734: AND nvl(Contract_Number_Modifier,-99) = nvl(Cv_Contract_Num_Modifier,nvl(Contract_Number_Modifier,-99))*/

Line 18428: FROM OKC_K_HEADERS_ALL_B HD,

18424: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18425: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18426: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18427: Sv.Lse_Id Service_Lse_Id
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,

Line 18518: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)

18514: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18515: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18516: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,

Line 18607: FROM OKC_K_HEADERS_ALL_B HD,

18603: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18604: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18605: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,

Line 18691: FROM OKC_K_HEADERS_ALL_B HD,

18687: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18688: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18689: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
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,

Line 18772: FROM OKC_K_HEADERS_ALL_B HD, -- Modified for 12.0 MOAC project (JVARGHES)

18768: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18769: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18770: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18771: Sv.Lse_Id Service_Lse_Id
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,

Line 18859: FROM OKC_K_HEADERS_ALL_B HD,

18855: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,
18856: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,
18857: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,
18858: Sv.Lse_Id Service_Lse_Id
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,