VIEW: APPS.WSH_DSNO_ITEMS_V

Source

View Text - Preformatted

SELECT COMM.DELIVERY_ID, COMM.CONTAINER_INSTANCE_ID, COMM.ITEM_ID, COMM.ITEM_DESCRIPTION, COMM.ORDER_HEADER_ID, COMM.ORDER_LINE_ID, COMM.DELIVERY_DETAIL_ID, COMM.CUSTOMER_ITEM_ID, SPEC.SPLIT_FROM_LINE_ID, COMM.ATO_LINE_ID, SPEC.LINK_TO_LINE_ID, SPEC.ORIGINAL_SYSTEM_LINE_REFERENCE, NVL(COMM.REFERENCE_LINE_NUMBER,SPEC.ORDER_LINE_NUMBER) ORDER_LINE_NUMBER, COMM.CUSTOMER_PART_NUMBER, COMM.SUPPLIER_PART_NUMBER, COMM.REQUESTED_DATE, SPEC.ORDER_DATE_TYPE_CODE, SPEC.PROMISE_DATE, COMM.SHIPPED_QUANTITY, COMM.ITEM_UOM_CODE_INT, COMM.CUSTOMER_MODEL_SERIAL_NUMBER, COMM.COMMODITY_CODE_INT, SPEC.ITEM_TYPE_CODE_INT, COMM.CONTAINER_ITEM_FLAG, COMM.CONTAINER_TYPE_CODE_INT, COMM.CUSTOMER_ORDER_FLAG, COMM.ORDERED_QUANTITY, COMM.CANCELLED_QUANTITY, COMM.PACKED_QUANTITY, COMM.UNIT_LIST_PRICE, SPEC.UNIT_SELLING_PRICE, SPEC.OPTION_FLAG, COMM.SHIP_MODEL_COMPLETE_FLAG, COMM.CUSTOMER_DOCK_CODE, COMM.CUSTOMER_PRODUCTION_LINE, COMM.CUSTOMER_JOB, COMM.SHIPMENT_PRIORITY_CODE_INT, COMM.SHIPMENT_CONFIRMED_DATE, COMM.CUSTOMER_ITEM_DESCRIPTION, SPEC.COMPONENT_CODE, COMM.HAZARDOUS_MATERIAL_CODE_INT, COMM.HAZARD_CLASS_INT, COMM.HAZARD_CLASS_DESCRIPTION, SPEC.ORDER_LINE_PRICING_CONTEXT, SPEC.ORDER_LINE_PRICING_ATTRIBUTE1, SPEC.ORDER_LINE_PRICING_ATTRIBUTE2, SPEC.ORDER_LINE_PRICING_ATTRIBUTE3, SPEC.ORDER_LINE_PRICING_ATTRIBUTE4, SPEC.ORDER_LINE_PRICING_ATTRIBUTE5, SPEC.ORDER_LINE_PRICING_ATTRIBUTE6, SPEC.ORDER_LINE_PRICING_ATTRIBUTE7, SPEC.ORDER_LINE_PRICING_ATTRIBUTE8, SPEC.ORDER_LINE_PRICING_ATTRIBUTE9, SPEC.ORDER_LINE_PRICING_ATTRIBUTE10, SPEC.ORDER_LINE_CONTEXT, SPEC.ORDER_LINE_ATTRIBUTE1, SPEC.ORDER_LINE_ATTRIBUTE2, SPEC.ORDER_LINE_ATTRIBUTE3, SPEC.ORDER_LINE_ATTRIBUTE4, SPEC.ORDER_LINE_ATTRIBUTE5, SPEC.ORDER_LINE_ATTRIBUTE6, SPEC.ORDER_LINE_ATTRIBUTE7, SPEC.ORDER_LINE_ATTRIBUTE8, SPEC.ORDER_LINE_ATTRIBUTE9, SPEC.ORDER_LINE_ATTRIBUTE10, SPEC.ORDER_LINE_ATTRIBUTE11, SPEC.ORDER_LINE_ATTRIBUTE12, SPEC.ORDER_LINE_ATTRIBUTE13, SPEC.ORDER_LINE_ATTRIBUTE14, SPEC.ORDER_LINE_ATTRIBUTE15, SPEC.OELINE_GLOBAL_ATTRIB_CATEGORY, SPEC.OELINE_GLOBAL_ATTRIBUTE1, SPEC.OELINE_GLOBAL_ATTRIBUTE2, SPEC.OELINE_GLOBAL_ATTRIBUTE3, SPEC.OELINE_GLOBAL_ATTRIBUTE4, SPEC.OELINE_GLOBAL_ATTRIBUTE5, SPEC.OELINE_GLOBAL_ATTRIBUTE6, SPEC.OELINE_GLOBAL_ATTRIBUTE7, SPEC.OELINE_GLOBAL_ATTRIBUTE8, SPEC.OELINE_GLOBAL_ATTRIBUTE9, SPEC.OELINE_GLOBAL_ATTRIBUTE10, SPEC.OELINE_GLOBAL_ATTRIBUTE11, SPEC.OELINE_GLOBAL_ATTRIBUTE12, SPEC.OELINE_GLOBAL_ATTRIBUTE13, SPEC.OELINE_GLOBAL_ATTRIBUTE14, SPEC.OELINE_GLOBAL_ATTRIBUTE15, SPEC.OELINE_GLOBAL_ATTRIBUTE16, SPEC.OELINE_GLOBAL_ATTRIBUTE17, SPEC.OELINE_GLOBAL_ATTRIBUTE18, SPEC.OELINE_GLOBAL_ATTRIBUTE19, SPEC.OELINE_GLOBAL_ATTRIBUTE20, SPEC.OELINE_INDUSTRY_CONTEXT, SPEC.OELINE_INDUSTRY_ATTRIBUTE1, SPEC.OELINE_INDUSTRY_ATTRIBUTE2, SPEC.OELINE_INDUSTRY_ATTRIBUTE3, SPEC.OELINE_INDUSTRY_ATTRIBUTE4, SPEC.OELINE_INDUSTRY_ATTRIBUTE5, SPEC.OELINE_INDUSTRY_ATTRIBUTE6, SPEC.OELINE_INDUSTRY_ATTRIBUTE7, SPEC.OELINE_INDUSTRY_ATTRIBUTE8, SPEC.OELINE_INDUSTRY_ATTRIBUTE9, SPEC.OELINE_INDUSTRY_ATTRIBUTE10, SPEC.OELINE_INDUSTRY_ATTRIBUTE11, SPEC.OELINE_INDUSTRY_ATTRIBUTE12, SPEC.OELINE_INDUSTRY_ATTRIBUTE13, SPEC.OELINE_INDUSTRY_ATTRIBUTE14, SPEC.OELINE_INDUSTRY_ATTRIBUTE15, COMM.DEL_DETAIL_ATTRIB_CATEGORY, COMM.DELIVERY_DETAIL_ATTRIBUTE1, COMM.DELIVERY_DETAIL_ATTRIBUTE2, COMM.DELIVERY_DETAIL_ATTRIBUTE3, COMM.DELIVERY_DETAIL_ATTRIBUTE4, COMM.DELIVERY_DETAIL_ATTRIBUTE5, COMM.DELIVERY_DETAIL_ATTRIBUTE6, COMM.DELIVERY_DETAIL_ATTRIBUTE7, COMM.DELIVERY_DETAIL_ATTRIBUTE8, COMM.DELIVERY_DETAIL_ATTRIBUTE9, COMM.DELIVERY_DETAIL_ATTRIBUTE10, COMM.DELIVERY_DETAIL_ATTRIBUTE11, COMM.DELIVERY_DETAIL_ATTRIBUTE12, COMM.DELIVERY_DETAIL_ATTRIBUTE13, COMM.DELIVERY_DETAIL_ATTRIBUTE14, COMM.DELIVERY_DETAIL_ATTRIBUTE15, COMM.LINE_PART_CATEGORY, COMM.LINE_PART_ATTRIBUTE1, COMM.LINE_PART_ATTRIBUTE2, COMM.LINE_PART_ATTRIBUTE3, COMM.LINE_PART_ATTRIBUTE4, COMM.LINE_PART_ATTRIBUTE5, COMM.LINE_PART_ATTRIBUTE6, COMM.LINE_PART_ATTRIBUTE7, COMM.LINE_PART_ATTRIBUTE8, COMM.LINE_PART_ATTRIBUTE9, COMM.LINE_PART_ATTRIBUTE10, COMM.LINE_PART_ATTRIBUTE11, COMM.LINE_PART_ATTRIBUTE12, COMM.LINE_PART_ATTRIBUTE13, COMM.LINE_PART_ATTRIBUTE14, COMM.LINE_PART_ATTRIBUTE15, SPEC.ORDER_LINE_TP_CONTEXT, SPEC.ORDER_LINE_TP_ATTRIBUTE1, SPEC.ORDER_LINE_TP_ATTRIBUTE2, SPEC.ORDER_LINE_TP_ATTRIBUTE3, SPEC.ORDER_LINE_TP_ATTRIBUTE4, SPEC.ORDER_LINE_TP_ATTRIBUTE5, SPEC.ORDER_LINE_TP_ATTRIBUTE6, SPEC.ORDER_LINE_TP_ATTRIBUTE7, SPEC.ORDER_LINE_TP_ATTRIBUTE8, SPEC.ORDER_LINE_TP_ATTRIBUTE9, SPEC.ORDER_LINE_TP_ATTRIBUTE10, SPEC.ORDER_LINE_TP_ATTRIBUTE11, SPEC.ORDER_LINE_TP_ATTRIBUTE12, SPEC.ORDER_LINE_TP_ATTRIBUTE13, SPEC.ORDER_LINE_TP_ATTRIBUTE14, SPEC.ORDER_LINE_TP_ATTRIBUTE15, SPEC.HEADER_REF_CODE_1, SPEC.HEADER_REF_CODE_2, SPEC.HEADER_REF_CODE_3, SPEC.HEADER_REF_VALUE_1, SPEC.HEADER_REF_VALUE_2, SPEC.HEADER_REF_VALUE_3, SPEC.SCHED_GENERATION_DATE, SPEC.SCHEDULE_REFERENCE_NUM, SPEC.COMMODITY_EXT, SPEC.COUNTRY_OF_ORIGIN_EXT, SPEC.CUST_ASSIGNED_ID_EXT, SPEC.CUST_CONTRACT_NUM_EXT, SPEC.CUST_MANUFACTURER_EXT, SPEC.CUST_MODEL_NUMBER_EXT, SPEC.RLM_INDUSTRY_ATTRIBUTE1, SPEC.CUST_ORDER_NUM_EXT, SPEC.CUST_PROCESS_NUM_EXT , SPEC.CUST_SET_NUM_EXT, SPEC.EQUIPMENT_CODE_EXT, SPEC.EQUIPMENT_NUMBER_EXT , SPEC.HANDLING_CODE_EXT, SPEC.HAZARD_CODE_QUAL_EXT, SPEC.HAZARD_CODE_EXT, SPEC.HAZARD_DESCRIPTION_EXT, SPEC.IMPORT_LICENSE_DATE_EXT, SPEC.IMPORT_LICENSE_EXT, SPEC.ITEM_DETAIL_REF_CODE_1, SPEC.ITEM_DETAIL_REF_CODE_2, SPEC.ITEM_DETAIL_REF_CODE_3, SPEC.ITEM_DETAIL_REF_VALUE_1, SPEC.ITEM_DETAIL_REF_VALUE_2, SPEC.ITEM_DETAIL_REF_VALUE_3, SPEC.ITEM_ENG_CNG_LVL_EXT, SPEC.TRANSPORT_METHOD_EXT, SPEC.ITEM_REF_CODE_1, SPEC.ITEM_REF_CODE_2, SPEC.ITEM_REF_CODE_3, SPEC.ITEM_REF_VALUE_1, SPEC.ITEM_REF_VALUE_2, SPEC.ITEM_REF_VALUE_3, SPEC.CUSTOMER_ITEM_REVISION, SPEC.LETTER_CREDIT_EXPDT_EXT, SPEC.LETTER_CREDIT_EXT , SPEC.RLM_ATTRIBUTE_CATEGORY, SPEC.RLM_ATTRIBUTE1, SPEC.RLM_ATTRIBUTE2, SPEC.RLM_ATTRIBUTE3, SPEC.RLM_ATTRIBUTE4, SPEC.RLM_ATTRIBUTE5, SPEC.RLM_ATTRIBUTE6, SPEC.RLM_ATTRIBUTE7, SPEC.RLM_ATTRIBUTE8, SPEC.RLM_ATTRIBUTE9, SPEC.RLM_ATTRIBUTE10, SPEC.RLM_ATTRIBUTE11, SPEC.RLM_ATTRIBUTE12, SPEC.RLM_ATTRIBUTE13, SPEC.RLM_ATTRIBUTE14, SPEC.RLM_ATTRIBUTE15, SPEC.PACKAGING_CODE_EXT, SPEC.PRIME_CONTRCTR_PART_EXT, SPEC.PULLSIGNAL_REF_NUM, SPEC.PULLSIGNAL_START_SERIAL, SPEC.PULLSIGNAL_END_SERIAL, SPEC.CUST_PO_RELEASE_NUM, SPEC.CUST_PO_DATE, SPEC.CUST_PO_LINE_NUM, SPEC.SUPPLIER_ITEM_EXT, SPEC.CUM_START_DATE, COMM.ORDER_QUANTITY_UOM_INT, COMM.CUST_PRODUCTION_SEQ_NUM, COMM.CUST_PO_NUMBER, SPEC.CUST_PAYMENT_TERMS_INT, COMM.FREIGHT_TERMS_CODE_INT, COMM.FOB_POINT_CODE_INT, COMM.ORGANIZATION_ID FROM WSH_DSNO_ITEMS_COMM_V COMM, WSH_DSNO_ITEMS_SPECIFIC_V SPEC WHERE COMM.ORDER_HEADER_ID = SPEC.ORDER_HEADER_ID AND COMM.SOURCE_CODE = SPEC.SOURCE_CODE AND COMM.ORDER_LINE_ID = SPEC.ORDER_LINE_ID ORDER BY ORDER_LINE_NUMBER

View Text - HTML Formatted

SELECT COMM.DELIVERY_ID
, COMM.CONTAINER_INSTANCE_ID
, COMM.ITEM_ID
, COMM.ITEM_DESCRIPTION
, COMM.ORDER_HEADER_ID
, COMM.ORDER_LINE_ID
, COMM.DELIVERY_DETAIL_ID
, COMM.CUSTOMER_ITEM_ID
, SPEC.SPLIT_FROM_LINE_ID
, COMM.ATO_LINE_ID
, SPEC.LINK_TO_LINE_ID
, SPEC.ORIGINAL_SYSTEM_LINE_REFERENCE
, NVL(COMM.REFERENCE_LINE_NUMBER
, SPEC.ORDER_LINE_NUMBER) ORDER_LINE_NUMBER
, COMM.CUSTOMER_PART_NUMBER
, COMM.SUPPLIER_PART_NUMBER
, COMM.REQUESTED_DATE
, SPEC.ORDER_DATE_TYPE_CODE
, SPEC.PROMISE_DATE
, COMM.SHIPPED_QUANTITY
, COMM.ITEM_UOM_CODE_INT
, COMM.CUSTOMER_MODEL_SERIAL_NUMBER
, COMM.COMMODITY_CODE_INT
, SPEC.ITEM_TYPE_CODE_INT
, COMM.CONTAINER_ITEM_FLAG
, COMM.CONTAINER_TYPE_CODE_INT
, COMM.CUSTOMER_ORDER_FLAG
, COMM.ORDERED_QUANTITY
, COMM.CANCELLED_QUANTITY
, COMM.PACKED_QUANTITY
, COMM.UNIT_LIST_PRICE
, SPEC.UNIT_SELLING_PRICE
, SPEC.OPTION_FLAG
, COMM.SHIP_MODEL_COMPLETE_FLAG
, COMM.CUSTOMER_DOCK_CODE
, COMM.CUSTOMER_PRODUCTION_LINE
, COMM.CUSTOMER_JOB
, COMM.SHIPMENT_PRIORITY_CODE_INT
, COMM.SHIPMENT_CONFIRMED_DATE
, COMM.CUSTOMER_ITEM_DESCRIPTION
, SPEC.COMPONENT_CODE
, COMM.HAZARDOUS_MATERIAL_CODE_INT
, COMM.HAZARD_CLASS_INT
, COMM.HAZARD_CLASS_DESCRIPTION
, SPEC.ORDER_LINE_PRICING_CONTEXT
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE1
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE2
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE3
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE4
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE5
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE6
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE7
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE8
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE9
, SPEC.ORDER_LINE_PRICING_ATTRIBUTE10
, SPEC.ORDER_LINE_CONTEXT
, SPEC.ORDER_LINE_ATTRIBUTE1
, SPEC.ORDER_LINE_ATTRIBUTE2
, SPEC.ORDER_LINE_ATTRIBUTE3
, SPEC.ORDER_LINE_ATTRIBUTE4
, SPEC.ORDER_LINE_ATTRIBUTE5
, SPEC.ORDER_LINE_ATTRIBUTE6
, SPEC.ORDER_LINE_ATTRIBUTE7
, SPEC.ORDER_LINE_ATTRIBUTE8
, SPEC.ORDER_LINE_ATTRIBUTE9
, SPEC.ORDER_LINE_ATTRIBUTE10
, SPEC.ORDER_LINE_ATTRIBUTE11
, SPEC.ORDER_LINE_ATTRIBUTE12
, SPEC.ORDER_LINE_ATTRIBUTE13
, SPEC.ORDER_LINE_ATTRIBUTE14
, SPEC.ORDER_LINE_ATTRIBUTE15
, SPEC.OELINE_GLOBAL_ATTRIB_CATEGORY
, SPEC.OELINE_GLOBAL_ATTRIBUTE1
, SPEC.OELINE_GLOBAL_ATTRIBUTE2
, SPEC.OELINE_GLOBAL_ATTRIBUTE3
, SPEC.OELINE_GLOBAL_ATTRIBUTE4
, SPEC.OELINE_GLOBAL_ATTRIBUTE5
, SPEC.OELINE_GLOBAL_ATTRIBUTE6
, SPEC.OELINE_GLOBAL_ATTRIBUTE7
, SPEC.OELINE_GLOBAL_ATTRIBUTE8
, SPEC.OELINE_GLOBAL_ATTRIBUTE9
, SPEC.OELINE_GLOBAL_ATTRIBUTE10
, SPEC.OELINE_GLOBAL_ATTRIBUTE11
, SPEC.OELINE_GLOBAL_ATTRIBUTE12
, SPEC.OELINE_GLOBAL_ATTRIBUTE13
, SPEC.OELINE_GLOBAL_ATTRIBUTE14
, SPEC.OELINE_GLOBAL_ATTRIBUTE15
, SPEC.OELINE_GLOBAL_ATTRIBUTE16
, SPEC.OELINE_GLOBAL_ATTRIBUTE17
, SPEC.OELINE_GLOBAL_ATTRIBUTE18
, SPEC.OELINE_GLOBAL_ATTRIBUTE19
, SPEC.OELINE_GLOBAL_ATTRIBUTE20
, SPEC.OELINE_INDUSTRY_CONTEXT
, SPEC.OELINE_INDUSTRY_ATTRIBUTE1
, SPEC.OELINE_INDUSTRY_ATTRIBUTE2
, SPEC.OELINE_INDUSTRY_ATTRIBUTE3
, SPEC.OELINE_INDUSTRY_ATTRIBUTE4
, SPEC.OELINE_INDUSTRY_ATTRIBUTE5
, SPEC.OELINE_INDUSTRY_ATTRIBUTE6
, SPEC.OELINE_INDUSTRY_ATTRIBUTE7
, SPEC.OELINE_INDUSTRY_ATTRIBUTE8
, SPEC.OELINE_INDUSTRY_ATTRIBUTE9
, SPEC.OELINE_INDUSTRY_ATTRIBUTE10
, SPEC.OELINE_INDUSTRY_ATTRIBUTE11
, SPEC.OELINE_INDUSTRY_ATTRIBUTE12
, SPEC.OELINE_INDUSTRY_ATTRIBUTE13
, SPEC.OELINE_INDUSTRY_ATTRIBUTE14
, SPEC.OELINE_INDUSTRY_ATTRIBUTE15
, COMM.DEL_DETAIL_ATTRIB_CATEGORY
, COMM.DELIVERY_DETAIL_ATTRIBUTE1
, COMM.DELIVERY_DETAIL_ATTRIBUTE2
, COMM.DELIVERY_DETAIL_ATTRIBUTE3
, COMM.DELIVERY_DETAIL_ATTRIBUTE4
, COMM.DELIVERY_DETAIL_ATTRIBUTE5
, COMM.DELIVERY_DETAIL_ATTRIBUTE6
, COMM.DELIVERY_DETAIL_ATTRIBUTE7
, COMM.DELIVERY_DETAIL_ATTRIBUTE8
, COMM.DELIVERY_DETAIL_ATTRIBUTE9
, COMM.DELIVERY_DETAIL_ATTRIBUTE10
, COMM.DELIVERY_DETAIL_ATTRIBUTE11
, COMM.DELIVERY_DETAIL_ATTRIBUTE12
, COMM.DELIVERY_DETAIL_ATTRIBUTE13
, COMM.DELIVERY_DETAIL_ATTRIBUTE14
, COMM.DELIVERY_DETAIL_ATTRIBUTE15
, COMM.LINE_PART_CATEGORY
, COMM.LINE_PART_ATTRIBUTE1
, COMM.LINE_PART_ATTRIBUTE2
, COMM.LINE_PART_ATTRIBUTE3
, COMM.LINE_PART_ATTRIBUTE4
, COMM.LINE_PART_ATTRIBUTE5
, COMM.LINE_PART_ATTRIBUTE6
, COMM.LINE_PART_ATTRIBUTE7
, COMM.LINE_PART_ATTRIBUTE8
, COMM.LINE_PART_ATTRIBUTE9
, COMM.LINE_PART_ATTRIBUTE10
, COMM.LINE_PART_ATTRIBUTE11
, COMM.LINE_PART_ATTRIBUTE12
, COMM.LINE_PART_ATTRIBUTE13
, COMM.LINE_PART_ATTRIBUTE14
, COMM.LINE_PART_ATTRIBUTE15
, SPEC.ORDER_LINE_TP_CONTEXT
, SPEC.ORDER_LINE_TP_ATTRIBUTE1
, SPEC.ORDER_LINE_TP_ATTRIBUTE2
, SPEC.ORDER_LINE_TP_ATTRIBUTE3
, SPEC.ORDER_LINE_TP_ATTRIBUTE4
, SPEC.ORDER_LINE_TP_ATTRIBUTE5
, SPEC.ORDER_LINE_TP_ATTRIBUTE6
, SPEC.ORDER_LINE_TP_ATTRIBUTE7
, SPEC.ORDER_LINE_TP_ATTRIBUTE8
, SPEC.ORDER_LINE_TP_ATTRIBUTE9
, SPEC.ORDER_LINE_TP_ATTRIBUTE10
, SPEC.ORDER_LINE_TP_ATTRIBUTE11
, SPEC.ORDER_LINE_TP_ATTRIBUTE12
, SPEC.ORDER_LINE_TP_ATTRIBUTE13
, SPEC.ORDER_LINE_TP_ATTRIBUTE14
, SPEC.ORDER_LINE_TP_ATTRIBUTE15
, SPEC.HEADER_REF_CODE_1
, SPEC.HEADER_REF_CODE_2
, SPEC.HEADER_REF_CODE_3
, SPEC.HEADER_REF_VALUE_1
, SPEC.HEADER_REF_VALUE_2
, SPEC.HEADER_REF_VALUE_3
, SPEC.SCHED_GENERATION_DATE
, SPEC.SCHEDULE_REFERENCE_NUM
, SPEC.COMMODITY_EXT
, SPEC.COUNTRY_OF_ORIGIN_EXT
, SPEC.CUST_ASSIGNED_ID_EXT
, SPEC.CUST_CONTRACT_NUM_EXT
, SPEC.CUST_MANUFACTURER_EXT
, SPEC.CUST_MODEL_NUMBER_EXT
, SPEC.RLM_INDUSTRY_ATTRIBUTE1
, SPEC.CUST_ORDER_NUM_EXT
, SPEC.CUST_PROCESS_NUM_EXT
, SPEC.CUST_SET_NUM_EXT
, SPEC.EQUIPMENT_CODE_EXT
, SPEC.EQUIPMENT_NUMBER_EXT
, SPEC.HANDLING_CODE_EXT
, SPEC.HAZARD_CODE_QUAL_EXT
, SPEC.HAZARD_CODE_EXT
, SPEC.HAZARD_DESCRIPTION_EXT
, SPEC.IMPORT_LICENSE_DATE_EXT
, SPEC.IMPORT_LICENSE_EXT
, SPEC.ITEM_DETAIL_REF_CODE_1
, SPEC.ITEM_DETAIL_REF_CODE_2
, SPEC.ITEM_DETAIL_REF_CODE_3
, SPEC.ITEM_DETAIL_REF_VALUE_1
, SPEC.ITEM_DETAIL_REF_VALUE_2
, SPEC.ITEM_DETAIL_REF_VALUE_3
, SPEC.ITEM_ENG_CNG_LVL_EXT
, SPEC.TRANSPORT_METHOD_EXT
, SPEC.ITEM_REF_CODE_1
, SPEC.ITEM_REF_CODE_2
, SPEC.ITEM_REF_CODE_3
, SPEC.ITEM_REF_VALUE_1
, SPEC.ITEM_REF_VALUE_2
, SPEC.ITEM_REF_VALUE_3
, SPEC.CUSTOMER_ITEM_REVISION
, SPEC.LETTER_CREDIT_EXPDT_EXT
, SPEC.LETTER_CREDIT_EXT
, SPEC.RLM_ATTRIBUTE_CATEGORY
, SPEC.RLM_ATTRIBUTE1
, SPEC.RLM_ATTRIBUTE2
, SPEC.RLM_ATTRIBUTE3
, SPEC.RLM_ATTRIBUTE4
, SPEC.RLM_ATTRIBUTE5
, SPEC.RLM_ATTRIBUTE6
, SPEC.RLM_ATTRIBUTE7
, SPEC.RLM_ATTRIBUTE8
, SPEC.RLM_ATTRIBUTE9
, SPEC.RLM_ATTRIBUTE10
, SPEC.RLM_ATTRIBUTE11
, SPEC.RLM_ATTRIBUTE12
, SPEC.RLM_ATTRIBUTE13
, SPEC.RLM_ATTRIBUTE14
, SPEC.RLM_ATTRIBUTE15
, SPEC.PACKAGING_CODE_EXT
, SPEC.PRIME_CONTRCTR_PART_EXT
, SPEC.PULLSIGNAL_REF_NUM
, SPEC.PULLSIGNAL_START_SERIAL
, SPEC.PULLSIGNAL_END_SERIAL
, SPEC.CUST_PO_RELEASE_NUM
, SPEC.CUST_PO_DATE
, SPEC.CUST_PO_LINE_NUM
, SPEC.SUPPLIER_ITEM_EXT
, SPEC.CUM_START_DATE
, COMM.ORDER_QUANTITY_UOM_INT
, COMM.CUST_PRODUCTION_SEQ_NUM
, COMM.CUST_PO_NUMBER
, SPEC.CUST_PAYMENT_TERMS_INT
, COMM.FREIGHT_TERMS_CODE_INT
, COMM.FOB_POINT_CODE_INT
, COMM.ORGANIZATION_ID
FROM WSH_DSNO_ITEMS_COMM_V COMM
, WSH_DSNO_ITEMS_SPECIFIC_V SPEC
WHERE COMM.ORDER_HEADER_ID = SPEC.ORDER_HEADER_ID
AND COMM.SOURCE_CODE = SPEC.SOURCE_CODE
AND COMM.ORDER_LINE_ID = SPEC.ORDER_LINE_ID ORDER BY ORDER_LINE_NUMBER