APPS.OKC_PO_QA_PVT dependencies on OKC_K_LINES_B

Line 118: FROM OKC_K_LINES_b oklb

114: CURSOR l_oklb_csr IS
115: SELECT oklb.item_to_price_yn item_priced,
116: oklb.price_level_ind priced,
117: oklb.price_negotiated net_price
118: FROM OKC_K_LINES_b oklb
119: WHERE oklb.dnz_chr_id = p_chr_id
120: AND oklb.cle_id IS NULL;
121: l_oklb_rec l_oklb_csr%ROWTYPE;
122:

Line 127: FROM OKC_K_LINES_b oklb,

123:
124: CURSOR l_oki_csr IS
125: SELECT oki.number_of_items qty,
126: oki.uom_code UOM_CODE
127: FROM OKC_K_LINES_b oklb,
128: OKC_K_ITEMS oki
129: WHERE oklb.dnz_chr_id = oki.dnz_chr_id
130: AND oklb.cle_id IS NULL
131: AND oklb.dnz_chr_id = p_chr_id;

Line 188: FROM OKC_K_LINES_B oklb

184: IF (x_return_status<>OKC_API.G_RET_STS_ERROR) THEN
185:
186: SELECT 1 /*+ FIRST_ROWS */
187: INTO l_nlines
188: FROM OKC_K_LINES_B oklb
189: WHERE oklb.dnz_chr_id = p_chr_id
190: and rownum<2;
191:
192: END IF;