eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MST_PLAN_PARAMETERS_V

Object Details

Object Name:	MST_PLAN_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
PLAN_ID	NUMBER		Yes
PLAN_TYPE	NUMBER		Yes
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes
DESCRIPTION	VARCHAR2	(50)
START_DATE	DATE		Yes
CUTOFF_DATE	DATE		Yes
PLAN_START_DATE	DATE
PLAN_COMPLETION_DATE	DATE
DATA_START_DATE	DATE
DATA_COMPLETION_DATE	DATE
OUTSIDE_PROCESSING_FLAG	NUMBER
DROP_SHIPMENT_FLAG	NUMBER
SHIP_FROM_SUPPLIER_FLAG	NUMBER
SHIP_TO_CUSTOMER_FLAG	NUMBER
RETURN_TO_SUPPLIER_FLAG	NUMBER
RETURN_FROM_CUSTOMER_FLAG	NUMBER
INT_INBOUND_ALL_FLAG	NUMBER
INT_OUTBOUND_ALL_FLAG	NUMBER
EXT_OUTBOUND_ALL_FLAG	NUMBER
EXT_INBOUND_ALL_FLAG	NUMBER
OPTIMIZATION_STRATEGY_FLAG	NUMBER		Yes
POOLING_FLAG	NUMBER
MULTI_STOP_TL_FLAG	NUMBER
CONTINUOUS_MOVE_FLAG	NUMBER
RELEASE_RUNNING_FLAG	NUMBER
ENGINE_ACTIVE_FLAG	NUMBER
OPTIMIZED_FLAG	NUMBER
PALLETIZE_FLAG	NUMBER
TARGET_TL_UTILIZATION	NUMBER
MIN_TL_UTILIZATION	NUMBER
LOCAL_POOLING_SHIPMENT_SIZE	NUMBER
LOCAL_POOLING_RADIUS	NUMBER
STOP_NEIGHBORHOOD_RADIUS	NUMBER
GENERAL_POOLING_RADIUS	NUMBER
POOL_POINT_COUNT	NUMBER
LOADING_UNLOADING_CHARGE	NUMBER
LAYOVER_CHARGES	NUMBER
ORIGIN_DESTINATION_TL_CHRGS	NUMBER
OTHER_TL_CHARGES	NUMBER
OTHER_LTL_CHARGES	NUMBER
OTHER_PARCEL_CHARGES	NUMBER
LTL_DISCOUNT	NUMBER
PARCEL_DISCOUNT	NUMBER
AUTO_RELEASE	NUMBER		Yes
AUTO_REL_RULE_SET_ID	NUMBER
COMMITMENT_SET_ID	NUMBER
CURRENCY_UOM	VARCHAR2	(3)
DISTANCE_UOM	VARCHAR2	(3)
TIME_UOM	VARCHAR2	(3)
VOLUME_UOM	VARCHAR2	(3)
WEIGHT_UOM	VARCHAR2	(3)
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).
TOTAL_LTL_PIECES	NUMBER
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CARRIER_COMMITMENT_SET_NAME	VARCHAR2	(30)
CARRIER_COMMITMENT_SET_DESC	VARCHAR2	(240)
AUTO_REL_RULE_SET_NAME	VARCHAR2	(80)
MAXIMUM_EMPTY_LEG_LENGTH	NUMBER
SYSTEM_DATE_OFFSET	NUMBER
PLAN_DAYS	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PLAN_ID
,      PLAN_TYPE
,      COMPILE_DESIGNATOR
,      DESCRIPTION
,      START_DATE
,      CUTOFF_DATE
,      PLAN_START_DATE
,      PLAN_COMPLETION_DATE
,      DATA_START_DATE
,      DATA_COMPLETION_DATE
,      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_OUTBOUND_ALL_FLAG
,      EXT_INBOUND_ALL_FLAG
,      OPTIMIZATION_STRATEGY_FLAG
,      POOLING_FLAG
,      MULTI_STOP_TL_FLAG
,      CONTINUOUS_MOVE_FLAG
,      RELEASE_RUNNING_FLAG
,      ENGINE_ACTIVE_FLAG
,      OPTIMIZED_FLAG
,      PALLETIZE_FLAG
,      TARGET_TL_UTILIZATION
,      MIN_TL_UTILIZATION
,      LOCAL_POOLING_SHIPMENT_SIZE
,      LOCAL_POOLING_RADIUS
,      STOP_NEIGHBORHOOD_RADIUS
,      GENERAL_POOLING_RADIUS
,      POOL_POINT_COUNT
,      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
,      CURRENCY_UOM
,      DISTANCE_UOM
,      TIME_UOM
,      VOLUME_UOM
,      WEIGHT_UOM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TOTAL_LTL_PIECES
,      REQUEST_ID
,      CARRIER_COMMITMENT_SET_NAME
,      CARRIER_COMMITMENT_SET_DESC
,      AUTO_REL_RULE_SET_NAME
,      MAXIMUM_EMPTY_LEG_LENGTH
,      SYSTEM_DATE_OFFSET
,      PLAN_DAYS
FROM APPS.MST_PLAN_PARAMETERS_V;

Dependencies

[top of page]

APPS.MST_PLAN_PARAMETERS_V references the following:

APPS: FTE_SEL_GROUPS; MST_AUTO_REL_RULE_SETS; MST_PLANS

APPS.MST_PLAN_PARAMETERS_V is not referenced by any database object