View: WSH_DSNO_ORDERS_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_DSNO_ORDERS_V

View Text

SELECT COMM.DELIVERY_ID
, COMM.CONTAINER_INSTANCE_ID
, COMM.ORDER_HEADER_ID
, SPEC.PURCHASE_ORDER_NUMBER PURCHASE_ORDER_NUMBER
, SPEC.PURCHASE_ORDER_DATE
, COMM.SALES_ORDER_NUMBER
, SPEC.SALES_ORDER_DATE
, SPEC.AGREEMENT_NUMBER_INT
, SPEC.ORDER_TYPE_INT
, SPEC.ORDER_CATEGORY_CODE
, SPEC.CUSTOMER_REQUEST_DATE
, SPEC.ORDER_DATE_TYPE_CODE
, SPEC.PARTIAL_SHIPMENTS_ALLOWED
, SPEC.FOB_PAYMENT_METHOD_CODE_INT
, COMM.ORDER_BY_ADDRESS_ID
, COMM.ORDER_BY_CODE_INT
, COMM.ORDER_BY_EDI_LOC_CODE
, COMM.ORDER_BY_TP_REF_1
, COMM.ORDER_BY_TP_REF_2
, COMM.ORDER_BY_NAME
, COMM.ORDER_BY_ADDRESS1
, COMM.ORDER_BY_ADDRESS2
, COMM.ORDER_BY_ADDRESS3
, COMM.ORDER_BY_ADDRESS4
, COMM.ORDER_BY_CITY
, COMM.ORDER_BY_POSTAL_CODE
, COMM.ORDER_BY_COUNTRY_INT
, COMM.ORDER_BY_STATE_INT
, COMM.ORDER_BY_PROVINCE_INT
, COMM.ORDER_BY_COUNTY
, COMM.ORDER_BY_CONTACT_LAST_NAME
, COMM.ORDER_BY_CONTACT_FIRST_NAME
, COMM.ORDER_BY_CONTACT_JOB_TITLE
, COMM.ORDER_BY_AREA_CODE
, COMM.ORDER_BY_TELEPHONE
, SPEC.INVOICE_ADDRESS_ID
, SPEC.INVOICE_CODE_INT
, SPEC.INVOICE_EDI_LOC_CODE
, SPEC.INVOICE_TP_REF_1
, SPEC.INVOICE_TP_REF_2
, COMM.INVOICE_NAME
, SPEC.INVOICE_ADDRESS1
, SPEC.INVOICE_ADDRESS2
, SPEC.INVOICE_ADDRESS3
, SPEC.INVOICE_ADDRESS4
, SPEC.INVOICE_CITY
, SPEC.INVOICE_POSTAL_CODE
, SPEC.INVOICE_COUNTRY_INT
, SPEC.INVOICE_STATE_INT
, SPEC.INVOICE_PROVINCE_INT
, SPEC.INVOICE_COUNTY
, SPEC.INVOICE_CONTACT_LAST_NAME
, SPEC.INVOICE_CONTACT_FIRST_NAME
, SPEC.INVOICE_CONTACT_JOB_TITLE
, SPEC.INVOICE_AREA_CODE
, SPEC.INVOICE_TELEPHONE
, SPEC.TAX_EXEMPT_FLAG
, SPEC.TAX_EXEMPT_NUMBER
, SPEC.TAX_EXEMPT_REASON_CODE_INT
, SPEC.TRANSACTIONAL_CURRENCY_CODE
, SPEC.CURRENCY_CONVERSION_TYPE_CODE
, SPEC.CURRENCY_CONVERSION_DATE
, SPEC.CURRENCY_CONVERSION_RATE
, SPEC.PAYMENT_TERMS_INT
, SPEC.PAYMENT_AMOUNT
, SPEC.FOB_POINT_CODE_INT FOB_POINT_CODE_INT
, SPEC.FREIGHT_TERMS_CODE_INT FREIGHT_TERMS_CODE_INT
, SPEC.ORDER_HEADER_CONTEXT
, SPEC.ORDER_HEADER_ATTRIBUTE1
, SPEC.ORDER_HEADER_ATTRIBUTE2
, SPEC.ORDER_HEADER_ATTRIBUTE3
, SPEC.ORDER_HEADER_ATTRIBUTE4
, SPEC.ORDER_HEADER_ATTRIBUTE5
, SPEC.ORDER_HEADER_ATTRIBUTE6
, SPEC.ORDER_HEADER_ATTRIBUTE7
, SPEC.ORDER_HEADER_ATTRIBUTE8
, SPEC.ORDER_HEADER_ATTRIBUTE9
, SPEC.ORDER_HEADER_ATTRIBUTE10
, SPEC.ORDER_HEADER_ATTRIBUTE11
, SPEC.ORDER_HEADER_ATTRIBUTE12
, SPEC.ORDER_HEADER_ATTRIBUTE13
, SPEC.ORDER_HEADER_ATTRIBUTE14
, SPEC.ORDER_HEADER_ATTRIBUTE15
, SPEC.OH_GLOBAL_CATEGORY
, SPEC.OH_GLOBAL_ATTRIBUTE1
, SPEC.OH_GLOBAL_ATTRIBUTE2
, SPEC.OH_GLOBAL_ATTRIBUTE3
, SPEC.OH_GLOBAL_ATTRIBUTE4
, SPEC.OH_GLOBAL_ATTRIBUTE5
, SPEC.OH_GLOBAL_ATTRIBUTE6
, SPEC.OH_GLOBAL_ATTRIBUTE7
, SPEC.OH_GLOBAL_ATTRIBUTE8
, SPEC.OH_GLOBAL_ATTRIBUTE9
, SPEC.OH_GLOBAL_ATTRIBUTE10
, SPEC.OH_GLOBAL_ATTRIBUTE11
, SPEC.OH_GLOBAL_ATTRIBUTE12
, SPEC.OH_GLOBAL_ATTRIBUTE13
, SPEC.OH_GLOBAL_ATTRIBUTE14
, SPEC.OH_GLOBAL_ATTRIBUTE15
, SPEC.OH_GLOBAL_ATTRIBUTE16
, SPEC.OH_GLOBAL_ATTRIBUTE17
, SPEC.OH_GLOBAL_ATTRIBUTE18
, SPEC.OH_GLOBAL_ATTRIBUTE19
, SPEC.OH_GLOBAL_ATTRIBUTE20
, SPEC.ORDER_HEADER_TP_CONTEXT
, SPEC.ORDER_HEADER_TP_ATTRIBUTE1
, SPEC.ORDER_HEADER_TP_ATTRIBUTE2
, SPEC.ORDER_HEADER_TP_ATTRIBUTE3
, SPEC.ORDER_HEADER_TP_ATTRIBUTE4
, SPEC.ORDER_HEADER_TP_ATTRIBUTE5
, SPEC.ORDER_HEADER_TP_ATTRIBUTE6
, SPEC.ORDER_HEADER_TP_ATTRIBUTE7
, SPEC.ORDER_HEADER_TP_ATTRIBUTE8
, SPEC.ORDER_HEADER_TP_ATTRIBUTE9
, SPEC.ORDER_HEADER_TP_ATTRIBUTE10
, SPEC.ORDER_HEADER_TP_ATTRIBUTE11
, SPEC.ORDER_HEADER_TP_ATTRIBUTE12
, SPEC.ORDER_HEADER_TP_ATTRIBUTE13
, SPEC.ORDER_HEADER_TP_ATTRIBUTE14
, SPEC.ORDER_HEADER_TP_ATTRIBUTE15
FROM WSH_DSNO_ORDERS_COMM_V COMM
, WSH_DSNO_ORDERS_SPECIFIC_V SPEC
WHERE COMM.ORDER_HEADER_ID = SPEC.SOURCE_HEADER_ID
AND COMM.DELIVERY_ID = DECODE (SPEC.DELIVERY_ID
, 0
, COMM.DELIVERY_ID
, SPEC.DELIVERY_ID )
AND COMM.SOURCE_CODE = SPEC.SOURCE_CODE ORDER BY PURCHASE_ORDER_NUMBER

Columns