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.GMF_XLA_BATCH_DETAILS_V

Object Details

Object Name:	GMF_XLA_BATCH_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMF.GMF_XLA_BATCH_DETAILS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View for SLA ADR sources from Batch Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(10)	Yes	Batch Identifier
BATCH_NO	VARCHAR2	(32)	Yes	Batch number
BATCH_STATUS	NUMBER	(5)	Yes	batch status (pending, wip, closed)
RECIPE_ID	NUMBER	(15)		recipeIdentifier
RECIPE_NO	VARCHAR2	(32)	Yes	Recipe number
RECIPE_VERSION	NUMBER	(5)	Yes	Recipe Version
FORMULA_ID	NUMBER	(10)		formula Identifier
FORMULA_NO	VARCHAR2	(32)		Formula Number
FORMULA_VERS	NUMBER			Formula version
ROUTING_ID	NUMBER	(10)		routing Identifier
ROUTING_NO	VARCHAR2	(32)		Routing Number
ROUTING_VERS	NUMBER	(5)		Routing Version
ROUTING_CLASS	VARCHAR2	(4)		Routing class
MATERIAL_DETAIL_ID	NUMBER	(10)	Yes	batch material detail Identifier
LINE_TYPE	NUMBER	(5)	Yes	batch material detail line type
CONTRIBUTE_TO_YIELD	VARCHAR2	(1)		contribute to yeild
CONTRIBUTE_TO_STEP_QTY	VARCHAR2	(1)		contribute to step quantity
SCALE_TYPE	NUMBER	(5)	Yes	scailing
CONSUMPTION_TYPE	NUMBER	(5)	Yes	consumption type
PHANTOM_TYPE	NUMBER	(5)	Yes	phantom type

Query Text

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


SELECT BATCH_ID
,      BATCH_NO
,      BATCH_STATUS
,      RECIPE_ID
,      RECIPE_NO
,      RECIPE_VERSION
,      FORMULA_ID
,      FORMULA_NO
,      FORMULA_VERS
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      ROUTING_CLASS
,      MATERIAL_DETAIL_ID
,      LINE_TYPE
,      CONTRIBUTE_TO_YIELD
,      CONTRIBUTE_TO_STEP_QTY
,      SCALE_TYPE
,      CONSUMPTION_TYPE
,      PHANTOM_TYPE
FROM APPS.GMF_XLA_BATCH_DETAILS_V;

Dependencies

[top of page]

APPS.GMF_XLA_BATCH_DETAILS_V references the following:

APPS: FM_FORM_MST_B; GMD_RECIPES_B; GMD_RECIPE_VALIDITY_RULES; GMD_ROUTINGS_B; GME_BATCH_HEADER; GME_MATERIAL_DETAILS

APPS.GMF_XLA_BATCH_DETAILS_V is not referenced by any database object