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