APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_LINE_STYLES_B

Line 186: OKC_LINE_STYLES_B B

182:
183: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
184: SELECT A.ID
185: FROM OKC_K_LINES_V A,
186: OKC_LINE_STYLES_B B
187: WHERE A.CLE_ID = p_parent_line_id
188: AND A.LSE_ID = B.ID
189: AND B.LTY_CODE = 'FREE_FORM2';
190:

Line 195: OKC_LINE_STYLES_B B

191: CURSOR c_inst_item(p_line_id IN NUMBER) IS
192: SELECT A.ID,
193: A.DNZ_CHR_ID
194: FROM OKC_K_LINES_V A,
195: OKC_LINE_STYLES_B B
196: WHERE A.CLE_ID = p_line_id
197: AND A.LSE_ID = B.ID
198: AND B.LTY_CODE = 'INST_ITEM';
199:

Line 279: okc_line_styles_b style,

275:
276: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
277: SELECT mtl.serial_number_control_code
278: FROM okc_k_lines_b line,
279: okc_line_styles_b style,
280: okc_k_items kitem,
281: mtl_system_items mtl
282: WHERE line.lse_id = style.id
283: AND style.lty_code = 'ITEM'

Line 1760: OKC_LINE_STYLES_B B,

1756:
1757: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
1758: SELECT A.ID, K.org_id
1759: FROM OKC_K_LINES_V A,
1760: OKC_LINE_STYLES_B B,
1761: okc_k_headers_all_b K
1762: WHERE A.CLE_ID = p_parent_line_id
1763: AND A.LSE_ID = B.ID
1764: AND B.LTY_CODE = 'FREE_FORM2'

Line 1771: OKC_LINE_STYLES_B B

1767: CURSOR c_inst_item(p_line_id IN NUMBER) IS
1768: SELECT A.ID,
1769: A.DNZ_CHR_ID
1770: FROM OKC_K_LINES_V A,
1771: OKC_LINE_STYLES_B B
1772: WHERE A.CLE_ID = p_line_id
1773: AND A.LSE_ID = B.ID
1774: AND B.LTY_CODE = 'INST_ITEM';
1775: