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

TABLE: GMD.GMD_ROUTING_CLASS_B

Object Details
Object Name: GMD_ROUTING_CLASS_B
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_ROUTING_CLASS_B
Subobject Name:
Status: VALID


Routing class base table - used to group routings.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_ROUTING_CLASS_B_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTING_CLASS
Columns
Name Datatype Length Mandatory Comments
ROUTING_CLASS VARCHAR2 (4) Yes Code for the routing class.
ROUTING_CLASS_DESC VARCHAR2 (40)
Description of the routing class.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
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)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
UOM VARCHAR2 (4)
Unit of Measure
ROUTING_CLASS_UOM VARCHAR2 (3)
Routing class uom in 3 characters
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 ROUTING_CLASS
,      ROUTING_CLASS_DESC
,      TEXT_CODE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      UOM
,      ROUTING_CLASS_UOM
,      FIXED_PROCESS_LOSS
FROM GMD.GMD_ROUTING_CLASS_B;

Dependencies

[top of page]

GMD.GMD_ROUTING_CLASS_B does not reference any database object

GMD.GMD_ROUTING_CLASS_B is referenced by following:

SchemaGMD
ViewGMD_ROUTING_CLASS_B#