VIEW: APPS.INVBV_PHYSICAL_INVENTORIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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