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

Object Details

Object Name:	MTL_LOT_NUMBERS_ERV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.MTL_LOT_NUMBERS_ERV
Subobject Name:
Status:	VALID

The view is based on mtl_lot_numbers, mtl_system_items_kfv and mfg_lookups where the lot number's origination_type is amongst specified origination types.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	VARCHAR2	(162)		Unique Identifier for the lot
PARENT_LOT_NUMBER	VARCHAR2	(80)		Parent Lot Number
LOT_NUMBER	VARCHAR2	(80)	Yes	Lot Number
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM_NUMBER	VARCHAR2	(40)		Item Name
SUPPLIER	NUMBER			Supplier identification (from po_vendors table)
SUPPLIER_NAME	VARCHAR2	(240)		Supplier identification (from po_vendors table)
SUPPLIER_LOT_NUMBER	VARCHAR2	(150)		Lot number given by the supplier for PO receipts - Used By WMS Only
EXPIRATION_DATE	DATE			Lot expiration date
GRADE_CODE	VARCHAR2	(150)		Grade Code - Used By WMS Only
ORIGINATION_DATE	DATE			Lot creation date (as in the BRD) - Used By WMS Only
ORIGINATION_TYPE_DISP	VARCHAR2	(80)	Yes	Origination Type
RESTEST_DATE	DATE			Retest date - Used By WMS Only
EXPIRATION_ACTION_CODE	VARCHAR2	(32)		Expiration Action Code
EXPIRATION_ACTION_DATE	DATE			Expiration Action Date
HOLD_DATE	DATE			Hold Date
MATURITY_DATE	DATE			The date on which the item matures - Used By WMS Only
DISABLE_FLAG	NUMBER			Disable flag
LOT_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Lot attributes descriptive flexfield structure defining column
C_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
C_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE1	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE2	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE3	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE4	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE5	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE6	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE7	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE8	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE9	DATE			Descriptive flexfield segment- Used By WMS Only
D_ATTRIBUTE10	DATE			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE1	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE2	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE3	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE4	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE5	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE6	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE7	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE8	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE9	NUMBER			Descriptive flexfield segment- Used By WMS Only
N_ATTRIBUTE10	NUMBER			Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Lot attributes descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment- Used By WMS Only
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

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


SELECT EVENT_ID
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      SUPPLIER
,      SUPPLIER_NAME
,      SUPPLIER_LOT_NUMBER
,      EXPIRATION_DATE
,      GRADE_CODE
,      ORIGINATION_DATE
,      ORIGINATION_TYPE_DISP
,      RESTEST_DATE
,      EXPIRATION_ACTION_CODE
,      EXPIRATION_ACTION_DATE
,      HOLD_DATE
,      MATURITY_DATE
,      DISABLE_FLAG
,      LOT_ATTRIBUTE_CATEGORY
,      C_ATTRIBUTE1
,      C_ATTRIBUTE2
,      C_ATTRIBUTE3
,      C_ATTRIBUTE4
,      C_ATTRIBUTE5
,      C_ATTRIBUTE6
,      C_ATTRIBUTE7
,      C_ATTRIBUTE8
,      C_ATTRIBUTE9
,      C_ATTRIBUTE10
,      C_ATTRIBUTE11
,      C_ATTRIBUTE12
,      C_ATTRIBUTE13
,      C_ATTRIBUTE14
,      C_ATTRIBUTE15
,      C_ATTRIBUTE16
,      C_ATTRIBUTE17
,      C_ATTRIBUTE18
,      C_ATTRIBUTE19
,      C_ATTRIBUTE20
,      D_ATTRIBUTE1
,      D_ATTRIBUTE2
,      D_ATTRIBUTE3
,      D_ATTRIBUTE4
,      D_ATTRIBUTE5
,      D_ATTRIBUTE6
,      D_ATTRIBUTE7
,      D_ATTRIBUTE8
,      D_ATTRIBUTE9
,      D_ATTRIBUTE10
,      N_ATTRIBUTE1
,      N_ATTRIBUTE2
,      N_ATTRIBUTE3
,      N_ATTRIBUTE4
,      N_ATTRIBUTE5
,      N_ATTRIBUTE6
,      N_ATTRIBUTE7
,      N_ATTRIBUTE8
,      N_ATTRIBUTE9
,      N_ATTRIBUTE10
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.MTL_LOT_NUMBERS_ERV;

Dependencies

[top of page]

APPS.MTL_LOT_NUMBERS_ERV references the following:

APPS: MFG_LOOKUPS; MTL_LOT_NUMBERS; MTL_SYSTEM_ITEMS_KFV

APPS.MTL_LOT_NUMBERS_ERV is not referenced by any database object