View: GR_ORDER_INFO_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	View of Order Fulfillment tables and Order Management tables
Implementation/DBA Data:	APPS.GR_ORDER_INFO_V

View Text

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

Columns