View: INVBV_PHYSICAL_INV_COUNTS

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

View Text

SELECT MPT.TAG_ID
, MPT.TAG_NUMBER
, MPT.PHYSICAL_INVENTORY_ID
, MPT.ORGANIZATION_ID
, '_LA:MPT.VOID_FLAG:MFG_LOOKUPS:MTL_VOID:MEANING' /* LOOKUP */
, MPT.ADJUSTMENT_ID
, MPT.INVENTORY_ITEM_ID
, MPT.TAG_QUANTITY
, MPT.TAG_UOM
, MPT.TAG_QUANTITY_AT_STANDARD_UOM
, MPT.STANDARD_UOM
, MPT.SUBINVENTORY
, MPT.LOCATOR_ID
, MPT.LOT_NUMBER
, MPT.LOT_EXPIRATION_DATE
, MPT.REVISION
, MPT.SERIAL_NUM
, MPT.COUNTED_BY_EMPLOYEE_ID
, MPT.CREATED_BY
, MPT.CREATION_DATE
, MPT.LAST_UPDATED_BY
, MPT.LAST_UPDATE_DATE
FROM MTL_PHYSICAL_INVENTORY_TAGS MPT
WHERE '_SEC:MPT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns