[Home] [Help] [Dependency Information]
Object Name: | ASO_I_ORDER_TYPES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ASO.ASO_I_ORDER_TYPES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_TYPE_ID | NUMBER | Yes | Order type identifier | |
NAME | VARCHAR2 | (30) | Yes | Order type name |
ORDER_CATEGORY_CODE | VARCHAR2 | (30) | order category | |
START_DATE_ACTIVE | DATE | Yes | Effectivity date for this order type | |
END_DATE_ACTIVE | DATE | Last active day for this order type | ||
CUST_TRX_TYPE_ID | NUMBER | Customer Transaction Type ID | ||
PRICE_LIST_ID | NUMBER | Price list information for the order type | ||
ACCOUNTING_RULE_ID | NUMBER | Accounting rule used by AR for generating Invoice | ||
INVOICING_RULE_ID | NUMBER | Invoicing rule used by AR for generating Invoice | ||
AGREEMENT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether or not an agreement is required | |
PO_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether or not a Purchase order is required | |
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | shipment priority code | |
SHIP_METHOD_CODE | VARCHAR2 | (30) | ship method code | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | freight terms | |
FOB_POINT_CODE | VARCHAR2 | (30) | Point of ownership transfer | |
ORG_ID | NUMBER | Organization identifier |
Cut, paste (and edit) the following text to query this object:
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
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, FOB_POINT_CODE
, ORG_ID
FROM APPS.ASO_I_ORDER_TYPES_V;
|
|
|