Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_DSNO_ITEMS_V |
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