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_FAC_HANDLE_CAP_EXCEED_V

Object Details

Object Name:	MST_FAC_HANDLE_CAP_EXCEED_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
PLAN_ID	NUMBER		Yes	FK to mst_plans
EXCEPTION_TYPE	NUMBER		Yes	Lookup code for exception type
EXCEPTION_DETAIL_ID	NUMBER		Yes	FK to mst_exception_details
FACILITY_ID	NUMBER		Yes	FK to fte_location_parameters
LOCATION_ID	NUMBER		Yes	FK to wsh_locations
FACILITY_CODE	VARCHAR2	(60)	Yes	Facility name
FACILITY_DESCRIPTION	VARCHAR2	(250)		Facility description
COMPANY	VARCHAR2	(80)		Company name
ADDRESS	VARCHAR2	(240)		Address
CITY	VARCHAR2	(120)		City
STATE	VARCHAR2	(120)		State
ZIP	VARCHAR2	(60)		Zip code
COUNTRY	VARCHAR2	(120)		Country
WEIGHT	NUMBER			Weight planned (on date when violation starts)
WEIGHT_UOM	VARCHAR2	(3)		Weight UOM
WEIGHT_CAPACITY	VARCHAR2	(40)		Weight capacity of facility
VOLUME	NUMBER			Cube planned (on date when violation starts)
VOLUME_UOM	VARCHAR2	(3)		Volume UOM
VOLUME_CAPACITY	VARCHAR2	(40)		Volume capacity of facility
PALLETS	NUMBER			Pallets planned (on date when violation starts)
PALLETS_CAPACITY	VARCHAR2	(40)		Pallet capacity of facility
PIECES	NUMBER			Pieces planned (on date when violation starts)
PIECES_CAPACITY	VARCHAR2	(40)		Pieces capacity of facility
DATE1_DISPLAY	VARCHAR2	(40)		Date1 in local timezone
DATE2_DISPLAY	VARCHAR2	(40)		Date2 in local timezone
DATE1	DATE			Date & time (start of violation)
DATE2	DATE			Date & time (end of violation)
STATUS	VARCHAR2	(80)	Yes	Exception's status
THRESHOLD	VARCHAR2	(20)		Threshold value
WORKFLOW_STATUS	VARCHAR2	(20)		Workflow status

Query Text

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


SELECT PLAN_ID
,      EXCEPTION_TYPE
,      EXCEPTION_DETAIL_ID
,      FACILITY_ID
,      LOCATION_ID
,      FACILITY_CODE
,      FACILITY_DESCRIPTION
,      COMPANY
,      ADDRESS
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      WEIGHT
,      WEIGHT_UOM
,      WEIGHT_CAPACITY
,      VOLUME
,      VOLUME_UOM
,      VOLUME_CAPACITY
,      PALLETS
,      PALLETS_CAPACITY
,      PIECES
,      PIECES_CAPACITY
,      DATE1_DISPLAY
,      DATE2_DISPLAY
,      DATE1
,      DATE2
,      STATUS
,      THRESHOLD
,      WORKFLOW_STATUS
FROM APPS.MST_FAC_HANDLE_CAP_EXCEED_V;

Dependencies

[top of page]

APPS.MST_FAC_HANDLE_CAP_EXCEED_V references the following:

APPS: FTE_LOCATION_PARAMETERS; MFG_LOOKUPS; MST_EXCEPTION_DETAILS; MST_PLANS; MST_WB_UTIL - show dependent code; WSH_LOCATIONS

APPS.MST_FAC_HANDLE_CAP_EXCEED_V is not referenced by any database object