[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 |