VIEW: APPS.INVBV_PHYSICAL_ADJUSTMENTS

Source

View Text - Preformatted

SELECT MPA.ADJUSTMENT_ID, MPA.ORGANIZATION_ID, MPA.PHYSICAL_INVENTORY_ID, MPA.INVENTORY_ITEM_ID, MPA.SYSTEM_QUANTITY, MPA.COUNT_QUANTITY, MPA.ADJUSTMENT_QUANTITY, MPA.REVISION, MPA.LOCATOR_ID, MPA.SUBINVENTORY_NAME, MPA.LOT_NUMBER, MPA.LOT_EXPIRATION_DATE, MPA.SERIAL_NUMBER, MPA.ACTUAL_COST, '_LA:MPA.APPROVAL_STATUS:MFG_LOOKUPS:MTL_APPROVALS:MEANING', /* LOOKUP */ MPA.APPROVED_BY_EMPLOYEE_ID, MPA.GL_ADJUST_ACCOUNT, MPA.CREATED_BY, MPA.CREATION_DATE, MPA.LAST_UPDATED_BY, MPA.LAST_UPDATE_DATE FROM MTL_PHYSICAL_ADJUSTMENTS MPA WHERE '_SEC:MPA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MPA.ADJUSTMENT_ID
, MPA.ORGANIZATION_ID
, MPA.PHYSICAL_INVENTORY_ID
, MPA.INVENTORY_ITEM_ID
, MPA.SYSTEM_QUANTITY
, MPA.COUNT_QUANTITY
, MPA.ADJUSTMENT_QUANTITY
, MPA.REVISION
, MPA.LOCATOR_ID
, MPA.SUBINVENTORY_NAME
, MPA.LOT_NUMBER
, MPA.LOT_EXPIRATION_DATE
, MPA.SERIAL_NUMBER
, MPA.ACTUAL_COST
, '_LA:MPA.APPROVAL_STATUS:MFG_LOOKUPS:MTL_APPROVALS:MEANING'
, /* LOOKUP */ MPA.APPROVED_BY_EMPLOYEE_ID
, MPA.GL_ADJUST_ACCOUNT
, MPA.CREATED_BY
, MPA.CREATION_DATE
, MPA.LAST_UPDATED_BY
, MPA.LAST_UPDATE_DATE
FROM MTL_PHYSICAL_ADJUSTMENTS MPA
WHERE '_SEC:MPA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY