View: WSH_ORDER_NUMBERS_V

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

View Text

SELECT H.ORDER_NUMBER
, H.HEADER_ID
, H.ORDERED_DATE
, OT.NAME ORDER_TYPE
, H.ORDER_TYPE_ID
, SUBSTRB ( PARTY.PARTY_NAME
, 1
, 50 ) /* CUSTOMER_NAME */
, CUST_ACCT.ACCOUNT_NUMBER /* CUSTOMER NUMBER */
, H.SOLD_TO_ORG_ID CUSTOMER_ID
, H.SHIPPING_METHOD_CODE
, H.SHIPMENT_PRIORITY_CODE
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, OE_ORDER_HEADERS_ALL H
, OE_TRANSACTION_TYPES_VL OT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND OT.TRANSACTION_TYPE_ID = H.ORDER_TYPE_ID
AND OT.TRANSACTION_TYPE_CODE = 'ORDER'
AND H.OPEN_FLAG = 'Y'
AND H.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+)
AND EXISTS ( SELECT SOURCE_HEADER_ID FROM WSH_DELIVERY_DETAILS WDD WHERE WDD.SOURCE_HEADER_ID = H.HEADER_ID
AND WDD.SOURCE_CODE = 'OE'
AND WDD.RELEASED_STATUS = 'R'
AND WDD.DATE_SCHEDULED IS NOT NULL )

Columns