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_TL

Line 5755: ,OKC_K_HEADERS_TL HDT

5751: ,OKSHDR.tax_exemption_id tax_exemption_id -- 11.5.10 changes
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)

Line 13631: FROM Okc_K_Headers_TL HT

13627: ,HB.Sts_Code Contract_Status_Code
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)

Line 13678: FROM Okc_K_Headers_TL HT

13674: ,HB.Sts_Code Contract_Status_Code
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)

Line 16836: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- 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
16840: ,okc_statuses_v STS

Line 16912: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- 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
16916: ,okc_statuses_v STS

Line 16977: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- 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
16981: AND HD.Scs_Code IN ('SERVICE','WARRANTY')

Line 17031: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- 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)
17035: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ------Modified condition for ER9681794

Line 17087: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- 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')
17091: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)

Line 20717: OKC_K_HEADERS_TL HDT, /bug 7412576 OKC_K_HEADERS_V HD,/

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,
20721: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes

Line 20807: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)

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,
20811: oks_k_lines_B okscov, --11.5.10 rule rearchitecture changes

Line 20896: OKC_K_HEADERS_TL HDT, /OKC_K_HEADERS_V HD,/ /bug 7412576/

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,
20900: oks_k_lines_b okscov,--11.5.10 rule rearchitecture changes

Line 20980: OKC_K_HEADERS_TL HDT,/OKC_K_HEADERS_V HD,/ /bug 7412576/

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,
20984: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

Line 21055: OKC_K_HEADERS_TL HDT,

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,
21059: OKC_K_LINES_TL COVTL,

Line 21125: OKC_K_HEADERS_TL HDT, -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)

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,
21129: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes

Line 21212: OKC_K_HEADERS_TL HDT, /OKC_K_HEADERS_V HD,/ /bug 7412576/

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,
21216: oks_k_lines_b okscov, --11.5.10 rule rearchitecture changes