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: ViewGMF.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
RECIPE_ID NUMBER (15)
recipeIdentifier
FORMULA_ID NUMBER (10)
formula Identifier
ROUTING_ID NUMBER (10)
routing Identifier
BATCH_STATUS NUMBER (5) Yes batch status (pending, wip, closed)
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
,      RECIPE_ID
,      FORMULA_ID
,      ROUTING_ID
,      BATCH_STATUS
,      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:

SchemaAPPS
SynonymGMD_RECIPE_VALIDITY_RULES
SynonymGME_BATCH_HEADER
SynonymGME_MATERIAL_DETAILS

APPS.GMF_XLA_BATCH_DETAILS_V is not referenced by any database object