Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_PHYSICAL_INVENTORIES |
SELECT MPI.PHYSICAL_INVENTORY_ID
, MPI.PHYSICAL_INVENTORY_NAME
, MPI.DESCRIPTION
, MPI.ORGANIZATION_ID
, MPI.PHYSICAL_INVENTORY_DATE
, MPI.LAST_ADJUSTMENT_DATE
, MPI.TOTAL_ADJUSTMENT_VALUE
, MPI.FREEZE_DATE
, '_LA:MPI.APPROVAL_REQUIRED:MFG_LOOKUPS:MTL_APPROVAL_REQ:MEANING'
, /* LOOKUP */ '_LA:MPI.ALL_SUBINVENTORIES_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ MPI.NEXT_TAG_NUMBER
, MPI.TAG_NUMBER_INCREMENTS
, MPI.APPROVAL_TOLERANCE_POS
, MPI.APPROVAL_TOLERANCE_NEG
, MPI.COST_VARIANCE_POS
, MPI.COST_VARIANCE_NEG
, MPI.NUMBER_OF_SKUS
, '_LA:MPI.DYNAMIC_TAG_ENTRY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ MPI.CREATED_BY
, MPI.CREATION_DATE
, MPI.LAST_UPDATED_BY
, MPI.LAST_UPDATE_DATE
FROM MTL_PHYSICAL_INVENTORIES MPI
WHERE '_SEC:MPI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY