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