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]

VIEW: APPS.GMD_ROUTINGS_VL

Object Details

Object Name:	GMD_ROUTINGS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_ROUTINGS_VL
Subobject Name:
Status:	VALID

View Type

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

View for Routing header Base and translation tables

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW ID value
OWNER_ORGANIZATION_ID	NUMBER	(15)	Yes	inventory organization id
ROUTING_ID	NUMBER	(10)	Yes	Routing Id Value
ROUTING_NO	VARCHAR2	(32)	Yes	Routing Name
ROUTING_VERS	NUMBER	(5)	Yes	Routing Version
ROUTING_CLASS	VARCHAR2	(4)		Routing Class
ROUTING_QTY	NUMBER			Routing Qty
ITEM_UM	VARCHAR2	(4)		Routing Qty UOM
ROUTING_UOM	VARCHAR2	(3)	Yes
CONTIGUOUS_IND	NUMBER	(5)		Contiguous Indicator
DELETE_MARK	NUMBER	(5)	Yes	Logical marking for deleted rows
TEXT_CODE	NUMBER	(10)		Unique code for Additional Text
INACTIVE_IND	NUMBER	(5)	Yes	Indicator that checks if routing is Active
IN_USE	NUMBER	(10)		Indicator to chech if Routing is in Use
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
ATTRIBUTE1	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE2	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE3	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE4	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE5	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE6	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE7	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE8	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE9	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE10	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE11	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE12	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE13	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE14	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE15	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE16	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE17	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE18	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE19	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE20	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE21	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE22	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE23	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE24	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE25	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE26	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE27	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE28	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE29	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE30	VARCHAR2	(240)		Flexfield Attribute
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Flexfield category or class
EFFECTIVE_START_DATE	DATE			Valid start date for this routing
EFFECTIVE_END_DATE	DATE			Valid end date for this routing
OWNER_ID	NUMBER	(15)		UserId for the Owner of this Routing
PROJECT_ID	NUMBER	(15)		Project Id
PROCESS_LOSS	NUMBER			Loss associted with this Routing
ROUTING_STATUS	VARCHAR2	(30)		Routing Status
ENFORCE_STEP_DEPENDENCY	NUMBER	(5)		This column indicates if the step dependencies have to be enforced in the batches
ROUTING_DESC	VARCHAR2	(240)	Yes	Description for Routing
FIXED_PROCESS_LOSS	NUMBER			Fixed Process Loss: Quantity define in this will be distributed across all material lines
FIXED_PROCESS_LOSS_UOM	VARCHAR2	(3)		Fixed Process Loss: UOM

Query Text

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


SELECT ROW_ID
,      OWNER_ORGANIZATION_ID
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      ROUTING_CLASS
,      ROUTING_QTY
,      ITEM_UM
,      ROUTING_UOM
,      CONTIGUOUS_IND
,      DELETE_MARK
,      TEXT_CODE
,      INACTIVE_IND
,      IN_USE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OWNER_ID
,      PROJECT_ID
,      PROCESS_LOSS
,      ROUTING_STATUS
,      ENFORCE_STEP_DEPENDENCY
,      ROUTING_DESC
,      FIXED_PROCESS_LOSS
,      FIXED_PROCESS_LOSS_UOM
FROM APPS.GMD_ROUTINGS_VL;

Dependencies

[top of page]

APPS.GMD_ROUTINGS_VL references the following:

APPS: GMD_ROUTINGS_B; GMD_ROUTINGS_TL

APPS.GMD_ROUTINGS_VL is referenced by following:

APPS: FM_ROUT_HDR; GMD_ERES_UTILS - show dependent code; GMD_MBR_RECIPE_HEADER_V1; GMD_ROUTINGS; GMD_ROUTINGS_DL