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

TABLE: MST.MST_USER_DEF_PLAN_OPTIONS

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


Each user has to setup their default options upon first creating a plan


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MST_USER_DEF_PLAN_OPTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER
Yes PK, FK to fnd_user
PLAN_START NUMBER

In plan option form, plan start date should be defaulted to SYSDATE + plan_start
PLAN_END NUMBER

In plan option form, plan end date should be defaulted to SYSDATE + plan_start + plan_end
PLAN_START_TIME VARCHAR2 (240)
Hour and minute info
PLAN_END_TIME VARCHAR2 (240)
Hour and minute info
OUTSIDE_PROCESSING_FLAG NUMBER

1 Yes,2 or null No
DROP_SHIPMENT_FLAG NUMBER

1 Yes,2 or null No
SHIP_FROM_SUPPLIER_FLAG NUMBER

1 Yes,2 or null No
SHIP_TO_CUSTOMER_FLAG NUMBER

1 Yes,2 or null No
RETURN_TO_SUPPLIER_FLAG NUMBER

1 Yes,2 or null No
RETURN_FROM_CUSTOMER_FLAG NUMBER

1 Yes,2 or null No
INT_INBOUND_ALL_FLAG NUMBER

Internal inbound from all Orgs
INT_OUTBOUND_ALL_FLAG NUMBER

Internal outbound from all Orgs
EXT_INBOUND_ALL_FLAG NUMBER

External inbound from supplier/return from customers
EXT_OUTBOUND_ALL_FLAG NUMBER

External outbound bound to customer and returns to supplier
OPTIMIZATION_STRATEGY_FLAG NUMBER
Yes 1 => Mode/carrier selection only, 2 => 1 and simple consolidation, 3 = > 1 and advance consolidation
POOLING_FLAG NUMBER

Value to specify if optimization strategic flag is 3
MULTI_STOP_TL_FLAG NUMBER

Value to specify if optimization strategic flag is 3
CONTINUOUS_MOVE_FLAG NUMBER

Value to specify if optimization strategic flag is 3
TARGET_TL_UTILIZATION NUMBER

Target TL utilization in percentage
MIN_TL_UTILIZATION NUMBER

minimun TL in percentage
LOCAL_POOLING_SHIPMENT_SIZE NUMBER

Local pooling shipment size limit in percentage
LOCAL_POOLING_RADIUS NUMBER

In distance UOM
STOP_NEIGHBORHOOD_RADIUS NUMBER

Maximum distance between adjacent stops in multiple stop trips in distance UOM
GENERAL_POOLING_RADIUS NUMBER

Maximum distance between O/D facility and pool in distance UOM
POOL_POINT_COUNT NUMBER

Number of candidate pools considered for O/D of an order
MAXIMUM_EMPTY_LEG_LENGTH NUMBER

Maximum empty length to be considered when building continuous move
LOADING_UNLOADING_CHARGE NUMBER

Whether to consider loading and unloading charges for cost optimization
LAYOVER_CHARGES NUMBER

Whether to consider loading and unloading charges for cost optimization
ORIGIN_DESTINATION_TL_CHRGS NUMBER

Whether to consider origin and destination charges for cost optimization
OTHER_TL_CHARGES NUMBER

Whether to consider other TL charges for cost optimization
OTHER_LTL_CHARGES NUMBER

other LTL charges
OTHER_PARCEL_CHARGES NUMBER

other parcel charges
LTL_DISCOUNT NUMBER

discount for LTL
PARCEL_DISCOUNT NUMBER

discounts for parcels
AUTO_RELEASE NUMBER
Yes 1 => do not auto release, 2 => auto release entire plan, 3 => auto release based on auto release rules
AUTO_REL_RULE_SET_ID NUMBER

Auto release individual loads using this rule set
COMMITMENT_SET_ID NUMBER

Carrier contractual commitment set id. FK to fte_sel_groups
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 USER_ID
,      PLAN_START
,      PLAN_END
,      PLAN_START_TIME
,      PLAN_END_TIME
,      OUTSIDE_PROCESSING_FLAG
,      DROP_SHIPMENT_FLAG
,      SHIP_FROM_SUPPLIER_FLAG
,      SHIP_TO_CUSTOMER_FLAG
,      RETURN_TO_SUPPLIER_FLAG
,      RETURN_FROM_CUSTOMER_FLAG
,      INT_INBOUND_ALL_FLAG
,      INT_OUTBOUND_ALL_FLAG
,      EXT_INBOUND_ALL_FLAG
,      EXT_OUTBOUND_ALL_FLAG
,      OPTIMIZATION_STRATEGY_FLAG
,      POOLING_FLAG
,      MULTI_STOP_TL_FLAG
,      CONTINUOUS_MOVE_FLAG
,      TARGET_TL_UTILIZATION
,      MIN_TL_UTILIZATION
,      LOCAL_POOLING_SHIPMENT_SIZE
,      LOCAL_POOLING_RADIUS
,      STOP_NEIGHBORHOOD_RADIUS
,      GENERAL_POOLING_RADIUS
,      POOL_POINT_COUNT
,      MAXIMUM_EMPTY_LEG_LENGTH
,      LOADING_UNLOADING_CHARGE
,      LAYOVER_CHARGES
,      ORIGIN_DESTINATION_TL_CHRGS
,      OTHER_TL_CHARGES
,      OTHER_LTL_CHARGES
,      OTHER_PARCEL_CHARGES
,      LTL_DISCOUNT
,      PARCEL_DISCOUNT
,      AUTO_RELEASE
,      AUTO_REL_RULE_SET_ID
,      COMMITMENT_SET_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM MST.MST_USER_DEF_PLAN_OPTIONS;

Dependencies

[top of page]

MST.MST_USER_DEF_PLAN_OPTIONS does not reference any database object

MST.MST_USER_DEF_PLAN_OPTIONS is referenced by following:

SchemaAPPS
SynonymMST_USER_DEF_PLAN_OPTIONS