[Home] [Help] [Dependency Information]
Object Name: | GMF_XLA_BATCH_RSRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMF.GMF_XLA_BATCH_RSRC_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
SLA batch resources view
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 |
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;
APPS.GMF_XLA_BATCH_RSRC_V is not referenced by any database object
|
|
|