[Home] [Help] [Dependency Information]
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 |
A public view which may be useful for custom reporting or other data
requirements.
View for SLA ADR sources from Batch Details
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 |
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;
APPS.GMF_XLA_BATCH_DETAILS_V is not referenced by any database object
|
|
|