[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;
|
|
|