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 STANDARD

Line 429: ,KSL.Standard_Cov_YN

425: SELECT SVL.Start_Date
426: ,Get_End_Date_Time(SVL.End_Date) End_Date
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

Line 7032: ,ksl.Standard_Cov_YN Standard_Cov_YN

7028: ,con.primary_yn
7029: ,con.resource_class
7030: ,bpl.start_date bpl_start_date
7031: ,bpl.end_date bpl_end_date
7032: ,ksl.Standard_Cov_YN Standard_Cov_YN
7033: ,bpl.id bpl_id
7034: ,ksl.dnz_chr_id ksl_dnz_chr_id
7035:
7036: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

Line 7064: ,ksl.Standard_Cov_YN Standard_Cov_YN

7060: ,con.primary_yn
7061: ,con.resource_class
7062: ,bpl.start_date bpl_start_date
7063: ,bpl.end_date bpl_end_date
7064: ,ksl.Standard_Cov_YN Standard_Cov_YN
7065: ,bpl.id bpl_id
7066: ,ksl.dnz_chr_id ksl_dnz_chr_id
7067:
7068: FROM OKS_Resource_Groups_V RSG

Line 7190: IF Idx.Standard_Cov_YN = 'Y' THEN

7186: --
7187: -- Added for 12.0 Coverage Rearch project (JVARGHES)
7188: --
7189:
7190: IF Idx.Standard_Cov_YN = 'Y' THEN
7191:
7192: Get_BP_Line_Start_Offset
7193: (P_BPL_Id => Idx.BPL_Id
7194: ,P_SVL_Start => Ld_SVL_Start

Line 10272: ,KSL.Standard_COV_YN

10268: ,COV.Item_Description
10269: ,COV.Start_Date
10270: ,Get_End_Date_Time(COV.End_Date) End_Date
10271: ,Get_End_Date_Time(COV.Date_Terminated) Date_Terminated
10272: ,KSL.Standard_COV_YN
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

Line 15830: ,KSL.Standard_Cov_YN

15826: ,CVL.Id Coverage_Line_Id
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

Line 15957: Lv_Standard_Cov_YN VARCHAR2(10);

15953: --
15954: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
15955: --
15956:
15957: Lv_Standard_Cov_YN VARCHAR2(10);
15958:
15959: --
15960:
15961: BEGIN

Line 16009: ,Ld_Cov_StDate,Ld_Cov_EdDate,Ld_Cov_TnDate, Lv_Standard_Cov_YN;

16005: --
16006:
16007: OPEN Lx_Csr_CovItem(Lx_Contracts.Service_Line_Id);
16008: FETCH Lx_Csr_CovItem INTO Lv_Cov_Name,Lv_Cov_Description,Lx_CovLine_Id
16009: ,Ld_Cov_StDate,Ld_Cov_EdDate,Ld_Cov_TnDate, Lv_Standard_Cov_YN;
16010:
16011: --
16012: --
16013:

Line 16026: IF Lv_Standard_Cov_YN = 'Y'

16022: --
16023: -- Added for 12.0 Coverage Rearch project (JVARGHES)
16024: --
16025:
16026: IF Lv_Standard_Cov_YN = 'Y'
16027: THEN
16028: Ld_Cov_StDate := Lx_Contracts.Sv_Start_Date;
16029: Ld_Cov_EdDate := Lx_Contracts.Sv_End_Date;
16030: Ld_Cov_TnDate := Lx_Contracts.SV_Date_Terminated;

Line 16468: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,

16464: --
16465: CURSOR cur_bp (p_line_id in number,p_chk_def in varchar2,p_sr_enabled varchar2
16466: ,p_dr_enabled IN varchar2,p_fs_enabled IN varchar2) is
16467: select lines2.id id,
16468: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
16469: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
16470: to_number(items.object1_id1) object1_id1,
16471: lines.dnz_chr_id,
16472: ksl.Standard_Cov_YN Standard_Cov_YN

Line 16469: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,

16465: CURSOR cur_bp (p_line_id in number,p_chk_def in varchar2,p_sr_enabled varchar2
16466: ,p_dr_enabled IN varchar2,p_fs_enabled IN varchar2) is
16467: select lines2.id id,
16468: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
16469: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
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,

Line 16472: ksl.Standard_Cov_YN Standard_Cov_YN

16468: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
16469: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
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,

Line 16559: IF l_bp_out.Standard_Cov_YN = 'Y'

16555: --
16556: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
16557: --
16558:
16559: IF l_bp_out.Standard_Cov_YN = 'Y'
16560: THEN
16561:
16562: Get_BP_Line_Start_Offset
16563: (P_BPL_Id => l_bp_out.Id

Line 18444: decode(KSL.Standard_Cov_YN,'Y', lines1.start_date,lines3.start_date) start_date

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
18448: FROM OKC_K_LINES_B lines1,

Line 18445: ,decode(KSL.Standard_Cov_YN,'Y', lines1.end_date,lines3.end_date) end_date

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
18448: FROM OKC_K_LINES_B lines1,
18449: OKS_K_LINES_B KSL,

Line 18447: , ksl.Standard_Cov_YN Standard_Cov_YN

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
18448: FROM OKC_K_LINES_B lines1,
18449: OKS_K_LINES_B KSL,
18450: OKC_K_LINES_B lines3,
18451: OKC_K_ITEMS items

Line 18531: IF bp_rec.Standard_Cov_YN = 'Y' THEN

18527:
18528: FOR bp_rec IN CUR_GET_BP(p_contract_line_id => l_contract_line_id)
18529: LOOP
18530:
18531: IF bp_rec.Standard_Cov_YN = 'Y' THEN
18532:
18533: Get_BP_Line_Start_Offset
18534: (P_BPL_Id => bp_rec.BPL_Id
18535: ,P_SVL_Start => bp_rec.start_date

Line 20712: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

20708: --- truncating the dates to remove accidental existence of time components in dates.
20709: /*trunc(Cov.Start_Date) Cov_Start_Date,
20710: trunc(Cov.End_Date) Cov_End_Date,
20711: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 20713: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

20709: /*trunc(Cov.Start_Date) Cov_Start_Date,
20710: trunc(Cov.End_Date) Cov_End_Date,
20711: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,*/

Line 20714: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

20710: trunc(Cov.End_Date) Cov_End_Date,
20711: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 20802: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

20798: trunc(Clv.Date_Terminated) Item_Date_Terminated,
20799: cov.id cov_line_id,
20800: Cov.Name Cov_Name,
20801: --- truncating the dates to remove accidental existence of time components in dates.
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)

Line 20803: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

20799: cov.id cov_line_id,
20800: Cov.Name Cov_Name,
20801: --- truncating the dates to remove accidental existence of time components in dates.
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)

Line 20804: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

20800: Cov.Name Cov_Name,
20801: --- truncating the dates to remove accidental existence of time components in dates.
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,

Line 20891: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

20887: --- truncating the dates to remove accidental existence of time components in dates.
20888: /*trunc(Cov.Start_Date) Cov_Start_Date,
20889: trunc(Cov.End_Date) Cov_End_Date,
20890: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 20892: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

20888: /*trunc(Cov.Start_Date) Cov_Start_Date,
20889: trunc(Cov.End_Date) Cov_End_Date,
20890: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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*/

Line 20893: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

20889: trunc(Cov.End_Date) Cov_End_Date,
20890: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 20975: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

20971:
20972: /* trunc(Cov.Start_Date) Cov_Start_Date,
20973: trunc(Cov.End_Date) Cov_End_Date,
20974: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 20976: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

20972: /* trunc(Cov.Start_Date) Cov_Start_Date,
20973: trunc(Cov.End_Date) Cov_End_Date,
20974: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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*/

Line 20977: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

20973: trunc(Cov.End_Date) Cov_End_Date,
20974: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 21050: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

21046: COVTL.NAME COV_NAME,
21047: /* trunc(Cov.Start_Date) Cov_Start_Date,
21048: trunc(Cov.End_Date) Cov_End_Date,
21049: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/
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*/

Line 21051: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

21047: /* trunc(Cov.Start_Date) Cov_Start_Date,
21048: trunc(Cov.End_Date) Cov_End_Date,
21049: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/
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,

Line 21052: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

21048: trunc(Cov.End_Date) Cov_End_Date,
21049: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/
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,

Line 21120: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

21116: SYS.concatenated_segments Name,
21117: cov.id cov_line_id,
21118: Cov.Name Cov_Name,
21119: --- truncating the dates to remove accidental existence of time components in dates.
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)

Line 21121: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

21117: cov.id cov_line_id,
21118: Cov.Name Cov_Name,
21119: --- truncating the dates to remove accidental existence of time components in dates.
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)

Line 21122: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

21118: Cov.Name Cov_Name,
21119: --- truncating the dates to remove accidental existence of time components in dates.
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,

Line 21207: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Start_Date,Cov.Start_Date)) Cov_Start_Date,

21203: --- truncating the dates to remove accidental existence of time components in dates.
21204: /*trunc(Cov.Start_Date) Cov_Start_Date,
21205: trunc(Cov.End_Date) Cov_End_Date,
21206: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

Line 21208: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.END_Date,Cov.END_Date)) Cov_END_Date,

21204: /*trunc(Cov.Start_Date) Cov_Start_Date,
21205: trunc(Cov.End_Date) Cov_End_Date,
21206: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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*/

Line 21209: trunc(DECODE(KSL.Standard_Cov_YN,'Y',SV.Date_Terminated,Cov.Date_Terminated)) Cov_Date_Terminated,

21205: trunc(Cov.End_Date) Cov_End_Date,
21206: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,