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_MBR_STEP_OPRN_V1

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROUTING_ID	NUMBER	(10)	Yes	Routing ID
ROUTINGSTEP_NO	NUMBER	(5)	Yes	Routing Step Number
ROUTINGSTEP_ID	NUMBER	(10)	Yes	Routing Step ID
OPRN_ID	NUMBER	(10)	Yes	Operation ID
STEP_QTY	NUMBER		Yes	Quantity processed by the routing step.
STEPRELEASE_TYPE	NUMBER	(5)	Yes	Step release type. 0=Automatic, 1=Manual.
MINIMUM_TRANSFER_QTY	NUMBER			Minimum amount of material that must be produced at a given production operation and resource, that will be transferred to the next operation and resource before it can begin processing
OPRN_NO	VARCHAR2	(16)	Yes	Alphanumeric operation name or number
OPRN_VERS	NUMBER	(5)	Yes	Operation version
PROCESS_QTY_UOM	VARCHAR2	(3)	Yes	Process qty UOM
OPRN_CLASS	VARCHAR2	(4)		Operation class
INACTIVE_IND	NUMBER	(5)		Inactive indicator
EFFECTIVE_START_DATE	VARCHAR2	(4000)		Operation effective start date
EFFECTIVE_END_DATE	VARCHAR2	(4000)		Operation effective end date
OPERATION_STATUS	VARCHAR2	(30)	Yes	Operation status
OWNER_ORGANIZATION_ID	NUMBER	(15)	Yes	Inventory organizaion id
OPRN_DESC	VARCHAR2	(40)	Yes	Operation Description
RECIPE_ID	NUMBER	(15)	Yes	Recipe ID
ENTITY_KEY	VARCHAR2	(122)		Entity Key to retrieve Processing Instruction

Query Text

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


SELECT ROUTING_ID
,      ROUTINGSTEP_NO
,      ROUTINGSTEP_ID
,      OPRN_ID
,      STEP_QTY
,      STEPRELEASE_TYPE
,      MINIMUM_TRANSFER_QTY
,      OPRN_NO
,      OPRN_VERS
,      PROCESS_QTY_UOM
,      OPRN_CLASS
,      INACTIVE_IND
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      OPERATION_STATUS
,      OWNER_ORGANIZATION_ID
,      OPRN_DESC
,      RECIPE_ID
,      ENTITY_KEY
FROM APPS.GMD_MBR_STEP_OPRN_V1;

Dependencies

[top of page]

APPS.GMD_MBR_STEP_OPRN_V1 references the following:

APPS: FM_ROUT_DTL; FND_DATE - show dependent code; FND_TIMEZONES - show dependent code; GMD_OPERATIONS; GMD_RECIPES_B

APPS.GMD_MBR_STEP_OPRN_V1 is not referenced by any database object