DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_STATUSES_B

Line 180: OKC_STATUSES_B sts

176: sub_kle.price_negotiated amount
177: FROM OKC_K_LINES_B cle,
178: OKC_K_LINES_B sub_kle,
179: OKC_LINE_STYLES_B ls,
180: OKC_STATUSES_B sts
181: WHERE cle.lse_id = ls.id
182: AND ls.lty_code = ltycode
183: AND cle.dnz_chr_id = chrid
184: AND sts.code = cle.sts_code

Line 194: OKC_STATUSES_B sts

190: SELECT cle.id,
191: cle.price_negotiated amount
192: FROM OKC_K_LINES_B cle,
193: OKC_LINE_STYLES_B ls,
194: OKC_STATUSES_B sts
195: WHERE cle.lse_id = ls.id
196: AND ls.lty_code = ltycode
197: AND cle.dnz_chr_id = chrid
198: AND sts.code = cle.sts_code

Line 218: OKC_STATUSES_B sts

214: sub_kle.line_number
215: FROM OKL_K_LINES_FULL_V kle,
216: OKL_K_LINES_FULL_V sub_kle,
217: OKC_LINE_STYLES_B ls,
218: OKC_STATUSES_B sts
219: WHERE kle.lse_id = ls.id
220: AND ls.lty_code = ltycode
221: AND kle.dnz_chr_id = chrid
222: AND sts.code = kle.sts_code

Line 246: OKC_STATUSES_B sts

242: --Bug# 4631549
243: kle.expected_asset_cost
244: FROM OKL_K_LINES_FULL_V kle,
245: OKC_LINE_STYLES_B ls,
246: OKC_STATUSES_B sts
247: WHERE kle.lse_id = ls.id
248: AND ls.lty_code = ltycode
249: AND kle.dnz_chr_id = chrid
250: AND sts.code = kle.sts_code