[Home] [Help]
[Dependency Information]
[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;
APPS
GME_BATCH_HEADER
GME_MATERIAL_DETAILS
INV_CONVERT
- show dependent code
MTL_CROSS_REFERENCES_VL
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B_KFV
APPS
GME_OPSM_BATCH_EXTRACT_V
|
|
|
|