DBA Data[Home] [Help]

APPS.OKS_PM_ENTITLEMENTS_PVT dependencies on OKC_K_ITEMS

Line 91: FROM Okc_K_Items ITM

87: AND PR.Rle_Code <> 'VENDOR'))
88: AND (Cx_BP_Id IS NULL
89: OR
90: EXISTS (SELECT '*'
91: FROM Okc_K_Items ITM
92: ,Okc_K_Lines_B BPL
93: ,Okc_K_Lines_B CV
94: WHERE CV.Cle_Id = SV.Id
95: AND CV.Lse_Id IN (2,15,20)

Line 160: FROM Okc_K_Items ITM

156: AND PR.Rle_Code <> 'VENDOR'))
157: AND (Cx_BP_Id IS NULL
158: OR
159: EXISTS (SELECT '*'
160: FROM Okc_K_Items ITM
161: ,Okc_K_Lines_B BPL
162: WHERE BPL.Cle_Id = OKSSRV.Coverage_ID
163: AND BPL.Lse_Id IN (3,16,21)
164: AND ITM.Cle_Id = BPL.Id