eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PMIBV_LOT_LIST_V

Object Details

Object Name:	PMIBV_LOT_LIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIBV_LOT_LIST_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Lot List View used by Lot Genealogy workbook

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.PMIBV_LOT_LIST_V references the following:

APPS: GME_BATCH_HEADER; IC_ITEM_MST; IC_LOTS_MST; IC_TRAN_PND; PO_RECV_DTL; PO_RECV_HDR; PO_VENDORS_VIEW; PO_VENDOR_SITES_ALL; PO_VEND_MST; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS; SY_ORGN_MST

APPS.PMIBV_LOT_LIST_V is not referenced by any database object