[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_TRANSACTION_TYPES_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 |