[Home] [Help] [Dependency Information]
Object Name: | PMIFV_LOT_RESOURCE_LIST_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_LOT_RESOURCE_LIST_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view lists lots that shared a particular set of parameters, most importantly
the resources used in the lots' manufacture. This is used to identify defective lots
caused by defective resources.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | Yes | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | |
ITEM_ID | NUMBER | (10) | Yes | |
INVENTORY_CLASS | VARCHAR2 | (8) | ||
INVENTORY_TYPE | VARCHAR2 | (4) | ||
LOT_ID | NUMBER | (10) | Yes | |
LOT_NO | VARCHAR2 | (32) | Yes | |
SUBLOT_NO | VARCHAR2 | (32) | ||
LOT_CREATION_DATE | DATE | Yes | ||
QC_GRADE | VARCHAR2 | (4) | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | Yes | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Yes | |
VENDOR_NO | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
VENDOR_ID | NUMBER | (10) | ||
RESOURCES | VARCHAR2 | (16) | Yes |
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
, RESOURCES
FROM APPS.PMIFV_LOT_RESOURCE_LIST_V;
APPS.PMIFV_LOT_RESOURCE_LIST_V is not referenced by any database object
|
|
|