Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_PHYSICAL_INV_COUNTS |
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