[Home] [Help] [Dependency Information]
Object Name: | GME_INGRED_PICK_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GME.GME_INGRED_PICK_VW |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Ingredient Picking View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NO | VARCHAR2 | (32) | Yes | Batch Number |
BATCH_STATUS | NUMBER | (5) | Yes | Batch Status |
ORGANIZATION_ID | NUMBER | Batch Organization | ||
RECIPE_VALIDITY_RULE_ID | NUMBER | (10) | Batch Validity Rule | |
FORMULA_ID | NUMBER | (10) | Formula ID | |
ROUTING_ID | NUMBER | (10) | Routing ID | |
BATCH_ID | NUMBER | (10) | Yes | Batch ID |
PLAN_START_DATE | DATE | Yes | Batch Plan Start Date | |
PLAN_CMPLT_DATE | DATE | Yes | Batch Plan Completion Date | |
ACTUAL_START_DATE | DATE | Batch Actual Start Date | ||
LINE_NO | NUMBER | (5) | Yes | Ingredient Line Number |
LINE_TYPE | NUMBER | (5) | Yes | Material Line Type |
INVENTORY_ITEM_ID | NUMBER | Item ID | ||
SUBINVENTORY | VARCHAR2 | (10) | Supply Subinventory | |
LOCATOR_ID | NUMBER | Supply Locator | ||
DTL_UM | VARCHAR2 | (3) | Material Unit Of Measure | |
MATERIAL_REQUIREMENT_DATE | DATE | Material Requirement Date | ||
BACKORDERED_QTY | NUMBER | Backordered Qty | ||
MATERIAL_DETAIL_ID | NUMBER | (10) | Yes | Material Detail ID |
REVISION | VARCHAR2 | (3) | Item Revision | |
PLAN_QTY | NUMBER | Yes | Plan Qty | |
ACTUAL_QTY | NUMBER | Yes | Actual Qty | |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item Number | |
DESCRIPTION | VARCHAR2 | (240) | Item Description | |
OPEN_QTY | NUMBER | Open Qty | ||
BATCHSTEP_NO | NUMBER | (10) | Batchstep Number | |
OPRN_ID | NUMBER | (10) | Operation ID | |
OPRN_VERS | NUMBER | (5) | Operation Version | |
OPRN_NO | VARCHAR2 | (16) | Operation Number |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NO
, BATCH_STATUS
, ORGANIZATION_ID
, RECIPE_VALIDITY_RULE_ID
, FORMULA_ID
, ROUTING_ID
, BATCH_ID
, PLAN_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_START_DATE
, LINE_NO
, LINE_TYPE
, INVENTORY_ITEM_ID
, SUBINVENTORY
, LOCATOR_ID
, DTL_UM
, MATERIAL_REQUIREMENT_DATE
, BACKORDERED_QTY
, MATERIAL_DETAIL_ID
, REVISION
, PLAN_QTY
, ACTUAL_QTY
, CONCATENATED_SEGMENTS
, DESCRIPTION
, OPEN_QTY
, BATCHSTEP_NO
, OPRN_ID
, OPRN_VERS
, OPRN_NO
FROM APPS.GME_INGRED_PICK_VW;
|
|
|