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

Object Details

Object Name:	EDW_OPI_LOTD_LOT_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OPI.EDW_OPI_LOTD_LOT_LCV
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This is source view to populate Lot Level data in Lot Dimension

[View Source]

Columns

Name	Datatype	Length	Comments
EDW_LOT_PK	VARCHAR2	(193)	Primary key on the lot (includes instance).
EDW_LOT_DP	CHAR	(4)	EDW-Internal key on the lot.
ORGANIZATION_ID	NUMBER		Organization identifier of the lot item organization.
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier of the lot.
NAME	VARCHAR2	(163)	Displays name for the Lot.
LOT_NAME	VARCHAR2	(80)	Lot name.
ITEM_REVISION	NUMBER		Item revision of the lot.
NETTABLE_FLAG	VARCHAR2	(0)	For future use, nettable indicator (for planning).
EXPIRATION_DATE	DATE		Expiration date of the lot.
DESCRIPTION	VARCHAR2	(80)	Description of the lot.
USER_ATTRIBUTE1	VARCHAR2	(0)	User Defined Attribute1.
USER_ATTRIBUTE2	VARCHAR2	(0)	User Defined Attribute2.
USER_ATTRIBUTE3	VARCHAR2	(0)	User Defined Attribute3.
USER_ATTRIBUTE4	VARCHAR2	(0)	User Defined Attribute4.
USER_ATTRIBUTE5	VARCHAR2	(0)	User Defined Attribute5.
ALL_FK	CHAR	(3)	Foreign key on the All Level.
LAST_UPDATE_DATE	DATE		Standard WHO column.
CREATION_DATE	DATE		Standard WHO column.
LOT	VARCHAR2	(32)	Lot number.
PARENT_LOT	VARCHAR2	(32)	Parent lot, applicable if lot is a sublot.

Query Text

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


SELECT EDW_LOT_PK
,      EDW_LOT_DP
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      NAME
,      LOT_NAME
,      ITEM_REVISION
,      NETTABLE_FLAG
,      EXPIRATION_DATE
,      DESCRIPTION
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      ALL_FK
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LOT
,      PARENT_LOT
FROM APPS.EDW_OPI_LOTD_LOT_LCV;

Dependencies

[top of page]

APPS.EDW_OPI_LOTD_LOT_LCV references the following:

APPS: EDW_LOCAL_INSTANCE; IC_ITEM_MST; IC_LOTS_MST; MTL_LOT_NUMBERS

APPS.EDW_OPI_LOTD_LOT_LCV is referenced by following:

APPS: EDW_OPI_LOT_MPV