324: SELECT
325: l.line_id
326: , l.line_number
327: FROM
328: oe_order_lines_all l
329: , ra_terms_b t
330: WHERE l.invoice_to_org_id = p_site_use_id
331: AND l.header_id = p_header_id
332: AND l.open_flag = 'Y'
344: SELECT
345: l.line_id
346: , l.line_number
347: FROM
348: oe_order_lines_all l
349: , ra_terms_b t
350: WHERE l.header_id = p_header_id
351: AND l.open_flag = 'Y'
352: AND l.booked_flag = 'Y'