FND Design Data [Home] [Help]

View: INVBV_LOTS

Product: INV - Inventory
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.INVBV_LOTS
View Text

SELECT MLN.INVENTORY_ITEM_ID
, MLN.ORGANIZATION_ID
, MLN.LOT_NUMBER
, MLN.EXPIRATION_DATE
, '_LA:MLN.DISABLE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ MLN.CREATED_BY
, MLN.CREATION_DATE
, MLN.LAST_UPDATED_BY
, MLN.LAST_UPDATE_DATE
FROM MTL_LOT_NUMBERS MLN
WHERE '_SEC:MLN.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
LOT_NUMBER
EXPIRATION_DATE
"_LA:INACTIVE_FLAG"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE