VIEW: APPS.GML_OM_SHIP_DTL_VW

Source

View Text - Preformatted

SELECT w.delivery_id, wd.delivery_detail_id, wd.source_header_id, wd.source_line_id, wd.fob_code, wd.net_weight, wd.weight_uom_code, oh.order_number, ol.line_number, ol.shipping_quantity, ol.shipping_quantity_uom, ol.unit_selling_price, t.item_id, sum(t.trans_qty) ic_trans_qty, t.orgn_code, t.whse_code, t.trans_um, t.completed_ind, t.gl_posted_ind from wsh_new_deliveries w, wsh_delivery_assignments wa, wsh_delivery_details wd, oe_order_headers_all oh, oe_order_lines_all ol, ic_tran_pnd t WHERE w.delivery_id = wa.delivery_id and wa.delivery_detail_id = wd.delivery_detail_id and wd.source_code = 'OE' and wd.oe_interfaced_flag = 'Y' and wd.source_header_id = oh.header_id and wd.source_line_id = ol.line_id and wd.source_line_id = t.line_id and t.doc_type = 'OMSO' and t.completed_ind = 1 and t.gl_posted_ind = 1 and t.delete_mark = 0 group by w.delivery_id, wd.delivery_detail_id, wd.source_header_id, wd.source_line_id, wd.fob_code, wd.net_weight, wd.weight_uom_code, oh.order_number, ol.line_number, ol.shipping_quantity, ol.shipping_quantity_uom, ol.unit_selling_price, t.item_id, t.orgn_code, t.whse_code, t.trans_um, t.completed_ind, t.gl_posted_ind

View Text - HTML Formatted

SELECT W.DELIVERY_ID
, WD.DELIVERY_DETAIL_ID
, WD.SOURCE_HEADER_ID
, WD.SOURCE_LINE_ID
, WD.FOB_CODE
, WD.NET_WEIGHT
, WD.WEIGHT_UOM_CODE
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, OL.SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM
, OL.UNIT_SELLING_PRICE
, T.ITEM_ID
, SUM(T.TRANS_QTY) IC_TRANS_QTY
, T.ORGN_CODE
, T.WHSE_CODE
, T.TRANS_UM
, T.COMPLETED_IND
, T.GL_POSTED_IND
FROM WSH_NEW_DELIVERIES W
, WSH_DELIVERY_ASSIGNMENTS WA
, WSH_DELIVERY_DETAILS WD
, OE_ORDER_HEADERS_ALL OH
, OE_ORDER_LINES_ALL OL
, IC_TRAN_PND T
WHERE W.DELIVERY_ID = WA.DELIVERY_ID
AND WA.DELIVERY_DETAIL_ID = WD.DELIVERY_DETAIL_ID
AND WD.SOURCE_CODE = 'OE'
AND WD.OE_INTERFACED_FLAG = 'Y'
AND WD.SOURCE_HEADER_ID = OH.HEADER_ID
AND WD.SOURCE_LINE_ID = OL.LINE_ID
AND WD.SOURCE_LINE_ID = T.LINE_ID
AND T.DOC_TYPE = 'OMSO'
AND T.COMPLETED_IND = 1
AND T.GL_POSTED_IND = 1
AND T.DELETE_MARK = 0 GROUP BY W.DELIVERY_ID
, WD.DELIVERY_DETAIL_ID
, WD.SOURCE_HEADER_ID
, WD.SOURCE_LINE_ID
, WD.FOB_CODE
, WD.NET_WEIGHT
, WD.WEIGHT_UOM_CODE
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, OL.SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM
, OL.UNIT_SELLING_PRICE
, T.ITEM_ID
, T.ORGN_CODE
, T.WHSE_CODE
, T.TRANS_UM
, T.COMPLETED_IND
, T.GL_POSTED_IND