VIEW: APPS.MTL_CYCLE_COUNT_ENTRIES_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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