[Home] [Help] [Dependency Information]
Object Name: | MST_PERSONAL_QUERY_RESULTS |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
N
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Yes | Query ID, FK to Query_id of MST_PERSONAL_QUERIES | |
PLAN_ID | NUMBER | Yes | Plan ID. FK to plan_id of MST_PLANS | |
TRIP_ID | NUMBER | FK to TRIP_ID of MST_TRIPS | ||
CONTINUOUS_MOVE_ID | NUMBER | FK to CONTINUOUS_MOVE_ID of MST_CM_TRIPS | ||
SOURCE_CODE | VARCHAR2 | (30) | Order Source Code. Refers to SOURCE_CODE from MST_DELIVERY_DETAILS | |
SOURCE_HEADER_NUMBER | VARCHAR2 | (150) | Order Number. Refers to SOURCE_HEADER_NUMBER from MST_DELIVERY_DETAILS | |
EXCEPTION_ID | NUMBER | FK to EXCEPTION_ID of MST_EXCEPTIONS | ||
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). | ||
DELIVERY_ID | NUMBER | FK to DELIVERY_ID of MST_DELIVERIES |
Cut, paste (and edit) the following text to query this object:
SELECT QUERY_ID
, PLAN_ID
, TRIP_ID
, CONTINUOUS_MOVE_ID
, SOURCE_CODE
, SOURCE_HEADER_NUMBER
, EXCEPTION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELIVERY_ID
FROM MST.MST_PERSONAL_QUERY_RESULTS;
MST.MST_PERSONAL_QUERY_RESULTS does not reference any database object
MST.MST_PERSONAL_QUERY_RESULTS is referenced by following:
|
|
|