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

VIEW: APPS.MST_WSH_FTE_COMP_CONST_V

Object Details
Object Name: MST_WSH_FTE_COMP_CONST_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
COMPATIBILITY_CLASS_CODE VARCHAR2 (30) Yes
COMMODITY_ITEM1 NUMBER

COMMODITY_ITEM2 NUMBER

VEHICLE_TYPE_ID NUMBER

VEHICLE_CLASS VARCHAR2 (30)
VEHICLE_FEATURE VARCHAR2 (30)
FACILITY_ID1 NUMBER

FACILITY_ID2 NUMBER

TP1_ID NUMBER

TP1_TYPE NUMBER

TP2_ID NUMBER

TP2_TYPE VARCHAR2 (40)
TP_MODE VARCHAR2 (30)
CONSTRAINT_TYPE VARCHAR2 (30) Yes
EFFECTIVE_DATE_FROM DATE
Yes
EFFECTIVE_DATE_TO DATE

Query Text

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


SELECT COMPATIBILITY_CLASS_CODE
,      COMMODITY_ITEM1
,      COMMODITY_ITEM2
,      VEHICLE_TYPE_ID
,      VEHICLE_CLASS
,      VEHICLE_FEATURE
,      FACILITY_ID1
,      FACILITY_ID2
,      TP1_ID
,      TP1_TYPE
,      TP2_ID
,      TP2_TYPE
,      TP_MODE
,      CONSTRAINT_TYPE
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
FROM APPS.MST_WSH_FTE_COMP_CONST_V;

Dependencies

[top of page]

APPS.MST_WSH_FTE_COMP_CONST_V references the following:

SchemaAPPS
SynonymWSH_FTE_COMP_CLASSES
SynonymWSH_FTE_COMP_CONSTRAINTS

APPS.MST_WSH_FTE_COMP_CONST_V is not referenced by any database object