DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GMF_XLA_BATCH_RSRC_V

Object Details
Object Name: GMF_XLA_BATCH_RSRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.GMF_XLA_BATCH_RSRC_V
Subobject Name:
Status: VALID

View Type

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


SLA batch resources view


[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 Status of the Batch
BATCHSTEP_RESOURCE_ID NUMBER (15) Yes Batchstep Resource Id
RESOURCES VARCHAR2 (16) Yes Resources
RESOURCE_DESC VARCHAR2 (240) Yes Resource Description
RESOURCE_CLASS VARCHAR2 (8)
Resource Class
RECIPE_ID NUMBER (15) Yes Recipe Identifier
RECIPE_NO VARCHAR2 (32) Yes Recipe Number
RECIPE_VERSION NUMBER (5) Yes Recipe 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
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
,      BATCHSTEP_RESOURCE_ID
,      RESOURCES
,      RESOURCE_DESC
,      RESOURCE_CLASS
,      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_RSRC_V;

Dependencies

[top of page]

APPS.GMF_XLA_BATCH_RSRC_V references the following:

SchemaAPPS
SynonymCR_RSRC_MST
SynonymFM_FORM_MST_B
SynonymGMD_RECIPES_B
SynonymGMD_RECIPE_VALIDITY_RULES
SynonymGMD_ROUTINGS_B
SynonymGME_BATCH_HEADER
SynonymGME_BATCH_STEP_RESOURCES

APPS.GMF_XLA_BATCH_RSRC_V is not referenced by any database object