VIEW: APPS.WSH_ORDER_TYPES_REGULAR_V

Source

View Text - Preformatted

SELECT NAME ORDER_TYPE_NAME , DESCRIPTION DESCRIPTION , TRANSACTION_TYPE_ID ORDER_TYPE_ID , ENFORCE_LINE_PRICES_FLAG , AGREEMENT_TYPE_CODE , START_DATE_ACTIVE , END_DATE_ACTIVE , SHIPMENT_PRIORITY_CODE FROM OE_TRXT_TYPES_NOORGS_VL WHERE NVL(ORDER_CATEGORY_CODE,'ORDER') <> 'RETURN' AND TRANSACTION_TYPE_CODE = 'ORDER'

View Text - HTML Formatted

SELECT NAME ORDER_TYPE_NAME
, DESCRIPTION DESCRIPTION
, TRANSACTION_TYPE_ID ORDER_TYPE_ID
, ENFORCE_LINE_PRICES_FLAG
, AGREEMENT_TYPE_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, SHIPMENT_PRIORITY_CODE
FROM OE_TRXT_TYPES_NOORGS_VL
WHERE NVL(ORDER_CATEGORY_CODE
, 'ORDER') <> 'RETURN'
AND TRANSACTION_TYPE_CODE = 'ORDER'