[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: |
APPS.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 |