eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	GMD.FM_ROUT_DEP
Subobject Name:
Status:	VALID

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FM_ROUT_DEP_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ROUTINGSTEP_NO DEP_ROUTINGSTEP_NO ROUTING_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)		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:

APPS: FM_ROUT_DEP