DBA Data[Home] [Help]

VIEW: APPS.WSH_SOURCE_TYPES_V

Source

View Text - Preformatted

SELECT 'OE', NAME , DESCRIPTION , TRANSACTION_TYPE_ID FROM OE_TRXT_TYPES_NOORGS_VL WHERE NVL(ORDER_CATEGORY_CODE,'ORDER') <> 'RETURN' AND TRANSACTION_TYPE_CODE = 'ORDER'
View Text - HTML Formatted

SELECT 'OE'
, NAME
, DESCRIPTION
, TRANSACTION_TYPE_ID
FROM OE_TRXT_TYPES_NOORGS_VL
WHERE NVL(ORDER_CATEGORY_CODE
, 'ORDER') <> 'RETURN'
AND TRANSACTION_TYPE_CODE = 'ORDER'