[Home] [Help]
View: WSH_ORDER_TYPES_REGULAR_V
View Text
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'
Columns
Name |
ORDER_TYPE_NAME |
DESCRIPTION |
ORDER_TYPE_ID |
ENFORCE_LINE_PRICES_FLAG |
AGREEMENT_TYPE_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
SHIPMENT_PRIORITY_CODE |