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.

[Home] [Help]

View: MTL_LOT_NUMBERS_ERV

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_LOT_NUMBERS_ERV

View Text

SELECT TO_CHAR(MSI.ORGANIZATION_ID)||'-'||TO_CHAR(MSI.INVENTORY_ITEM_ID) ||'-'||LOT_NUMBER EVENT_ID
, MLN.PARENT_LOT_NUMBER
, MLN.LOT_NUMBER
, MLN.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MLN.VENDOR_ID SUPPLIER
, MLN.VENDOR_NAME
, MLN.SUPPLIER_LOT_NUMBER
, MLN.EXPIRATION_DATE
, MLN.GRADE_CODE
, MLN.ORIGINATION_DATE
, MLK.MEANING ORIGINATION_TYPE_DISP
, MLN.RETEST_DATE
, MLN.EXPIRATION_ACTION_CODE
, MLN.EXPIRATION_ACTION_DATE
, MLN.HOLD_DATE
, MLN.MATURITY_DATE
, MLN.DISABLE_FLAG
, MLN.LOT_ATTRIBUTE_CATEGORY
, MLN.C_ATTRIBUTE1
, MLN.C_ATTRIBUTE2
, MLN.C_ATTRIBUTE3
, MLN.C_ATTRIBUTE4
, MLN.C_ATTRIBUTE5
, MLN.C_ATTRIBUTE6
, MLN.C_ATTRIBUTE7
, MLN.C_ATTRIBUTE8
, MLN.C_ATTRIBUTE9
, MLN.C_ATTRIBUTE10
, MLN.C_ATTRIBUTE11
, MLN.C_ATTRIBUTE12
, MLN.C_ATTRIBUTE13
, MLN.C_ATTRIBUTE14
, MLN.C_ATTRIBUTE15
, MLN.C_ATTRIBUTE16
, MLN.C_ATTRIBUTE17
, MLN.C_ATTRIBUTE18
, MLN.C_ATTRIBUTE19
, MLN.C_ATTRIBUTE20
, MLN.D_ATTRIBUTE1
, MLN.D_ATTRIBUTE2
, MLN.D_ATTRIBUTE3
, MLN.D_ATTRIBUTE4
, MLN.D_ATTRIBUTE5
, MLN.D_ATTRIBUTE6
, MLN.D_ATTRIBUTE7
, MLN.D_ATTRIBUTE8
, MLN.D_ATTRIBUTE9
, MLN.D_ATTRIBUTE10
, MLN.N_ATTRIBUTE1
, MLN.N_ATTRIBUTE2
, MLN.N_ATTRIBUTE3
, MLN.N_ATTRIBUTE4
, MLN.N_ATTRIBUTE5
, MLN.N_ATTRIBUTE6
, MLN.N_ATTRIBUTE7
, MLN.N_ATTRIBUTE8
, MLN.N_ATTRIBUTE9
, MLN.N_ATTRIBUTE10
, MLN.ATTRIBUTE_CATEGORY
, MLN.ATTRIBUTE1
, MLN.ATTRIBUTE2
, MLN.ATTRIBUTE3
, MLN.ATTRIBUTE4
, MLN.ATTRIBUTE5
, MLN.ATTRIBUTE6
, MLN.ATTRIBUTE7
, MLN.ATTRIBUTE8
, MLN.ATTRIBUTE9
, MLN.ATTRIBUTE10
, MLN.ATTRIBUTE11
, MLN.ATTRIBUTE12
, MLN.ATTRIBUTE13
, MLN.ATTRIBUTE14
, MLN.ATTRIBUTE15
, MLN.CREATED_BY
, MLN.CREATION_DATE
, MLN.LAST_UPDATED_BY
, MLN.LAST_UPDATE_DATE
, MLN.STATUS_ID
, MMS.STATUS_CODE
FROM MTL_LOT_NUMBERS MLN
, MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS MLK
, MTL_MATERIAL_STATUSES MMS
WHERE MLN.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MLN.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MLN.ORIGINATION_TYPE = MLK.LOOKUP_CODE
AND MLK.LOOKUP_TYPE = 'MTL_LOT_ORIGINATION_TYPE'
AND MMS.STATUS_ID = MLN.STATUS_ID

Columns

Name
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
STATUS_ID
STATUS_CODE