[Home] [Help]
186: , p_order_number IN VARCHAR2
187: , p_cust_id IN NUMBER
188: , p_date IN DATE ) IS
189: SELECT a.resale_header_id
190: FROM ozf_resale_headers a
191: , ozf_resale_lines_int b
192: , ozf_resale_lines c
193: WHERE b.resale_batch_id = p_id
194: AND b.order_number = p_order_number