[Home] [Help]
View: OE_BLKT_LINES_VSET_V
View Text
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
Columns
Name |
LINE_ID |
ORDER_NUMBER |
LINE_NUMBER |
ORDER_LINE_NUMBER |
SOLD_TO_ORG_ID |