VIEW: APPS.INVBV_CYCLE_COUNT_ADJUSTMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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