VIEW: APPS.GR_SALES_ORDER_FLEX_V

Source

View Text - Preformatted

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, O.NAME ORGN_NAME 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 ORDER BY 1,2

View Text - HTML Formatted

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
, O.NAME ORGN_NAME
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 ORDER BY 1
, 2