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_OPRN_ACTIVITIY_V1

Object Details

Object Name:	GMD_MBR_OPRN_ACTIVITIY_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_MBR_OPRN_ACTIVITIY_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
RECIPE_ID	NUMBER	(15)	Yes	Recipe ID
ROUTING_STEP_NO	NUMBER	(5)	Yes	Step number of routing step.
ROUTING_ID	NUMBER	(10)	Yes	Surrogate key for the routing.
ROUTINGSTEP_ID	NUMBER	(10)	Yes	Surrogate key for the routing step
OPRN_NO	VARCHAR2	(16)	Yes	Operation to be performed
OPRN_DESC	VARCHAR2	(240)		Operation Description
OPRN_VERS	NUMBER	(5)	Yes	Operation Version
OPRN_ID	NUMBER	(10)	Yes	Surrogate key for the operation performed in this step
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
ACTIVITY	VARCHAR2	(16)	Yes	Operation activity
ACTIVITY_DESC	VARCHAR2	(40)	Yes	Operation activity Description
OPRN_LINE_ID	NUMBER	(15)	Yes	Operations line ID
ACTIVITY_FACTOR	NUMBER		Yes	Activity factor
OFFSET_INTERVAL	NUMBER		Yes	Offset time interval
BREAK_IND	NUMBER	(5)		Breakable indicator for the activity
MAX_BREAK	NUMBER			Maximum breakable amount
MATERIAL_IND	NUMBER			Material Indicator
SEQUENCE_DEPENDENT_IND	NUMBER	(5)		Allow user to select sequence dependent activities. 1 - Activity is Sequence dependent 0 - Not sequence dependent
ENTITY_KEY	VARCHAR2	(122)		Used to joing Processing Instructions Table

Query Text

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


SELECT RECIPE_ID
,      ROUTING_STEP_NO
,      ROUTING_ID
,      ROUTINGSTEP_ID
,      OPRN_NO
,      OPRN_DESC
,      OPRN_VERS
,      OPRN_ID
,      MINIMUM_TRANSFER_QTY
,      ACTIVITY
,      ACTIVITY_DESC
,      OPRN_LINE_ID
,      ACTIVITY_FACTOR
,      OFFSET_INTERVAL
,      BREAK_IND
,      MAX_BREAK
,      MATERIAL_IND
,      SEQUENCE_DEPENDENT_IND
,      ENTITY_KEY
FROM APPS.GMD_MBR_OPRN_ACTIVITIY_V1;

Dependencies

[top of page]

APPS.GMD_MBR_OPRN_ACTIVITIY_V1 references the following:

APPS: FM_ACTV_MST; FM_ROUT_DTL; GMD_OPERATIONS_B; GMD_OPERATION_ACTIVITIES; GMD_RECIPES_B

APPS.GMD_MBR_OPRN_ACTIVITIY_V1 is not referenced by any database object