Scripts For Oracle Quote and Order Relation

--quote,order relationshipSELECT a.quote_header_id, a.quote_number, a.order_id, b.order_number,b
.header_id, c.line_id, e.quote_line_id, e.line_number, f.shipment_idFROM aso_quote_headers_all a,oe_order_headers_all b,oe_order_lines_all c,aso_quote_lines_all e,aso_shipments f


WHERE a.order_id = b.header_idAND a.order_id = c.header_idAND b.header_id = c.header_idAND a.quote_header_id = e.quote_header_idAND a.quote_header_id = f.quote_header_idAND e.quote_line_id = f.quote_line_idAND f.order_line_id = c.line_id-- and a.quote_number = &QuoteNo;--if no shipment details
--(if no Shipment details):/* Formatted on 2011/10/10 20:00 (Formatter Plus v4.8.8) */SELECT a.quote_header_id, a.quote_number, a.order_id, b.order_number,b
.header_id, c.line_id, e.quote_line_id, e.line_numberFROM aso_quote_headers_all a,oe_order_headers_all b,oe_order_lines_all c,aso_quote_lines_all e



WHERE a.order_id = b.header_idAND a.order_id = c.header_idAND b.header_id = c.header_idAND a.quote_header_id = e.quote_header_idAND rownum<5-- and a.quote_number = &QuoteNo; order by 1

Comments

  1. Please change the background colour..it is readable with this background

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle APPS Useful Queries

How to Apply Timers In Forms

Unix Shell Script For Oracle Apps