[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GME_OPSM_BATCH_EXTRACT_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 transaction details and pending lot details used by GME_OPSM_BATCH_EXPORT_V VIEW
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Organization ID | ||
| ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
| PLANT_CODE | VARCHAR2 | (3) | As Plant code does not exists in R12,Organization Code is populated | |
| BATCH_NO | VARCHAR2 | (32) | 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 | Inventory Item ID | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM Code | |
| WORK_ORDER_QTY | NUMBER | If Batch Status is Pending,then Plan Qty in Primary UOM Else Wip Plan Qty in Primary UOM | ||
| LOT_ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code in which lot exists | |
| PARENT_LOT_NUMBER | VARCHAR2 | (80) | Parent Lot NUMBER | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot NUMBER | |
| ORIGINATION_DATE | DATE | Lot Orgination Date | ||
| RETEST_DATE | DATE | Lot Retest Date | ||
| EXPIRATION_DATE | DATE | Lot Expiration Date | ||
| BEST_BY_DATE | DATE | Lot Best By Date | ||
| COMPLETED_QTY | NUMBER | Quantity Completed for a Batch | ||
| LOT_QTY | NUMBER | Total Quantity allocated to a Lot | ||
| LOT_COMPLETED_QTY | NUMBER | Total Quantity Completed in a Lot | ||
| BATCH_CREATION_DATE | DATE | Batch Creation Date | ||
| PLAN_START_DATE | DATE | Planned Start Date | ||
| PLAN_CMPLT_DATE | DATE | 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 | |
| LAST_UPDATE_DATE | DATE | Maximum value of Batch Last Update Date,Material Last Update Date, Pending Lots Last Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
, PLANT_CODE
, BATCH_NO
, BATCH_TYPE
, BATCH_STATUS
, ITEM_NUMBER
, ITEM_DESCRIPTION
, INVENTORY_ITEM_ID
, PRIMARY_UOM_CODE
, WORK_ORDER_QTY
, LOT_ORGANIZATION_CODE
, PARENT_LOT_NUMBER
, LOT_NUMBER
, ORIGINATION_DATE
, RETEST_DATE
, EXPIRATION_DATE
, BEST_BY_DATE
, COMPLETED_QTY
, LOT_QTY
, LOT_COMPLETED_QTY
, BATCH_CREATION_DATE
, PLAN_START_DATE
, PLAN_CMPLT_DATE
, ACTUAL_START_DATE
, ACTUAL_CMPLT_DATE
, BATCH_CLOSE_DATE
, FIRMED_IND
, TERMINATED_IND
, LAST_UPDATE_DATE
FROM APPS.GME_OPSM_BATCH_EXTRACT_V;
APPS
GME_OPSM_BATCH_DETAILS_V
GME_OPSM_PENDING_PROD_LOTS_V
INV_CONVERT
- show dependent code
MTL_LOT_NUMBERS
MTL_TRANSACTION_LOT_NUMBERS
APPS
GME_OPSM_BATCH_EXPORT_V
|
|
|
|