[Home] [Help]
118: , p_cust_id IN NUMBER
119: , p_date IN DATE
120: ) IS
121: SELECT a.resale_header_id
122: FROM ozf_resale_headers a
123: , ozf_resale_lines_int b
124: , ozf_resale_lines c
125: WHERE b.resale_batch_id = p_id
126: AND b.order_number = p_order_number