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_HDR_V

Object Details

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

View Type

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

SLA batch header view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(10)	Yes	Batch Id
BATCH_NO	VARCHAR2	(32)	Yes	Batch No
BATCH_STATUS	NUMBER	(5)	Yes	Batch Status
RECIPE_ID	NUMBER	(15)	Yes	Recipe Id
RECIPE_NO	VARCHAR2	(32)	Yes	Recipe No
RECIPE_VERSION	NUMBER	(5)	Yes	Recipe Version
ROUTING_ID	NUMBER	(10)		Routing Id
ROUTING_NO	VARCHAR2	(32)		Routing No
ROUTING_VERS	NUMBER	(5)		Routing Vers
ROUTING_CLASS	VARCHAR2	(4)		Routing Class
FORMULA_ID	NUMBER	(10)	Yes	Formula Identifier
FORMULA_NO	VARCHAR2	(32)	Yes	Formula Number
FORMULA_VERS	NUMBER		Yes	Formula Version

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
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      ROUTING_CLASS
,      FORMULA_ID
,      FORMULA_NO
,      FORMULA_VERS
FROM APPS.GMF_XLA_BATCH_HDR_V;

Dependencies

[top of page]

APPS.GMF_XLA_BATCH_HDR_V references the following:

APPS: FM_FORM_MST_B; GMD_RECIPES_B; GMD_RECIPE_VALIDITY_RULES; GMD_ROUTINGS_B; GME_BATCH_HEADER

APPS.GMF_XLA_BATCH_HDR_V is not referenced by any database object