View: WSH_STND_DOC_NUMBERS_V

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

View Text

SELECT DISTINCT TO_NUMBER (WTH.DOCUMENT_NUMBER) DOCUMENT_NUMBER
, WNDI.CLIENT_CODE CLIENT_CODE
FROM WSH_TRANSACTIONS_HISTORY WTH
, WSH_NEW_DEL_INTERFACE WNDI
WHERE WTH.TRANSACTION_STATUS IN ('AP'
, 'ER')
AND WTH.ENTITY_TYPE = 'DLVY_INT'
AND WTH.ENTITY_NUMBER = DELIVERY_INTERFACE_ID
AND WNDI.INTERFACE_ACTION_CODE = '94X_STANDALONE'
AND TO_NUMBER(DECODE(RTRIM(TRANSLATE(WTH.DOCUMENT_NUMBER
, '0123456789'
, ' '))
, NULL
, WTH.DOCUMENT_NUMBER
, -99999)) > 0 ORDER BY TO_NUMBER(WTH.DOCUMENT_NUMBER)

Columns