[Home] [Help]
107: , p_cust_id IN NUMBER
108: , p_date IN DATE
109: ) IS
110: SELECT a.resale_header_id
111: FROM ozf_resale_headers a
112: , ozf_resale_lines_int b
113: , ozf_resale_lines c
114: WHERE b.resale_batch_id = p_id
115: AND b.order_number = p_order_number