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

TABLE: MST.MST_EXCEP_SELECTION_CRITERIA

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


Stores the criteria for selecting the exceptions.


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

Flag to query all exception types. 1 => Yes, 2=> No
EXCEPTION_TYPES VARCHAR2 (2000)
Exception Type(s) to query
EXCEPTION_TYPE_IDS VARCHAR2 (2000)
Exception Type IDs to query
TRUCKLOADS NUMBER

Flag to include TL exceptions. 1 => Yes, 2 => No
PARCELS NUMBER

Flag to inlude Parcel Exceptions. 1 => Yes, 2 => No
LTLS NUMBER

Flag to include LTL exceptions. 1 => Yes, 2 => No
CONTINUOUS_MOVES NUMBER

Flag to include Continuous Move Exceptions. 1 => Yes, 2 => No
DELIVERIES NUMBER

Flag to include Deliveries Exceptions. 1 => Yes, 2 => No
FACILITIES VARCHAR2 (2000)
Facilities to query for exceptions
FACILITY_IDS VARCHAR2 (2000)
Facility IDs to query for exceptions
CARRIERS VARCHAR2 (2000)
Carriers to query for exceptions
CARRIER_IDS VARCHAR2 (2000)
Carrier IDs to query for exceptions
CUSTOMERS VARCHAR2 (2000)
Customers to query for exceptions
CUSTOMER_IDS VARCHAR2 (2000)
Customer IDs to query for exceptions
SUPPLIERS VARCHAR2 (2000)
Suppliers to query for exceptions
SUPPLIER_IDS VARCHAR2 (2000)
Supplier IDs to query for exceptions
EXCEPTION_COUNT_TYPE NUMBER

Exception Count Filter type. 1 => Equals, 4 => Between, 6 => Less than, 7 => Greater than
EXCEPTION_COUNT_FROM NUMBER

Exception Count FROM range
EXCEPTION_COUNT_TO NUMBER

Exception Count TO range
EXCEPTION_STATUS VARCHAR2 (2000)
Exception Statuses to Query
EXCEPTION_STATUS_IDS VARCHAR2 (200)
Exception Status IDs to Query
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_EXCEPTION_TYPES
,      EXCEPTION_TYPES
,      EXCEPTION_TYPE_IDS
,      TRUCKLOADS
,      PARCELS
,      LTLS
,      CONTINUOUS_MOVES
,      DELIVERIES
,      FACILITIES
,      FACILITY_IDS
,      CARRIERS
,      CARRIER_IDS
,      CUSTOMERS
,      CUSTOMER_IDS
,      SUPPLIERS
,      SUPPLIER_IDS
,      EXCEPTION_COUNT_TYPE
,      EXCEPTION_COUNT_FROM
,      EXCEPTION_COUNT_TO
,      EXCEPTION_STATUS
,      EXCEPTION_STATUS_IDS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MST.MST_EXCEP_SELECTION_CRITERIA;

Dependencies

[top of page]

MST.MST_EXCEP_SELECTION_CRITERIA does not reference any database object

MST.MST_EXCEP_SELECTION_CRITERIA is referenced by following:

SchemaAPPS
SynonymMST_EXCEP_SELECTION_CRITERIA