VIEW: APPS.GR_ORDER_INFO_V

Source

View Text - Preformatted

SELECT oh.rowid row_id, TO_CHAR(oh.order_number), TO_CHAR(0), oh.header_id, TO_CHAR(oh.ship_from_org_id), oh.invoice_to_org_id, oh.ship_to_org_id, TO_NUMBER(oe.line_number||'.'||oe.shipment_number), oe.line_id, oe.inventory_item_id, oe.ship_to_org_id, TO_CHAR(oe.ship_from_org_id), TO_CHAR(0), TO_CHAR(0), 0, 0, oe.actual_shipment_date, wnd.name, wnd.additional_shipment_info, wnd.delivery_id, 0, 0, ot.transaction_type_id, oh.created_by, oh.creation_date, oh.last_update_date, oh.last_updated_by, oh.last_update_login FROM oe_order_lines_all oe, oe_order_headers_all oh, wsh_new_deliveries wnd, wsh_delivery_details wd, wsh_delivery_assignments da, oe_transaction_types_tl ot WHERE oe.header_id = oh.header_id AND oe.line_id = wd.source_line_id AND wd.delivery_detail_id = da.delivery_detail_id AND da.delivery_id = wnd.delivery_id(+) AND ot.transaction_type_id = oh.order_type_id UNION ALL SELECT ofh.rowid, ofh.order_no, ofh.order_comment, ofh.order_id , ofh.from_whse, ofh.billcust_id, ofh.shipaddr_id, ofd.line_no, ofd.line_id, ofd.item_id, ofd.shipcust_id, ofd.from_whse, ofh.holdreas_code, ofd.holdreas_code, ofd.delete_mark, ofh.completed_ind, ofd.actual_shipdate, ofb.bol_no, ofb.bol_comment, ofb.bol_id, ofc.picking_ind, ofc.shipping_ind, ot.order_type, ofh.created_by, ofh.creation_date, ofh.last_update_date, ofh.last_updated_by, ofh.last_update_login FROM op_ordr_hdr ofh, op_ordr_dtl ofd, op_bill_lad ofb, op_hold_cds ofc, op_ordr_typ_vl ot WHERE ofh.order_id = ofd.order_id AND ofh.from_whse = ofd.from_whse AND (ofc.holdreas_code = ofh.holdreas_code OR ofd.holdreas_code = ofc.holdreas_code) AND ofd.bol_id = ofb.bol_id(+) AND ot.order_type = ofh.order_type

View Text - HTML Formatted

SELECT OH.ROWID ROW_ID
, TO_CHAR(OH.ORDER_NUMBER)
, TO_CHAR(0)
, OH.HEADER_ID
, TO_CHAR(OH.SHIP_FROM_ORG_ID)
, OH.INVOICE_TO_ORG_ID
, OH.SHIP_TO_ORG_ID
, TO_NUMBER(OE.LINE_NUMBER||'.'||OE.SHIPMENT_NUMBER)
, OE.LINE_ID
, OE.INVENTORY_ITEM_ID
, OE.SHIP_TO_ORG_ID
, TO_CHAR(OE.SHIP_FROM_ORG_ID)
, TO_CHAR(0)
, TO_CHAR(0)
, 0
, 0
, OE.ACTUAL_SHIPMENT_DATE
, WND.NAME
, WND.ADDITIONAL_SHIPMENT_INFO
, WND.DELIVERY_ID
, 0
, 0
, OT.TRANSACTION_TYPE_ID
, OH.CREATED_BY
, OH.CREATION_DATE
, OH.LAST_UPDATE_DATE
, OH.LAST_UPDATED_BY
, OH.LAST_UPDATE_LOGIN
FROM OE_ORDER_LINES_ALL OE
, OE_ORDER_HEADERS_ALL OH
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_DETAILS WD
, WSH_DELIVERY_ASSIGNMENTS DA
, OE_TRANSACTION_TYPES_TL OT
WHERE OE.HEADER_ID = OH.HEADER_ID
AND OE.LINE_ID = WD.SOURCE_LINE_ID
AND WD.DELIVERY_DETAIL_ID = DA.DELIVERY_DETAIL_ID
AND DA.DELIVERY_ID = WND.DELIVERY_ID(+)
AND OT.TRANSACTION_TYPE_ID = OH.ORDER_TYPE_ID UNION ALL SELECT OFH.ROWID
, OFH.ORDER_NO
, OFH.ORDER_COMMENT
, OFH.ORDER_ID
, OFH.FROM_WHSE
, OFH.BILLCUST_ID
, OFH.SHIPADDR_ID
, OFD.LINE_NO
, OFD.LINE_ID
, OFD.ITEM_ID
, OFD.SHIPCUST_ID
, OFD.FROM_WHSE
, OFH.HOLDREAS_CODE
, OFD.HOLDREAS_CODE
, OFD.DELETE_MARK
, OFH.COMPLETED_IND
, OFD.ACTUAL_SHIPDATE
, OFB.BOL_NO
, OFB.BOL_COMMENT
, OFB.BOL_ID
, OFC.PICKING_IND
, OFC.SHIPPING_IND
, OT.ORDER_TYPE
, OFH.CREATED_BY
, OFH.CREATION_DATE
, OFH.LAST_UPDATE_DATE
, OFH.LAST_UPDATED_BY
, OFH.LAST_UPDATE_LOGIN
FROM OP_ORDR_HDR OFH
, OP_ORDR_DTL OFD
, OP_BILL_LAD OFB
, OP_HOLD_CDS OFC
, OP_ORDR_TYP_VL OT
WHERE OFH.ORDER_ID = OFD.ORDER_ID
AND OFH.FROM_WHSE = OFD.FROM_WHSE
AND (OFC.HOLDREAS_CODE = OFH.HOLDREAS_CODE OR OFD.HOLDREAS_CODE = OFC.HOLDREAS_CODE)
AND OFD.BOL_ID = OFB.BOL_ID(+)
AND OT.ORDER_TYPE = OFH.ORDER_TYPE