[Home] [Help]
View: JAI_OM_WSH_DELIVERY_NAME_V
View Text
SELECT JOWLA.ORDER_HEADER_ID
, JOWLA.DELIVERY_ID
, JOWLA.CUSTOMER_ID
, WDD.SHIP_TO_LOCATION_ID
, JOWLA.VAT_INVOICE_NO
, JOWLA.EXCISE_INVOICE_NO
, JOWLA.GST_INVOICE_NO
, JOWLA.SHIPPABLE_FLAG
, JOWLA.ORG_ID
FROM JAI_OM_WSH_LINES_ALL JOWLA
, WSH_DELIVERY_DETAILS WDD
WHERE JOWLA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
Columns
Name |
ORDER_HEADER_ID |
DELIVERY_ID |
CUSTOMER_ID |
SHIP_TO_LOCATION_ID |
VAT_INVOICE_NO |
EXCISE_INVOICE_NO |
GST_INVOICE_NO |
SHIPPABLE_FLAG |
ORG_ID |