View: GR_SALES_ORDER_FLEX_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	View of SALES ORDER NUMBER+ LINE NUMBER + ORDER COMMENTS + NAME + ITEM NUMBER
Implementation/DBA Data:	APPS.GR_SALES_ORDER_FLEX_V

View Text

SELECT TO_CHAR(OH.ORDER_NUMBER) ORDER_NO
, TO_NUMBER(OE.LINE_NUMBER||'.'||OE.SHIPMENT_NUMBER) LINE_NO
, ' ' ORDER_COMMENT
, WN.NAME NAME
, MTL.SEGMENT1 ITEM_NO
FROM OE_ORDER_LINES_ALL OE
, OE_ORDER_HEADERS_ALL OH
, WSH_DELIVERY_DETAILS WD
, WSH_NEW_DELIVERIES WN
, WSH_DELIVERY_ASSIGNMENTS WA
, MTL_SYSTEM_ITEMS MTL
, HR_ALL_ORGANIZATION_UNITS O
WHERE OE.HEADER_ID = OH.HEADER_ID
AND WD.SOURCE_LINE_ID = OE.LINE_ID
AND WD.SOURCE_CODE = 'OE'
AND WD.DELIVERY_DETAIL_ID = WA.DELIVERY_DETAIL_ID
AND WA.DELIVERY_ID = WN.DELIVERY_ID(+)
AND OE.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND MTL.ORGANIZATION_ID = O.ORGANIZATION_ID
AND O.NAME = FND_PROFILE.VALUE('GR_WHSE_DEFAULT') UNION SELECT OFH.ORDER_NO ORDER_NO
, OFD.LINE_NO LINE_NO
, OFH.ORDER_COMMENT ORDER_COMMENT
, OFB.BOL_NO NAME
, IC.ITEM_NO ITEM_NO
FROM OP_ORDR_HDR OFH
, OP_ORDR_DTL OFD
, OP_BILL_LAD OFB
, IC_ITEM_MST IC
WHERE OFH.ORDER_ID = OFD.ORDER_ID
AND OFH.FROM_WHSE = OFD.FROM_WHSE
AND OFD.BOL_ID = OFB.BOL_ID(+)
AND OFD.DELETE_MARK = 0
AND OFD.ITEM_ID = IC.ITEM_ID ORDER BY 1
, 2

Columns