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

TABLE: MST.MST_LOAD_SELECTION_CRITERIA

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


Stores the criteria for selecting the loads


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_LOAD_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_TL NUMBER

Flag to indicate All TLs. 1 => Yes, 2 => No
TLS_IN_CM NUMBER

Flag to indicate Cont. Move trips only. 1 => Yes, 2 => No
TL_NUMBERS VARCHAR2 (2000)
Truckload Trip numbers
ALL_LTL NUMBER

Flag to indicate All LTLs. 1 => Yes, 2 => No
LTL_NUMBERS VARCHAR2 (2000)
LTL trip numbers
ALL_PARCEL NUMBER

Flag to indicate All Parcel trips. 1 => Yes, 2 => No
PARCEL_NUMBERS VARCHAR2 (2000)
Parcel Trip numbers
USER_EDITS_ONLY NUMBER

Flag to indicate trips modified by user. 1 => Yes, 2 => No
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
CARRIERS VARCHAR2 (2000)
Search by Carriers
CARRIER_IDS VARCHAR2 (2000)
Carrier IDs used to search trips
CUSTOMERS VARCHAR2 (2000)
Search by Customers
CUSTOMER_IDS VARCHAR2 (2000)
Customer IDs used to search trips
SUPPLIERS VARCHAR2 (2000)
Search by Suppliers
SUPPLIER_IDS VARCHAR2 (2000)
Supplier IDs used to search trips
COST_TYPE NUMBER

Filter type for cost. 4 => Between, 6 => Less than, 7 => Greater than
COST_FROM NUMBER

Cost FROM Range
COST_TO NUMBER

Cost TO Range
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
UTILIZATION_TYPE NUMBER

Filter type for Utilization. 4 => Between, 6 => Less than, 7 => Greater than
UTILIZATION_FROM NUMBER

Utilization FROM Range
UTILIZATION_TO NUMBER

Utilization TO Range
DEPARTURE_TIME_TYPE NUMBER

Filter type for Departure time. 4 => Between, 6 => Less than, 7 => Greater than
DEPARTURE_TIME_FROM NUMBER

Departure time FROM Range
DEPARTURE_TIME_TO NUMBER

Departure time TO Range
DEPARTURE_TIME_UNIT NUMBER

Departure time Unit. 1 => Days, 2 => Hours
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_TL
,      TLS_IN_CM
,      TL_NUMBERS
,      ALL_LTL
,      LTL_NUMBERS
,      ALL_PARCEL
,      PARCEL_NUMBERS
,      USER_EDITS_ONLY
,      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
,      CARRIERS
,      CARRIER_IDS
,      CUSTOMERS
,      CUSTOMER_IDS
,      SUPPLIERS
,      SUPPLIER_IDS
,      COST_TYPE
,      COST_FROM
,      COST_TO
,      WEIGHT_TYPE
,      WEIGHT_FROM
,      WEIGHT_TO
,      CUBE_TYPE
,      CUBE_FROM
,      CUBE_TO
,      UTILIZATION_TYPE
,      UTILIZATION_FROM
,      UTILIZATION_TO
,      DEPARTURE_TIME_TYPE
,      DEPARTURE_TIME_FROM
,      DEPARTURE_TIME_TO
,      DEPARTURE_TIME_UNIT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MST.MST_LOAD_SELECTION_CRITERIA;

Dependencies

[top of page]

MST.MST_LOAD_SELECTION_CRITERIA does not reference any database object

MST.MST_LOAD_SELECTION_CRITERIA is referenced by following:

SchemaAPPS
SynonymMST_LOAD_SELECTION_CRITERIA