DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_K_HEADERS_TL

Line 5367: ,OKC_K_HEADERS_TL HDT

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

Line 12380: FROM Okc_K_Headers_TL HT

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

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

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

Line 18429: OKC_K_HEADERS_TL HDT, /*bug 7412576 OKC_K_HEADERS_V HD,*/

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

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

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

Line 18608: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/

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

Line 18692: OKC_K_HEADERS_TL HDT,/*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/

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

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

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

Line 18860: OKC_K_HEADERS_TL HDT, /*OKC_K_HEADERS_V HD,*/ /*bug 7412576*/

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