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_EXCEED_CAR_VEH_AVAILAB_V

Object Details

Object Name:	MST_EXCEED_CAR_VEH_AVAILAB_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	Comments
PLAN_ID	NUMBER		FK to mst_plans
EXCEPTION_TYPE	NUMBER		Exception type
EXCEPTION_DETAIL_ID	NUMBER		FK to mst_exception_details
CARRIER_ID	NUMBER		FK to wsh_carriers
CARRIER_NAME	VARCHAR2	(30)	Carrier name
RECORD_TYPE	VARCHAR2	(10)	LANE, LANE_GROUP
LANE_LANE_SET_ID	NUMBER		lane_id or lane_set_id depending on record type
LANE_LANE_SET_NAME	VARCHAR2	(40)	lane number or lane group name
VEHICLE_TYPE	VARCHAR2	(40)	Vehicle type
NUMBER2	NUMBER		Generic number column
NUMBER1	NUMBER		Generic number column
EXCESS	NUMBER		No. of trucks scheduled exceeding the number of trucks available for that carrier
START_DATE	VARCHAR2	(40)	Date when violation started
END_DATE	VARCHAR2	(40)	Date when violation ended
DATE1	DATE		Generic date column
DATE2	DATE		Generic date column
STATUS	VARCHAR2	(80)	Exception status
THRESHOLD	VARCHAR2	(20)	Threshold value of exception
WORKFLOW_STATUS	VARCHAR2	(20)	Workflow status of exception

Query Text

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


SELECT PLAN_ID
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      CARRIER_ID
,      CARRIER_NAME
,      RECORD_TYPE
,      LANE_LANE_SET_ID
,      LANE_LANE_SET_NAME
,      VEHICLE_TYPE
,      NUMBER2
,      NUMBER1
,      EXCESS
,      START_DATE
,      END_DATE
,      DATE1
,      DATE2
,      STATUS
,      THRESHOLD
,      WORKFLOW_STATUS
FROM APPS.MST_EXCEED_CAR_VEH_AVAILAB_V;

Dependencies

[top of page]

APPS.MST_EXCEED_CAR_VEH_AVAILAB_V references the following:

APPS: FTE_LANES; FTE_LANE_GROUPS; FTE_VEHICLE_TYPES; MFG_LOOKUPS; MST_EXCEPTION_DETAILS; MST_WB_UTIL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WSH_CARRIERS

APPS.MST_EXCEED_CAR_VEH_AVAILAB_V is not referenced by any database object