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


VIEW: APPS.MST_FAC_DOC_CAPACITY_EXCEED_V

Object Details
Object Name: MST_FAC_DOC_CAPACITY_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
LOCATION_ID NUMBER
Yes FK to wsh_locations
FACILITY_ID NUMBER
Yes FK to fte_location_parameters
FACILITY_CODE VARCHAR2 (60) Yes Facility name
FACILITY_DESCRIPTION VARCHAR2 (250)
Facility description
COMPANY VARCHAR2 (40)
Company name
ADDRESS VARCHAR2 (240)
Address
CITY VARCHAR2 (120)
City
STATE VARCHAR2 (120)
State
ZIP VARCHAR2 (60)
Zip code
COUNTRY VARCHAR2 (120)
Country
NUM_DOCKS NUMBER

Number of docks allowed
NUMBER1 NUMBER

Peak number of loads assigned between Date1 and Date2
EXCESS NUMBER

Number of docks exceeding the maximum limit
DATE1_DISPLAY VARCHAR2 (40)
Date1 in local timezone
DATE2_DISPLAY VARCHAR2 (40)
Date2in local timezone
DATE1 DATE

Date & time (start of violation)
DATE2 DATE

Date & time (end of violation)
STATUS VARCHAR2 (80) Yes Exception status
THRESHOLD VARCHAR2 (20)
Threshold value of exception
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
,      LOCATION_ID
,      FACILITY_ID
,      FACILITY_CODE
,      FACILITY_DESCRIPTION
,      COMPANY
,      ADDRESS
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      NUM_DOCKS
,      NUMBER1
,      EXCESS
,      DATE1_DISPLAY
,      DATE2_DISPLAY
,      DATE1
,      DATE2
,      STATUS
,      THRESHOLD
,      WORKFLOW_STATUS
FROM APPS.MST_FAC_DOC_CAPACITY_EXCEED_V;

Dependencies

[top of page]

APPS.MST_FAC_DOC_CAPACITY_EXCEED_V references the following:

SchemaAPPS
SynonymFTE_LOCATION_PARAMETERS
ViewMFG_LOOKUPS
SynonymMST_EXCEPTION_DETAILS
PL/SQL PackageMST_WB_UTIL - show dependent code
SynonymWSH_LOCATIONS

APPS.MST_FAC_DOC_CAPACITY_EXCEED_V is not referenced by any database object