VIEW: APPS.OE_BLKT_LINES_VSET_V

Source

View Text - Preformatted

SELECT l.line_id ,h.order_number ,l.line_number ,h.order_number||'-'||l.line_number order_line_number ,h.sold_to_org_id FROM oe_blanket_headers_all h, oe_blanket_lines_all l WHERE h.header_id = l.header_id

View Text - HTML Formatted

SELECT L.LINE_ID
, H.ORDER_NUMBER
, L.LINE_NUMBER
, H.ORDER_NUMBER||'-'||L.LINE_NUMBER ORDER_LINE_NUMBER
, H.SOLD_TO_ORG_ID
FROM OE_BLANKET_HEADERS_ALL H
, OE_BLANKET_LINES_ALL L
WHERE H.HEADER_ID = L.HEADER_ID