[Home] [Help] [Dependency Information]
Object Name: | PMIBV_LOT_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIBV_LOT_LIST_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Lot List View used by Lot Genealogy workbook
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_ID | NUMBER | (10) | Item ID | |
INVENTORY_CLASS | VARCHAR2 | (8) | Inventory Class | |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
LOT_ID | NUMBER | (10) | Lot ID | |
LOT_NO | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
LOT_CREATION_DATE | DATE | Lot Creation Date | ||
QC_GRADE | VARCHAR2 | (4) | Quality Control Grade | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Organization Name | |
VENDOR_NO | VARCHAR2 | (154) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_NO | VARCHAR2 | (32) | Batch Number | |
FORMULA_NO | CHAR | (1) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
ROUTING_NO | CHAR | (1) | Routing Number | |
ROUTING_VERSION | NUMBER | Routing Version | ||
RECIEPT_NO | VARCHAR2 | (32) | PO Rceipt Number |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_NO
, ITEM_DESCRIPTION
, ITEM_ID
, INVENTORY_CLASS
, INVENTORY_TYPE
, LOT_ID
, LOT_NO
, SUBLOT_NO
, LOT_CREATION_DATE
, QC_GRADE
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, VENDOR_NO
, VENDOR_NAME
, VENDOR_ID
, BATCH_NO
, FORMULA_NO
, FORMULA_VERSION
, ROUTING_NO
, ROUTING_VERSION
, RECIEPT_NO
FROM APPS.PMIBV_LOT_LIST_V;
APPS.PMIBV_LOT_LIST_V is not referenced by any database object
|
|
|