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 6644: ,ksl.Standard_Cov_YN Standard_Cov_YN

6640: ,con.primary_yn
6641: ,con.resource_class
6642: ,bpl.start_date bpl_start_date
6643: ,bpl.end_date bpl_end_date
6644: ,ksl.Standard_Cov_YN Standard_Cov_YN
6645: ,bpl.id bpl_id
6646: ,ksl.dnz_chr_id ksl_dnz_chr_id
6647:
6648: FROM JTF_RS_RESOURCE_EXTNS RSC --OKX_Resources_V RSC

Line 6676: ,ksl.Standard_Cov_YN Standard_Cov_YN

6672: ,con.primary_yn
6673: ,con.resource_class
6674: ,bpl.start_date bpl_start_date
6675: ,bpl.end_date bpl_end_date
6676: ,ksl.Standard_Cov_YN Standard_Cov_YN
6677: ,bpl.id bpl_id
6678: ,ksl.dnz_chr_id ksl_dnz_chr_id
6679:
6680: FROM OKS_Resource_Groups_V RSG

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

6798: --
6799: -- Added for 12.0 Coverage Rearch project (JVARGHES)
6800: --
6801:
6802: IF Idx.Standard_Cov_YN = 'Y' THEN
6803:
6804: Get_BP_Line_Start_Offset
6805: (P_BPL_Id => Idx.BPL_Id
6806: ,P_SVL_Start => Ld_SVL_Start

Line 9841: ,KSL.Standard_COV_YN

9837: ,COV.Item_Description
9838: ,COV.Start_Date
9839: ,Get_End_Date_Time(COV.End_Date) End_Date
9840: ,Get_End_Date_Time(COV.Date_Terminated) Date_Terminated
9841: ,KSL.Standard_COV_YN
9842: ,SVL.Start_Date
9843: ,Get_End_Date_Time(SVL.End_Date) End_Date
9844: ,Get_End_Date_Time(SVL.Date_Terminated) Date_Terminated
9845: FROM Okc_K_Lines_B SVL

Line 14468: ,KSL.Standard_Cov_YN

14464: ,CVL.Id Coverage_Line_Id
14465: ,CVL.Start_Date CV_Start_Date
14466: ,Get_End_Date_Time(CVL.End_Date) Cv_End_Date
14467: ,Get_End_Date_Time(CVL.Date_Terminated) CV_Date_Terminated
14468: ,KSL.Standard_Cov_YN
14469: FROM OKS_K_LINES_B KSL
14470: ,Okc_K_Lines_V CVL
14471: WHERE KSL.Cle_Id = Cx_SrvLine_Id
14472: AND KSL.Coverage_Id = CVL.Id

Line 14590: Lv_Standard_Cov_YN VARCHAR2(10);

14586: --
14587: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
14588: --
14589:
14590: Lv_Standard_Cov_YN VARCHAR2(10);
14591:
14592: --
14593:
14594: BEGIN

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

14638: --
14639:
14640: OPEN Lx_Csr_CovItem(Lx_Contracts.Service_Line_Id);
14641: FETCH Lx_Csr_CovItem INTO Lv_Cov_Name,Lv_Cov_Description,Lx_CovLine_Id
14642: ,Ld_Cov_StDate,Ld_Cov_EdDate,Ld_Cov_TnDate, Lv_Standard_Cov_YN;
14643:
14644: --
14645: --
14646:

Line 14659: IF Lv_Standard_Cov_YN = 'Y'

14655: --
14656: -- Added for 12.0 Coverage Rearch project (JVARGHES)
14657: --
14658:
14659: IF Lv_Standard_Cov_YN = 'Y'
14660: THEN
14661: Ld_Cov_StDate := Lx_Contracts.Sv_Start_Date;
14662: Ld_Cov_EdDate := Lx_Contracts.Sv_End_Date;
14663: Ld_Cov_TnDate := Lx_Contracts.SV_Date_Terminated;

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

15061: --
15062: CURSOR cur_bp (p_line_id in number,p_chk_def in varchar2,p_sr_enabled varchar2
15063: ,p_dr_enabled IN varchar2,p_fs_enabled IN varchar2) is
15064: select lines2.id id,
15065: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
15066: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
15067: to_number(items.object1_id1) object1_id1,
15068: lines.dnz_chr_id,
15069: ksl.Standard_Cov_YN Standard_Cov_YN

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

15062: CURSOR cur_bp (p_line_id in number,p_chk_def in varchar2,p_sr_enabled varchar2
15063: ,p_dr_enabled IN varchar2,p_fs_enabled IN varchar2) is
15064: select lines2.id id,
15065: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
15066: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
15067: to_number(items.object1_id1) object1_id1,
15068: lines.dnz_chr_id,
15069: ksl.Standard_Cov_YN Standard_Cov_YN
15070: from okc_k_lines_b lines,

Line 15069: ksl.Standard_Cov_YN Standard_Cov_YN

15065: decode(ksl.Standard_Cov_YN, 'Y',lines.start_date,lines2.start_date) start_date,
15066: decode(ksl.Standard_Cov_YN, 'Y',lines.end_date,lines2.end_date) end_date,
15067: to_number(items.object1_id1) object1_id1,
15068: lines.dnz_chr_id,
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,

Line 15156: IF l_bp_out.Standard_Cov_YN = 'Y'

15152: --
15153: -- Modified for 12.0 Coverage Rearch project (JVARGHES)
15154: --
15155:
15156: IF l_bp_out.Standard_Cov_YN = 'Y'
15157: THEN
15158:
15159: Get_BP_Line_Start_Offset
15160: (P_BPL_Id => l_bp_out.Id

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

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

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

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
16604: FROM OKC_K_LINES_B lines1,
16605: OKS_K_LINES_B KSL,

Line 16603: , ksl.Standard_Cov_YN Standard_Cov_YN

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
16604: FROM OKC_K_LINES_B lines1,
16605: OKS_K_LINES_B KSL,
16606: OKC_K_LINES_B lines3,
16607: OKC_K_ITEMS items

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

16683:
16684: FOR bp_rec IN CUR_GET_BP(p_contract_line_id => l_contract_line_id)
16685: LOOP
16686:
16687: IF bp_rec.Standard_Cov_YN = 'Y' THEN
16688:
16689: Get_BP_Line_Start_Offset
16690: (P_BPL_Id => bp_rec.BPL_Id
16691: ,P_SVL_Start => bp_rec.start_date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

18683:
18684: /* trunc(Cov.Start_Date) Cov_Start_Date,
18685: trunc(Cov.End_Date) Cov_End_Date,
18686: trunc(Cov.Date_Terminated) Cov_Date_Terminated,*/ /*bug 7412576*/
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,

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

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

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

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

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

18764: SYS.concatenated_segments Name,
18765: cov.id cov_line_id,
18766: Cov.Name Cov_Name,
18767: --- truncating the dates to remove accidental existence of time components in dates.
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)

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

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

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

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

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

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

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

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

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

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