View: INVBV_CYCLE_COUNT_ADJUSTMENTS

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

View Text

SELECT MCE.CYCLE_COUNT_ENTRY_ID
, MCE.COUNT_DATE_FIRST
, MCE.COUNT_DATE_CURRENT
, MCE.COUNT_DATE_PRIOR
, MCE.COUNTED_BY_EMPLOYEE_ID_FIRST
, MCE.COUNTED_BY_EMPLOYEE_ID_CURRENT
, MCE.COUNTED_BY_EMPLOYEE_ID_PRIOR
, MCE.COUNT_UOM_FIRST
, MCE.COUNT_UOM_CURRENT
, MCE.COUNT_UOM_PRIOR
, MCE.COUNT_QUANTITY_FIRST
, MCE.COUNT_QUANTITY_CURRENT
, MCE.COUNT_QUANTITY_PRIOR
, MCE.INVENTORY_ITEM_ID
, MCE.SUBINVENTORY
, '_LA:MCE.ENTRY_STATUS_CODE:MFG_LOOKUPS:MTL_CC_ENTRY_STATUSES:MEANING'
, MCE.COUNT_DUE_DATE
, MCE.ORGANIZATION_ID
, MCE.CYCLE_COUNT_HEADER_ID
, MCE.NUMBER_OF_COUNTS
, MCE.LOCATOR_ID
, MCE.ADJUSTMENT_QUANTITY
, MCE.ADJUSTMENT_DATE
, MCE.ADJUSTMENT_AMOUNT
, MCE.ITEM_UNIT_COST
, MCE.INVENTORY_ADJUSTMENT_ACCOUNT
, MCE.APPROVAL_DATE
, MCE.APPROVER_EMPLOYEE_ID
, MCE.REVISION
, MCE.LOT_NUMBER
, MCE.LOT_CONTROL
, MCE.SYSTEM_QUANTITY_FIRST
, MCE.SYSTEM_QUANTITY_CURRENT
, MCE.SYSTEM_QUANTITY_PRIOR
, MCE.REFERENCE_FIRST
, MCE.REFERENCE_CURRENT
, MCE.REFERENCE_PRIOR
, MCE.PRIMARY_UOM_QUANTITY_FIRST
, MCE.PRIMARY_UOM_QUANTITY_CURRENT
, MCE.PRIMARY_UOM_QUANTITY_PRIOR
, '_LA:MCE.COUNT_TYPE_CODE:MFG_LOOKUPS:MTL_CC_COUNT_TYPES:MEANING'
, MCE.TRANSACTION_REASON_ID
, '_LA:MCE.APPROVAL_TYPE:MFG_LOOKUPS:MTL_CC_APPROVAL_TYPES:MEANING'
, MCE.SERIAL_NUMBER
, '_LA:MCE.SERIAL_DETAIL:MFG_LOOKUPS:MTL_CC_SERIAL_DETAIL_OPTIONS:MEANING'
, '_LA:MCE.APPROVAL_CONDITION:MFG_LOOKUPS:MTL_CC_APPROVAL_CONDITION:MEANING'
, MCE.NEG_ADJUSTMENT_QUANTITY
, MCE.NEG_ADJUSTMENT_AMOUNT
, MCE.CREATED_BY
, MCE.CREATION_DATE
, MCE.LAST_UPDATED_BY
, MCE.LAST_UPDATE_DATE
FROM MTL_CYCLE_COUNT_ENTRIES MCE
WHERE '_SEC:MCE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns