VIEW: INV.MTL_CYCLE_COUNT_ENTRIES#

Source

View Text - Preformatted

select CYCLE_COUNT_ENTRY_ID CYCLE_COUNT_ENTRY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COUNT_LIST_SEQUENCE COUNT_LIST_SEQUENCE, COUNT_DATE_FIRST COUNT_DATE_FIRST, COUNT_DATE_CURRENT COUNT_DATE_CURRENT, COUNT_DATE_PRIOR COUNT_DATE_PRIOR, COUNT_DATE_DUMMY COUNT_DATE_DUMMY, COUNTED_BY_EMPLOYEE_ID_FIRST COUNTED_BY_EMPLOYEE_ID_FIRST, COUNTED_BY_EMPLOYEE_ID_CURRENT COUNTED_BY_EMPLOYEE_ID_CURRENT, COUNTED_BY_EMPLOYEE_ID_PRIOR COUNTED_BY_EMPLOYEE_ID_PRIOR, COUNTED_BY_EMPLOYEE_ID_DUMMY COUNTED_BY_EMPLOYEE_ID_DUMMY, COUNT_UOM_FIRST COUNT_UOM_FIRST, COUNT_UOM_CURRENT COUNT_UOM_CURRENT, COUNT_UOM_PRIOR COUNT_UOM_PRIOR, COUNT_QUANTITY_FIRST COUNT_QUANTITY_FIRST, COUNT_QUANTITY_CURRENT COUNT_QUANTITY_CURRENT, COUNT_QUANTITY_PRIOR COUNT_QUANTITY_PRIOR, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SUBINVENTORY SUBINVENTORY, ENTRY_STATUS_CODE ENTRY_STATUS_CODE, COUNT_DUE_DATE COUNT_DUE_DATE, ORGANIZATION_ID ORGANIZATION_ID, CYCLE_COUNT_HEADER_ID CYCLE_COUNT_HEADER_ID, NUMBER_OF_COUNTS NUMBER_OF_COUNTS, LOCATOR_ID LOCATOR_ID, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY, ADJUSTMENT_DATE ADJUSTMENT_DATE, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT, ITEM_UNIT_COST ITEM_UNIT_COST, INVENTORY_ADJUSTMENT_ACCOUNT INVENTORY_ADJUSTMENT_ACCOUNT, APPROVAL_DATE APPROVAL_DATE, APPROVER_EMPLOYEE_ID APPROVER_EMPLOYEE_ID, REVISION REVISION, LOT_NUMBER LOT_NUMBER, LOT_CONTROL LOT_CONTROL, SYSTEM_QUANTITY_FIRST SYSTEM_QUANTITY_FIRST, SYSTEM_QUANTITY_CURRENT SYSTEM_QUANTITY_CURRENT, SYSTEM_QUANTITY_PRIOR SYSTEM_QUANTITY_PRIOR, REFERENCE_FIRST REFERENCE_FIRST, REFERENCE_CURRENT REFERENCE_CURRENT, REFERENCE_PRIOR REFERENCE_PRIOR, PRIMARY_UOM_QUANTITY_FIRST PRIMARY_UOM_QUANTITY_FIRST, PRIMARY_UOM_QUANTITY_CURRENT PRIMARY_UOM_QUANTITY_CURRENT, PRIMARY_UOM_QUANTITY_PRIOR PRIMARY_UOM_QUANTITY_PRIOR, COUNT_TYPE_CODE COUNT_TYPE_CODE, TRANSACTION_REASON_ID TRANSACTION_REASON_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, APPROVAL_TYPE APPROVAL_TYPE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SERIAL_NUMBER SERIAL_NUMBER, SERIAL_DETAIL SERIAL_DETAIL, APPROVAL_CONDITION APPROVAL_CONDITION, NEG_ADJUSTMENT_QUANTITY NEG_ADJUSTMENT_QUANTITY, NEG_ADJUSTMENT_AMOUNT NEG_ADJUSTMENT_AMOUNT, EXPORT_FLAG EXPORT_FLAG, PARENT_LPN_ID PARENT_LPN_ID, OUTERMOST_LPN_ID OUTERMOST_LPN_ID, STANDARD_OPERATION_ID STANDARD_OPERATION_ID, TASK_PRIORITY TASK_PRIORITY, COST_GROUP_ID COST_GROUP_ID, SECONDARY_UOM_QUANTITY_FIRST SECONDARY_UOM_QUANTITY_FIRST, SECONDARY_UOM_QUANTITY_CURRENT SECONDARY_UOM_QUANTITY_CURRENT, SECONDARY_UOM_QUANTITY_PRIOR SECONDARY_UOM_QUANTITY_PRIOR, COUNT_SECONDARY_UOM_FIRST COUNT_SECONDARY_UOM_FIRST, COUNT_SECONDARY_UOM_CURRENT COUNT_SECONDARY_UOM_CURRENT, COUNT_SECONDARY_UOM_PRIOR COUNT_SECONDARY_UOM_PRIOR, SECONDARY_ADJUSTMENT_QUANTITY SECONDARY_ADJUSTMENT_QUANTITY, SECONDARY_SYSTEM_QTY_CURRENT SECONDARY_SYSTEM_QTY_CURRENT, SECONDARY_SYSTEM_QTY_FIRST SECONDARY_SYSTEM_QTY_FIRST, SECONDARY_SYSTEM_QTY_PRIOR SECONDARY_SYSTEM_QTY_PRIOR from "INV"."MTL_CYCLE_COUNT_ENTRIES"

View Text - HTML Formatted

SELECT CYCLE_COUNT_ENTRY_ID CYCLE_COUNT_ENTRY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COUNT_LIST_SEQUENCE COUNT_LIST_SEQUENCE
, COUNT_DATE_FIRST COUNT_DATE_FIRST
, COUNT_DATE_CURRENT COUNT_DATE_CURRENT
, COUNT_DATE_PRIOR COUNT_DATE_PRIOR
, COUNT_DATE_DUMMY COUNT_DATE_DUMMY
, COUNTED_BY_EMPLOYEE_ID_FIRST COUNTED_BY_EMPLOYEE_ID_FIRST
, COUNTED_BY_EMPLOYEE_ID_CURRENT COUNTED_BY_EMPLOYEE_ID_CURRENT
, COUNTED_BY_EMPLOYEE_ID_PRIOR COUNTED_BY_EMPLOYEE_ID_PRIOR
, COUNTED_BY_EMPLOYEE_ID_DUMMY COUNTED_BY_EMPLOYEE_ID_DUMMY
, COUNT_UOM_FIRST COUNT_UOM_FIRST
, COUNT_UOM_CURRENT COUNT_UOM_CURRENT
, COUNT_UOM_PRIOR COUNT_UOM_PRIOR
, COUNT_QUANTITY_FIRST COUNT_QUANTITY_FIRST
, COUNT_QUANTITY_CURRENT COUNT_QUANTITY_CURRENT
, COUNT_QUANTITY_PRIOR COUNT_QUANTITY_PRIOR
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUBINVENTORY SUBINVENTORY
, ENTRY_STATUS_CODE ENTRY_STATUS_CODE
, COUNT_DUE_DATE COUNT_DUE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, CYCLE_COUNT_HEADER_ID CYCLE_COUNT_HEADER_ID
, NUMBER_OF_COUNTS NUMBER_OF_COUNTS
, LOCATOR_ID LOCATOR_ID
, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY
, ADJUSTMENT_DATE ADJUSTMENT_DATE
, ADJUSTMENT_AMOUNT ADJUSTMENT_AMOUNT
, ITEM_UNIT_COST ITEM_UNIT_COST
, INVENTORY_ADJUSTMENT_ACCOUNT INVENTORY_ADJUSTMENT_ACCOUNT
, APPROVAL_DATE APPROVAL_DATE
, APPROVER_EMPLOYEE_ID APPROVER_EMPLOYEE_ID
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, LOT_CONTROL LOT_CONTROL
, SYSTEM_QUANTITY_FIRST SYSTEM_QUANTITY_FIRST
, SYSTEM_QUANTITY_CURRENT SYSTEM_QUANTITY_CURRENT
, SYSTEM_QUANTITY_PRIOR SYSTEM_QUANTITY_PRIOR
, REFERENCE_FIRST REFERENCE_FIRST
, REFERENCE_CURRENT REFERENCE_CURRENT
, REFERENCE_PRIOR REFERENCE_PRIOR
, PRIMARY_UOM_QUANTITY_FIRST PRIMARY_UOM_QUANTITY_FIRST
, PRIMARY_UOM_QUANTITY_CURRENT PRIMARY_UOM_QUANTITY_CURRENT
, PRIMARY_UOM_QUANTITY_PRIOR PRIMARY_UOM_QUANTITY_PRIOR
, COUNT_TYPE_CODE COUNT_TYPE_CODE
, TRANSACTION_REASON_ID TRANSACTION_REASON_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, APPROVAL_TYPE APPROVAL_TYPE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SERIAL_NUMBER SERIAL_NUMBER
, SERIAL_DETAIL SERIAL_DETAIL
, APPROVAL_CONDITION APPROVAL_CONDITION
, NEG_ADJUSTMENT_QUANTITY NEG_ADJUSTMENT_QUANTITY
, NEG_ADJUSTMENT_AMOUNT NEG_ADJUSTMENT_AMOUNT
, EXPORT_FLAG EXPORT_FLAG
, PARENT_LPN_ID PARENT_LPN_ID
, OUTERMOST_LPN_ID OUTERMOST_LPN_ID
, STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, TASK_PRIORITY TASK_PRIORITY
, COST_GROUP_ID COST_GROUP_ID
, SECONDARY_UOM_QUANTITY_FIRST SECONDARY_UOM_QUANTITY_FIRST
, SECONDARY_UOM_QUANTITY_CURRENT SECONDARY_UOM_QUANTITY_CURRENT
, SECONDARY_UOM_QUANTITY_PRIOR SECONDARY_UOM_QUANTITY_PRIOR
, COUNT_SECONDARY_UOM_FIRST COUNT_SECONDARY_UOM_FIRST
, COUNT_SECONDARY_UOM_CURRENT COUNT_SECONDARY_UOM_CURRENT
, COUNT_SECONDARY_UOM_PRIOR COUNT_SECONDARY_UOM_PRIOR
, SECONDARY_ADJUSTMENT_QUANTITY SECONDARY_ADJUSTMENT_QUANTITY
, SECONDARY_SYSTEM_QTY_CURRENT SECONDARY_SYSTEM_QTY_CURRENT
, SECONDARY_SYSTEM_QTY_FIRST SECONDARY_SYSTEM_QTY_FIRST
, SECONDARY_SYSTEM_QTY_PRIOR SECONDARY_SYSTEM_QTY_PRIOR
FROM "INV"."MTL_CYCLE_COUNT_ENTRIES"