DBA Data[Home] [Help]

APPS.OKL_AM_UTIL_PVT dependencies on OKC_LINE_STYLES_B

Line 228: okc_line_styles_b lse,

224: -- Get asset quantity
225: CURSOR l_quantity_csr (cp_cle_id NUMBER) IS
226: SELECT cim.number_of_items asset_quantity
227: FROM okc_k_lines_b cle,
228: okc_line_styles_b lse,
229: okc_k_items cim
230: WHERE cle.cle_id = cp_cle_id
231: AND lse.id = cle.lse_id
232: AND lse.lty_code = 'ITEM'

Line 4207: okc_line_styles_b lse

4203: fa_deprn_periods fdp,
4204: fa_book_controls fbc,
4205: okc_k_items itm,
4206: okc_k_lines_b kle,
4207: okc_line_styles_b lse
4208: where fdp.book_type_code = fds.book_type_code
4209: and fdp.period_counter - 1 = fds.period_counter
4210: and fdp.period_close_date is null
4211: and fbc.book_class = 'CORPORATE'

Line 4607: okc_line_styles_b lse

4603: fa_deprn_periods fdp,
4604: fa_book_controls fbc,
4605: okc_k_items itm,
4606: okc_k_lines_b kle,
4607: okc_line_styles_b lse
4608: WHERE fdp.book_type_code = fds.book_type_code
4609: AND fdp.period_counter - 1 = fds.period_counter
4610: AND fdp.period_close_date IS NULL
4611: AND fbc.book_class = 'CORPORATE'

Line 4989: okc_line_styles_b style,

4985:
4986: CURSOR check_item_csr (p_line_id IN NUMBER) IS -- p_line_id is FREE_FORM1
4987: SELECT mtl.serial_number_control_code
4988: FROM okc_k_lines_b line,
4989: okc_line_styles_b style,
4990: okc_k_items kitem,
4991: mtl_system_items mtl
4992: WHERE line.lse_id = style.id
4993: AND style.lty_code = 'ITEM'