FND Design Data [Home] [Help]

View: WSH_ORDER_TYPES_REGULAR_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.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