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_RECIPE_RSRC_V1

Object Details

Object Name:	GMD_MBR_RECIPE_RSRC_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.GMD_MBR_RECIPE_RSRC_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
ROUTINGSTEP_ID	NUMBER	(10)	Yes	Routing Step Identifier
ROUTING_STEP_NO	NUMBER	(5)	Yes	Routing Step Number
OPRN_ID	NUMBER	(10)	Yes	Operation Identifier
OPRN_NO	VARCHAR2	(16)	Yes	Operation Number
OPRN_VERS	NUMBER	(5)	Yes	Operation Version
OPRN_DESC	VARCHAR2	(240)		Operation Description
ACTIVITY	VARCHAR2	(16)	Yes	Activity
OPRNLINE_ID	NUMBER	(15)	Yes	Operation Line ID
RESOURCES	VARCHAR2	(16)	Yes	Resource Name
RESOURCE_USAGE	NUMBER		Yes	Resource Usage
RESOURCE_COUNT	NUMBER		Yes	Count of resources
PROCESS_QTY	NUMBER		Yes	Process quantity
PRIM_RSRC_IND	NUMBER		Yes	Primary resource indicator
SCALE_TYPE	NUMBER	(5)	Yes	Scale type
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Cost analysis code
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Component class ID
USAGE_UOM	VARCHAR2	(3)		process uom
OFFSET_INTERVAL	NUMBER		Yes	Offset time interval
MAX_CAPACITY	NUMBER			Maximum capacity
MIN_CAPACITY	NUMBER			Minimum capacity
CAPACITY_UOM	VARCHAR2	(3)		capacity uom
PROCESS_UOM	VARCHAR2	(3)	Yes	Process UOM
ENTITY_KEY	VARCHAR2	(139)		Entity Key to join to Processing Instructions

Query Text

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


SELECT RECIPE_ID
,      ROUTINGSTEP_ID
,      ROUTING_STEP_NO
,      OPRN_ID
,      OPRN_NO
,      OPRN_VERS
,      OPRN_DESC
,      ACTIVITY
,      OPRNLINE_ID
,      RESOURCES
,      RESOURCE_USAGE
,      RESOURCE_COUNT
,      PROCESS_QTY
,      PRIM_RSRC_IND
,      SCALE_TYPE
,      COST_ANALYSIS_CODE
,      COST_CMPNTCLS_ID
,      USAGE_UOM
,      OFFSET_INTERVAL
,      MAX_CAPACITY
,      MIN_CAPACITY
,      CAPACITY_UOM
,      PROCESS_UOM
,      ENTITY_KEY
FROM APPS.GMD_MBR_RECIPE_RSRC_V1;

Dependencies

[top of page]

APPS.GMD_MBR_RECIPE_RSRC_V1 references the following:

APPS: CR_RSRC_MST_B; FM_ROUT_DTL; GMD_OPERATIONS_B; GMD_OPERATION_ACTIVITIES; GMD_OPERATION_RESOURCES; GMD_RECIPES_B

APPS.GMD_MBR_RECIPE_RSRC_V1 is not referenced by any database object