DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_STATUSES_B

Line 178: OKC_STATUSES_B sts

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

Line 192: OKC_STATUSES_B sts

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

Line 216: OKC_STATUSES_B sts

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

Line 244: OKC_STATUSES_B sts

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