[Home] [Help] [Dependency Information]
Object Name: | GME_OPSM_BATCH_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is used to retrieve batch details used by GME_OPSM_BATCH_EXTRACT_V VIEW
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization ID | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
BATCH_ID | NUMBER | (10) | Yes | Bacth ID |
MATERIAL_DETAIL_ID | NUMBER | (10) | Yes | Material Detail ID |
BATCH_NO | VARCHAR2 | (32) | Yes | Batch No |
BATCH_TYPE | CHAR | (7) | Hard coded as BATCH | |
BATCH_STATUS | VARCHAR2 | (9) | Batch Status -1=CANCELLED, 1=PENDING, 2=WIP, 3=COMPLETED, 4=CLOSED | |
ITEM_NUMBER | VARCHAR2 | (40) | Concatenated Segments for an Item | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item ID | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM Code | |
ORIGINAL_PRIMARY_QTY | NUMBER | Original Primary Quantity | ||
PLAN_QTY | NUMBER | Yes | Plan Quantity | |
WIP_PLAN_QTY | NUMBER | Wip Plan Quantity | ||
ACTUAL_QTY | NUMBER | Actual Qty | ||
WORK_ORDER_QTY | NUMBER | If Batch Status is Pending ,then Plan Qty in Primary UOM Else Wip Plan Qty in Primary UOM | ||
BATCH_CREATION_DATE | DATE | Yes | Batch Creation Date | |
PLAN_START_DATE | DATE | Yes | Planned Start Date | |
PLAN_CMPLT_DATE | DATE | Yes | Planned Completion Date | |
ACTUAL_START_DATE | DATE | Actual Start Date | ||
ACTUAL_CMPLT_DATE | DATE | Actual Completion Date | ||
BATCH_CLOSE_DATE | DATE | Batch Close Date | ||
FIRMED_IND | NUMBER | (5) | Firmed Indicator | |
TERMINATED_IND | NUMBER | (1) | Batch Termination Indicator | |
BATCH_UPDATE_DATE | DATE | Yes | Batch Last Update Date | |
MATERIAL_UPDATE_DATE | DATE | Yes | Material Last Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, BATCH_ID
, MATERIAL_DETAIL_ID
, BATCH_NO
, BATCH_TYPE
, BATCH_STATUS
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE
, ORIGINAL_PRIMARY_QTY
, PLAN_QTY
, WIP_PLAN_QTY
, ACTUAL_QTY
, WORK_ORDER_QTY
, BATCH_CREATION_DATE
, PLAN_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_START_DATE
, ACTUAL_CMPLT_DATE
, BATCH_CLOSE_DATE
, FIRMED_IND
, TERMINATED_IND
, BATCH_UPDATE_DATE
, MATERIAL_UPDATE_DATE
FROM APPS.GME_OPSM_BATCH_DETAILS_V;
|
|
|