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

VIEW: APPS.GMD_ROUTING_CLASS_VL

Object Details
Object Name: GMD_ROUTING_CLASS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.GMD_ROUTING_CLASS_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View for Routing Class Base and translation tables


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW ID value
ROUTING_CLASS VARCHAR2 (4) Yes Routing Class Value
TEXT_CODE NUMBER (10)
Refernce for additional text
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TRANS_CNT NUMBER (10)
TRANS COUNT
DELETE_MARK NUMBER (5) Yes Used for logical deletion
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
UOM VARCHAR2 (4)
Routing Class Unit of Measure
ROUTING_CLASS_UOM VARCHAR2 (3)
Routing class uom in 3 characters
ROUTING_CLASS_DESC VARCHAR2 (40) Yes Routing Class description
FIXED_PROCESS_LOSS NUMBER

Fixed Process Loss: Quantity define in this will be distributed across all material lines
Query Text

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


SELECT ROW_ID
,      ROUTING_CLASS
,      TEXT_CODE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      UOM
,      ROUTING_CLASS_UOM
,      ROUTING_CLASS_DESC
,      FIXED_PROCESS_LOSS
FROM APPS.GMD_ROUTING_CLASS_VL;

Dependencies

[top of page]

APPS.GMD_ROUTING_CLASS_VL references the following:

SchemaAPPS
SynonymGMD_ROUTING_CLASS_B
SynonymGMD_ROUTING_CLASS_TL
APPS.GMD_ROUTING_CLASS_VL is referenced by following:

SchemaAPPS
SynonymFM_ROUT_CLS
SynonymGMD_ROUTING_CLASS
TriggerGMD_ROUTING_CLASS_DL
TriggerGMD_ROUTING_CLASS_IL
TriggerGMD_ROUTING_CLASS_UL