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.PMIFV_BATCH_LOTS_V

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_NUMBER	VARCHAR2	(32)	Yes	Item Number
ITEM_DESCRIPTION	VARCHAR2	(70)	Yes	Item Description
ITEM_ID	NUMBER	(10)	Yes	Item ID
LOT_ID	NUMBER	(10)	Yes	Lot ID
LOT_NUMBER	VARCHAR2	(32)	Yes	Lot Number
SUBLOT_NUMBER	VARCHAR2	(32)		Sublot Number
ORGN_CODE	VARCHAR2	(4)	Yes	Organization Code
ORGN_NAME	VARCHAR2	(40)		Organization Name
BATCH_NUMBER	VARCHAR2	(32)	Yes	Batch Number
BATCH_ID	NUMBER	(10)	Yes	Batch ID
BATCH_CLOSE_DATE	DATE			Batch Close Date
TRANS_QTY	NUMBER		Yes	Transaction Quantity
TRANS_UM	VARCHAR2	(4)	Yes	Transaction Unit of Measure
COMPLETED_IND	NUMBER	(5)	Yes	Completed Indicator
LINE_TYPE	NUMBER	(5)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_ID
,      LOT_ID
,      LOT_NUMBER
,      SUBLOT_NUMBER
,      ORGN_CODE
,      ORGN_NAME
,      BATCH_NUMBER
,      BATCH_ID
,      BATCH_CLOSE_DATE
,      TRANS_QTY
,      TRANS_UM
,      COMPLETED_IND
,      LINE_TYPE
FROM APPS.PMIFV_BATCH_LOTS_V;

Dependencies

[top of page]

APPS.PMIFV_BATCH_LOTS_V references the following:

APPS: FM_FORM_MST_B; GME_BATCH_HEADER; IC_ITEM_MST; IC_LOTS_MST; IC_TRAN_PND; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIFV_BATCH_LOTS_V is not referenced by any database object