FND Design Data [Home] [Help]

View: ASO_I_ORDER_TYPES_V

Product: ASO - Order Capture
Description: view gives information regarding valid order types recognized by Order Management
Implementation/DBA Data: ViewAPPS.ASO_I_ORDER_TYPES_V
View Text

SELECT ORDER_TYPE_ID
, NAME
, ORDER_CATEGORY_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CUST_TRX_TYPE_ID
, PRICE_LIST_ID
, ACCOUNTING_RULE_ID
, INVOICING_RULE_ID
, AGREEMENT_REQUIRED_FLAG
, PO_REQUIRED_FLAG
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, FREIGHT_TERMS_CODE
, FOB_POINT_CODE
, ORG_ID
FROM OE_ORDER_TYPES_V

Columns

Name
ORDER_TYPE_ID
NAME
ORDER_CATEGORY_CODE
START_DATE_ACTIVE
END_DATE_ACTIVE
CUST_TRX_TYPE_ID
PRICE_LIST_ID
ACCOUNTING_RULE_ID
INVOICING_RULE_ID
AGREEMENT_REQUIRED_FLAG
PO_REQUIRED_FLAG
SHIPMENT_PRIORITY_CODE
SHIP_METHOD_CODE
FREIGHT_TERMS_CODE
FOB_POINT_CODE
ORG_ID