[Home] [Help] [Dependency Information]
Object Name: | MST_PLAN_FACILITIES |
---|---|
Object Type: | TABLE |
Owner: | MST |
Subobject Name: | |
Status: | VALID |
This entity stores the scope of the transportation network to be planned for. Planner can select all shipper facilities or subset of shipper facilities. For each facility selected, planner can select the logistics flows i.e., inter orgs, inbound from suppliers, outbound to customers.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MST_PLAN_FACILITIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PLAN_ID
FACILITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | FK to mst_plans.plan_id | |
FACILITY_ID | NUMBER | Yes | FK to fte_location_parameters | |
INT_INBOUND_FLAG | NUMBER | Internal inbound shipments. 1 Yes, 2 or null No. | ||
INT_OUTBOUND_FLAG | NUMBER | Internal outbound shipments. 1 Yes, 2 or null No. | ||
OUT_INBOUND_FLAG | NUMBER | External inbound shipments. 1 Yes, 2 or null No. | ||
OUT_OUTBOUND_FLAG | NUMBER | External outbound shipments. 1 Yes, 2 or null No. | ||
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). |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, FACILITY_ID
, INT_INBOUND_FLAG
, INT_OUTBOUND_FLAG
, OUT_INBOUND_FLAG
, OUT_OUTBOUND_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM MST.MST_PLAN_FACILITIES;
MST.MST_PLAN_FACILITIES does not reference any database object
MST.MST_PLAN_FACILITIES is referenced by following:
|
|
|