VIEW: APPS.M4R_3A6_OE_LINE_ACKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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