DBA Data[Home] [Help] [Dependency Information]

TABLE: MST.MST_ORDER_SELECTION_CRITERIA

Object Details
Object Name: MST_ORDER_SELECTION_CRITERIA
Object Type: TABLE
Owner: MST
Subobject Name:
Status: VALID


Stores the criteria for selecting the Orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_ORD_SELECTION_CRITERIA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes Unique identifier for Query
ALL_SALES_ORDERS NUMBER

Flag to query all Sales Orders. 1 => Yes, 2=> No
SALES_ORDER_NUMBERS VARCHAR2 (2000)
Sales Order Numbers
ALL_PURCHASE_ORDERS NUMBER

Flag to query all Purchase Orders. 1 => Yes, 2=> No
PURCHASE_ORDER_NUMBERS VARCHAR2 (2000)
Purchase Order Numbers
ALL_OTHER_ORDERS NUMBER

Flag to query all Other Orders. 1 => Yes, 2=> No
OTHER_ORDER_NUMBERS VARCHAR2 (2000)
Other Order Numbers
RANGE_TYPE NUMBER

Range Filter type. 1 => From, 2 => To, 3 => From or To, 4 => Between
ORIGIN_FACILITIES VARCHAR2 (2000)
Origin facilities
ORIGIN_FACILITY_IDS VARCHAR2 (2000)
Origin facility IDs
DESTINATION_FACILITIES VARCHAR2 (2000)
Destination facilities
DESTINATION_FACILITY_IDS VARCHAR2 (2000)
Destination facility IDs
ORIGIN_ZIP VARCHAR2 (2000)
Origin Zip codes
DESTINATION_ZIP VARCHAR2 (2000)
Destination Zip codes
ORIGIN_CITY VARCHAR2 (2000)
Origin Cities
DESTINATION_CITY VARCHAR2 (2000)
Destination Cities
ORIGIN_STATE VARCHAR2 (2000)
Origin States
DESTINATION_STATE VARCHAR2 (2000)
Destination States
ORIGIN_COUNTRY VARCHAR2 (2000)
Origin Countries
DESTINATION_COUNTRY VARCHAR2 (2000)
Destination Countries
ITEMS VARCHAR2 (2000)
Search by Items
INVENTORY_ITEM_IDS VARCHAR2 (2000)
Inventory Item IDs used to search Orders
CUSTOMERS VARCHAR2 (2000)
Search by Customers
CUSTOMER_IDS VARCHAR2 (2000)
Customer IDs used to search Orders
SUPPLIERS VARCHAR2 (2000)
Search by Suppliers
SUPPLIER_IDS VARCHAR2 (2000)
Supplier IDs used to search Orders
WEIGHT_TYPE NUMBER

Filter type for Weight. 4 => Between, 6 => Less than, 7 => Greater than
WEIGHT_FROM NUMBER

Weight FROM Range
WEIGHT_TO NUMBER

Weight TO Range
CUBE_TYPE NUMBER

Filter type for Cube. 4 => Between, 6 => Less than, 7 => Greater than
CUBE_FROM NUMBER

Cube FROM Range
CUBE_TO NUMBER

Cube TO Range
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUERY_ID
,      ALL_SALES_ORDERS
,      SALES_ORDER_NUMBERS
,      ALL_PURCHASE_ORDERS
,      PURCHASE_ORDER_NUMBERS
,      ALL_OTHER_ORDERS
,      OTHER_ORDER_NUMBERS
,      RANGE_TYPE
,      ORIGIN_FACILITIES
,      ORIGIN_FACILITY_IDS
,      DESTINATION_FACILITIES
,      DESTINATION_FACILITY_IDS
,      ORIGIN_ZIP
,      DESTINATION_ZIP
,      ORIGIN_CITY
,      DESTINATION_CITY
,      ORIGIN_STATE
,      DESTINATION_STATE
,      ORIGIN_COUNTRY
,      DESTINATION_COUNTRY
,      ITEMS
,      INVENTORY_ITEM_IDS
,      CUSTOMERS
,      CUSTOMER_IDS
,      SUPPLIERS
,      SUPPLIER_IDS
,      WEIGHT_TYPE
,      WEIGHT_FROM
,      WEIGHT_TO
,      CUBE_TYPE
,      CUBE_FROM
,      CUBE_TO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MST.MST_ORDER_SELECTION_CRITERIA;

Dependencies

[top of page]

MST.MST_ORDER_SELECTION_CRITERIA does not reference any database object

MST.MST_ORDER_SELECTION_CRITERIA is referenced by following:

SchemaAPPS
SynonymMST_ORDER_SELECTION_CRITERIA