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

TABLE: MST.MST_EXCEPT_DETAILS_DETAILS

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


Entity storing detail information for each instance in MST_EXCEPTION_DETAILS


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_DETAIL_DETAIL_ID NUMBER
Yes Used as primary key combined with column of PLAN_ID
EXCEPTION_DETAIL_ID NUMBER
Yes This is foreign key to the table MST_EXCEP_DETAILS
PLAN_ID NUMBER
Yes Used as the primary key combined iwth column of EXCEPTION_DETAIL_DETAIL_ID
DELIVERY_DETAIL_ID NUMBER

This column stores the delivery detail id caused this exceptions, if this exception is related to delivery details
DELIVERY_ID NUMBER

This column stores the delivery id caused this exceptions, if this exception is related to delivery
DELIVERY_LEG_ID NUMBER

This column stores the delivery leg id caused this exceptions, if this exception is related to delivery leg
CARRIER_ID NUMBER

This column stores the carrier id caused this exceptions, if this exception is related to carrier
CARRIER_SERVICE_ID NUMBER

This column stores the carrier service id caused this exceptions, if this exception is related to carrier service
VEHICLE_TYPE_ID NUMBER

This column stores the vehicle type id caused this exceptions, if this exception is related to vehicle type
CUSTOMER_ID NUMBER

This column stores the customer id caused this exceptions, if this exception is related to customer
SUPPLIER_ID NUMBER

This column stores the supplier caused this exceptions, if this exception is related to supplier id
ORGANIZATION_ID NUMBER

This column stores the organization id caused this exceptions, if this exception is related to organization
LOCATION_ID NUMBER

This column stores the location id caused this exceptions, if this exception is related to location
STOP_ID NUMBER

This column stores the stop id caused this exceptions, if this exception is related to stops
CONTINUOUS_MOVE_ID NUMBER

This column stores the continuous move id caused this exceptions. if this exception is related to continuous moves
TRIP_ID NUMBER

This column stores the trip id caused this exceptions. if this exception is related to trips
NUMBER1 NUMBER

generic column
NUMBER2 NUMBER

generic column
NUMBER3 NUMBER

generic column
NUMBER4 NUMBER

generic column
NUMBER5 NUMBER

generic column
DATE1 DATE

generic column
DATE4 DATE

generic column
DATE5 DATE

generic column
DATE2 DATE

generic column
DATE3 DATE

generic column
CHAR1 VARCHAR2 (240)
generic column
CHAR2 VARCHAR2 (240)
generic column
CHAR3 VARCHAR2 (240)
generic column
CHAR4 VARCHAR2 (240)
generic column
CHAR5 VARCHAR2 (240)
generic column
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
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 EXCEPTION_DETAIL_DETAIL_ID
,      EXCEPTION_DETAIL_ID
,      PLAN_ID
,      DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      DELIVERY_LEG_ID
,      CARRIER_ID
,      CARRIER_SERVICE_ID
,      VEHICLE_TYPE_ID
,      CUSTOMER_ID
,      SUPPLIER_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      STOP_ID
,      CONTINUOUS_MOVE_ID
,      TRIP_ID
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      DATE1
,      DATE4
,      DATE5
,      DATE2
,      DATE3
,      CHAR1
,      CHAR2
,      CHAR3
,      CHAR4
,      CHAR5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_EXCEPT_DETAILS_DETAILS;

Dependencies

[top of page]

MST.MST_EXCEPT_DETAILS_DETAILS does not reference any database object

MST.MST_EXCEPT_DETAILS_DETAILS is referenced by following:

SchemaAPPS
SynonymMST_EXCEPT_DETAILS_DETAILS