View: ECE_DSNO_ORDERS_V

View Text

SELECT DISTINCT SPLD.DELIVERY_ID DELIVERY_ID
, DLV.ACTUAL_DEPARTURE_ID DEPARTURE_ID
, SPLD.CONTAINER_ID CONTAINER_ID
, SPH.PICKING_HEADER_ID PICKING_HEADER_ID
, SPH.ORDER_HEADER_ID ORDER_HEADER_ID
, SOH.PURCHASE_ORDER_NUM PURCHASE_ORDER_NUMBER
, SOH.DATE_ORDERED PURCHASE_ORDER_DATE
, SOH.ORDER_NUMBER SALES_ORDER_NUMBER
, SOH.DATE_ORDERED SALES_ORDER_DATE
, SOA.AGREEMENT_NUM AGREEMENT_NUMBER_INT
, SOT.NAME ORDER_TYPE_INT
, SOH.ORDER_CATEGORY ORDER_CATEGORY
, SOH.DATE_REQUESTED_CURRENT CUSTOMER_REQUEST_DATE
, SOH.SHIP_PARTIAL_FLAG SHIP_PARTIAL_FLAG
, SOH.PAYMENT_TYPE_CODE FOB_PAYMENT_METHOD_CODE_INT
, ERA1.ADDRESS_ID ORDER_BY_ADDRESS_ID
, ERA1.ORIG_SYSTEM_REFERENCE ORDER_BY_CODE_INT
, ERA1.TP_LOCATION_CODE_EXT ORDER_BY_CODE_EXT1
, ERA1.TP_REFERENCE_EXT1 ORDER_BY_CODE_EXT2
, ERA1.TP_REFERENCE_EXT2 ORDER_BY_CODE_EXT3
, ERA1.CUSTOMER_NAME ORDER_BY_NAME
, ERA1.ADDRESS1 ORDER_BY_ADDRESS1
, ERA1.ADDRESS2 ORDER_BY_ADDRESS2
, ERA1.ADDRESS3 ORDER_BY_ADDRESS3
, ERA1.ADDRESS4 ORDER_BY_ADDRESS4
, ERA1.CITY ORDER_BY_CITY
, ERA1.POSTAL_CODE ORDER_BY_POSTAL_CODE
, ERA1.COUNTRY ORDER_BY_COUNTRY_INT
, ERA1.STATE ORDER_BY_STATE_INT
, ERA1.PROVINCE ORDER_BY_PROVINCE_INT
, ERA1.COUNTY ORDER_BY_COUNTY
, ERA1.LAST_NAME ORDER_BY_CONTACT_LAST_NAME
, ERA1.FIRST_NAME ORDER_BY_CONTACT_FIRST_NAME
, ERA1.JOB_TITLE ORDER_BY_CONTACT_JOB_TITLE
, ERA1.AREA_CODE ORDER_BY_AREA_CODE
, ERA1.PHONE_NUMBER ORDER_BY_TELEPHONE
, ERC2.ADDRESS_ID INVOICE_ADDRESS_ID
, ERC2.ORIG_SYSTEM_REFERENCE INVOICE_CODE_INT
, ERC2.TP_LOCATION_CODE_EXT INVOICE_CODE_EXT1
, ERC2.TP_REFERENCE_EXT1 INVOICE_CODE_EXT2
, ERC2.TP_REFERENCE_EXT2 INVOICE_CODE_EXT3
, ERC2.LOCATION INVOICE_NAME
, ERC2.ADDRESS1 INVOICE_ADDRESS1
, ERC2.ADDRESS2 INVOICE_ADDRESS2
, ERC2.ADDRESS3 INVOICE_ADDRESS3
, ERC2.ADDRESS4 INVOICE_ADDRESS4
, ERC2.CITY INVOICE_CITY
, ERC2.POSTAL_CODE INVOICE_POSTAL_CODE
, ERC2.COUNTRY INVOICE_COUNTRY_INT
, ERC2.STATE INVOICE_STATE_INT
, ERC2.PROVINCE INVOICE_PROVINCE_INT
, ERC2.COUNTY INVOICE_COUNTY
, ERC2.LAST_NAME INVOICE_CONTACT_LAST_NAME
, ERC2.FIRST_NAME INVOICE_CONTACT_FIRST_NAME
, ERC2.JOB_TITLE INVOICE_CONTACT_JOB_TITLE
, ERC2.AREA_CODE INVOICE_AREA_CODE
, ERC2.PHONE_NUMBER INVOICE_TELEPHONE
, SOH.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, SOH.TAX_EXEMPT_NUM TAX_EXEMPT_NUMBER
, SOH.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE_INT
, SOH.CURRENCY_CODE CURRENCY_CODE
, SOH.CONVERSION_TYPE_CODE CURRENCY_CONVERSION_TYPE_CODE
, SOH.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, SOH.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, RAT.DESCRIPTION PAYMENT_TERMS_INT
, SOH.PAYMENT_AMOUNT PAYMENT_AMOUNT
, SOH.FOB_CODE FOB_LOCATION_CODE_INT
, SOH.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE_INT
, SOH.SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, SOH.PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, SPH.CONTEXT PICKING_HEADER_CONTEXT
, SPH.ATTRIBUTE1 PICKING_HEADER_ATTRIBUTE1
, SPH.ATTRIBUTE2 PICKING_HEADER_ATTRIBUTE2
, SPH.ATTRIBUTE3 PICKING_HEADER_ATTRIBUTE3
, SPH.ATTRIBUTE4 PICKING_HEADER_ATTRIBUTE4
, SPH.ATTRIBUTE5 PICKING_HEADER_ATTRIBUTE5
, SPH.ATTRIBUTE6 PICKING_HEADER_ATTRIBUTE6
, SPH.ATTRIBUTE7 PICKING_HEADER_ATTRIBUTE7
, SPH.ATTRIBUTE8 PICKING_HEADER_ATTRIBUTE8
, SPH.ATTRIBUTE9 PICKING_HEADER_ATTRIBUTE9
, SPH.ATTRIBUTE10 PICKING_HEADER_ATTRIBUTE10
, SPH.ATTRIBUTE11 PICKING_HEADER_ATTRIBUTE11
, SPH.ATTRIBUTE12 PICKING_HEADER_ATTRIBUTE12
, SPH.ATTRIBUTE13 PICKING_HEADER_ATTRIBUTE13
, SPH.ATTRIBUTE14 PICKING_HEADER_ATTRIBUTE14
, SPH.ATTRIBUTE15 PICKING_HEADER_ATTRIBUTE15
, SOH.CONTEXT ORDER_HEADER_CONTEXT
, SOH.ATTRIBUTE1 ORDER_HEADER_ATTRIBUTE1
, SOH.ATTRIBUTE2 ORDER_HEADER_ATTRIBUTE2
, SOH.ATTRIBUTE3 ORDER_HEADER_ATTRIBUTE3
, SOH.ATTRIBUTE4 ORDER_HEADER_ATTRIBUTE4
, SOH.ATTRIBUTE5 ORDER_HEADER_ATTRIBUTE5
, SOH.ATTRIBUTE6 ORDER_HEADER_ATTRIBUTE6
, SOH.ATTRIBUTE7 ORDER_HEADER_ATTRIBUTE7
, SOH.ATTRIBUTE8 ORDER_HEADER_ATTRIBUTE8
, SOH.ATTRIBUTE9 ORDER_HEADER_ATTRIBUTE9
, SOH.ATTRIBUTE10 ORDER_HEADER_ATTRIBUTE10
, SOH.ATTRIBUTE11 ORDER_HEADER_ATTRIBUTE11
, SOH.ATTRIBUTE12 ORDER_HEADER_ATTRIBUTE12
, SOH.ATTRIBUTE13 ORDER_HEADER_ATTRIBUTE13
, SOH.ATTRIBUTE14 ORDER_HEADER_ATTRIBUTE14
, SOH.ATTRIBUTE15 ORDER_HEADER_ATTRIBUTE15
, SHA.GLOBAL_ATTRIBUTE_CATEGORY OH_GLOBAL_CATEGORY
, SHA.GLOBAL_ATTRIBUTE1 OH_GLOBAL_ATTRIBUTE1
, SHA.GLOBAL_ATTRIBUTE2 OH_GLOBAL_ATTRIBUTE2
, SHA.GLOBAL_ATTRIBUTE3 OH_GLOBAL_ATTRIBUTE3
, SHA.GLOBAL_ATTRIBUTE4 OH_GLOBAL_ATTRIBUTE4
, SHA.GLOBAL_ATTRIBUTE5 OH_GLOBAL_ATTRIBUTE5
, SHA.GLOBAL_ATTRIBUTE6 OH_GLOBAL_ATTRIBUTE6
, SHA.GLOBAL_ATTRIBUTE7 OH_GLOBAL_ATTRIBUTE7
, SHA.GLOBAL_ATTRIBUTE8 OH_GLOBAL_ATTRIBUTE8
, SHA.GLOBAL_ATTRIBUTE9 OH_GLOBAL_ATTRIBUTE9
, SHA.GLOBAL_ATTRIBUTE10 OH_GLOBAL_ATTRIBUTE10
, SHA.GLOBAL_ATTRIBUTE11 OH_GLOBAL_ATTRIBUTE11
, SHA.GLOBAL_ATTRIBUTE12 OH_GLOBAL_ATTRIBUTE12
, SHA.GLOBAL_ATTRIBUTE13 OH_GLOBAL_ATTRIBUTE13
, SHA.GLOBAL_ATTRIBUTE14 OH_GLOBAL_ATTRIBUTE14
, SHA.GLOBAL_ATTRIBUTE15 OH_GLOBAL_ATTRIBUTE15
, SHA.GLOBAL_ATTRIBUTE16 OH_GLOBAL_ATTRIBUTE16
, SHA.GLOBAL_ATTRIBUTE17 OH_GLOBAL_ATTRIBUTE17
, SHA.GLOBAL_ATTRIBUTE18 OH_GLOBAL_ATTRIBUTE18
, SHA.GLOBAL_ATTRIBUTE19 OH_GLOBAL_ATTRIBUTE19
, SHA.GLOBAL_ATTRIBUTE20 OH_GLOBAL_ATTRIBUTE20
FROM RA_TERMS RAT
, ECE_RCO_ADDRESS ERA1
, ECE_RSU_CONTACT ERC2
, SO_ORDER_TYPES_ALL SOT
, SO_AGREEMENTS SOA
, SO_HEADER_ATTRIBUTES SHA
, SO_HEADERS_ALL SOH
, SO_PICKING_HEADERS_ALL SPH
, SO_PICKING_LINES_ALL SPL
, WSH_DELIVERIES DLV
, SO_PICKING_LINE_DETAILS SPLD
WHERE SOH.TERMS_ID = RAT.TERM_ID (+) AND SOH.INVOICE_TO_SITE_USE_ID = ERC2.SITE_USE_ID (+) AND SOH.ORDERED_BY_CONTACT_ID = ERA1.CONTACT_ID (+) AND SOH.AGREEMENT_ID = SOA.AGREEMENT_ID (+) AND SOH.ORDER_TYPE_ID = SOT.ORDER_TYPE_ID AND SPH.ORDER_HEADER_ID = SHA.HEADER_ID (+) AND SPH.ORDER_HEADER_ID = SOH.HEADER_ID AND SPL.PICKING_HEADER_ID = SPH.PICKING_HEADER_ID AND SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID AND SPLD.DELIVERY_ID = DLV.DELIVERY_ID AND NVL(SPLD.SHIPPED_QUANTITY
, 0) > 0

Columns