View: MTL_CYCLE_COUNT_ENTRIES_ALL_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_CYCLE_COUNT_ENTRIES_ALL_V

View Text

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

Columns