APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_LINE_STYLES_B

Line 154: OKC_LINE_STYLES_B B

150:
151: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
152: SELECT A.ID
153: FROM OKC_K_LINES_V A,
154: OKC_LINE_STYLES_B B
155: WHERE A.CLE_ID = p_parent_line_id
156: AND A.LSE_ID = B.ID
157: AND B.LTY_CODE = 'FREE_FORM2';
158:

Line 163: OKC_LINE_STYLES_B B

159: CURSOR c_inst_item(p_line_id IN NUMBER) IS
160: SELECT A.ID,
161: A.DNZ_CHR_ID
162: FROM OKC_K_LINES_V A,
163: OKC_LINE_STYLES_B B
164: WHERE A.CLE_ID = p_line_id
165: AND A.LSE_ID = B.ID
166: AND B.LTY_CODE = 'INST_ITEM';
167:

Line 247: okc_line_styles_b style,

243:
244: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
245: SELECT mtl.serial_number_control_code
246: FROM okc_k_lines_b line,
247: okc_line_styles_b style,
248: okc_k_items kitem,
249: mtl_system_items mtl
250: WHERE line.lse_id = style.id
251: AND style.lty_code = 'ITEM'

Line 1728: OKC_LINE_STYLES_B B,

1724:
1725: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
1726: SELECT A.ID, K.org_id
1727: FROM OKC_K_LINES_V A,
1728: OKC_LINE_STYLES_B B,
1729: okc_k_headers_all_b K
1730: WHERE A.CLE_ID = p_parent_line_id
1731: AND A.LSE_ID = B.ID
1732: AND B.LTY_CODE = 'FREE_FORM2'

Line 1739: OKC_LINE_STYLES_B B

1735: CURSOR c_inst_item(p_line_id IN NUMBER) IS
1736: SELECT A.ID,
1737: A.DNZ_CHR_ID
1738: FROM OKC_K_LINES_V A,
1739: OKC_LINE_STYLES_B B
1740: WHERE A.CLE_ID = p_line_id
1741: AND A.LSE_ID = B.ID
1742: AND B.LTY_CODE = 'INST_ITEM';
1743: