VIEW: APPS.WSH_DSNO_ORDERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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