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

TABLE: GMD.FM_ROUT_DEP

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


Routing step dependencies. Defines relationships from one step to another--sequences, delays, transfer quantities


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FM_ROUT_DEP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnROUTINGSTEP_NO
ColumnDEP_ROUTINGSTEP_NO
ColumnROUTING_ID
Columns
Name Datatype Length Mandatory Comments
ROUTINGSTEP_NO NUMBER (5) Yes Routingstep_no from fm_rout_dtl
DEP_ROUTINGSTEP_NO NUMBER (5) Yes Routingstep_no from fm_rout_dtl that is dependent upon the previously entered routingstep_no
ROUTING_ID NUMBER (10) Yes Surrogate key for the routing for which step dependencies are defined.
DEP_TYPE NUMBER (5) Yes Dependency type (0=normal; 1=rework, not currently used).
REWORK_CODE VARCHAR2 (4)
Not currently used.
STANDARD_DELAY NUMBER
Yes Period between start of dep_step and step.
MINIMUM_DELAY NUMBER
Yes Minimum delay between start of dep_step and step. Not currently used.
MAX_DELAY NUMBER

Maximum delay between start of dep_step and step . Not currently used.
TRANSFER_QTY NUMBER
Yes Not currently used.
ITEM_UM VARCHAR2 (4)
Not currently used.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANSFER_PCT NUMBER

Transfer Percentage
CHARGEABLE_IND NUMBER (5)
Indicator to apply the dependency based on charge. Valid values are - 0 or NULL (implies not to apply based on charge), 1 (indicates to apply based on charge)
ROUTINGSTEP_NO_UOM VARCHAR2 (3) Yes Routing step no uom in 3 characters
Query Text

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


SELECT ROUTINGSTEP_NO
,      DEP_ROUTINGSTEP_NO
,      ROUTING_ID
,      DEP_TYPE
,      REWORK_CODE
,      STANDARD_DELAY
,      MINIMUM_DELAY
,      MAX_DELAY
,      TRANSFER_QTY
,      ITEM_UM
,      TEXT_CODE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      TRANSFER_PCT
,      CHARGEABLE_IND
,      ROUTINGSTEP_NO_UOM
FROM GMD.FM_ROUT_DEP;

Dependencies

[top of page]

GMD.FM_ROUT_DEP does not reference any database object

GMD.FM_ROUT_DEP is referenced by following:

SchemaGMD
ViewFM_ROUT_DEP#