View: M4R_3A6_OE_LINE_ACKS

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View same as OE_LINE_ACKS, with one additional column MODEL_REFERENCE_TEXT
Implementation/DBA Data:	APPS.M4R_3A6_OE_LINE_ACKS

View Text

SELECT CUSTOMER_ITEM
, CHANGE_SEQUENCE
, FIRST_ACK_CODE
, LINE_NUMBER
, ORDERED_QUANTITY
, ORDER_QUANTITY_UOM
, ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF
, REQUEST_DATE
, SCHEDULE_ARRIVAL_DATE
, SHIPMENT_NUMBER
, UNIT_SELLING_PRICE
, USER_ITEM_DESCRIPTION
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, SPLIT_FROM_LINE_REF
, LINK_TO_LINE_ID
, TOP_MODEL_LINE_ID
, ORIG_SYS_DOCUMENT_REF
, ACKNOWLEDGMENT_TYPE
, REQUEST_ID
, SOLD_TO_ORG_ID
, DECODE(NVL(TOP_MODEL_LINE_ID
, '-999')
, -999
, ''
, (SELECT 'TOPMODELLINEREFERENCE='|| OELT.LINE_NUMBER || '|'
FROM OE_ORDER_LINES_ALL OELT
WHERE OELT.LINE_ID = OELA.TOP_MODEL_LINE_ID)) || DECODE(NVL(LINK_TO_LINE_ID
, '-999')
, -999
, ''
, (SELECT 'PARENTLINEREFERENCE='|| OELL.LINE_NUMBER || '|'
FROM OE_ORDER_LINES_ALL OELL
WHERE OELL.LINE_ID = OELA.LINK_TO_LINE_ID)) MODEL_REFERENCE_TEXT
FROM OE_LINE_ACKS OELA

Columns