[Home] [Help] [Dependency Information]
Object Name: | MTL_CYCLE_COUNT_ENTRIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.MTL_CYCLE_COUNT_ENTRIES_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CYCLE_COUNT_ENTRY_ID | NUMBER | Yes | ||
COUNT_LIST_SEQUENCE | NUMBER | |||
COUNT_DATE_FIRST | DATE | |||
COUNT_DATE_CURRENT | DATE | |||
COUNT_DATE_PRIOR | DATE | |||
COUNT_DATE_DUMMY | DATE | |||
COUNTED_BY_EMPLOYEE_ID_FIRST | NUMBER | |||
COUNTED_BY_EMPLOYEE_ID_CURRENT | NUMBER | |||
COUNTED_BY_EMPLOYEE_ID_PRIOR | NUMBER | |||
COUNTED_BY_EMPLOYEE_ID_DUMMY | NUMBER | |||
APPROVER_EMPLOYEE_ID | NUMBER | |||
COUNT_UOM_FIRST | VARCHAR2 | (3) | ||
COUNT_UOM_CURRENT | VARCHAR2 | (3) | ||
COUNT_UOM_PRIOR | VARCHAR2 | (3) | ||
COUNT_QUANTITY_FIRST | NUMBER | |||
COUNT_QUANTITY_CURRENT | NUMBER | |||
COUNT_QUANTITY_PRIOR | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
LOT_CONTROL_CODE | NUMBER | |||
REVISION_QTY_CONTROL_CODE | NUMBER | |||
RESTRICT_SUBINVENTORIES_CODE | NUMBER | |||
RESTRICT_LOCATORS_CODE | NUMBER | |||
UOM_TYPE | NUMBER | |||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
LOCATION_CONTROL_CODE | NUMBER | |||
POSITIVE_MEASUREMENT_ERROR | NUMBER | |||
NEGATIVE_MEASUREMENT_ERROR | NUMBER | |||
SERIAL_NUMBER_CONTROL_CODE | NUMBER | |||
SUBINVENTORY | VARCHAR2 | (10) | Yes | |
ENTRY_STATUS_CODE | NUMBER | |||
COUNT_DUE_DATE | DATE | |||
ORGANIZATION_ID | NUMBER | Yes | ||
CYCLE_COUNT_HEADER_ID | NUMBER | Yes | ||
NUMBER_OF_COUNTS | NUMBER | |||
LOCATOR_ID | NUMBER | |||
ADJUSTMENT_QUANTITY | NUMBER | |||
ADJUSTMENT_DATE | DATE | |||
ADJUSTMENT_AMOUNT | NUMBER | |||
NEG_ADJUSTMENT_QUANTITY | NUMBER | |||
NEG_ADJUSTMENT_AMOUNT | NUMBER | |||
ITEM_UNIT_COST | NUMBER | |||
INVENTORY_ADJUSTMENT_ACCOUNT | NUMBER | |||
APPROVAL_DATE | DATE | |||
REVISION | VARCHAR2 | (3) | ||
LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_CONTROL | VARCHAR2 | (1) | ||
SERIAL_DETAIL | NUMBER | |||
APPROVAL_CONDITION | NUMBER | |||
APPROVAL_CONDITION_MEANING | VARCHAR2 | (80) | ||
SERIAL_NUMBER | VARCHAR2 | (30) | ||
SYSTEM_QUANTITY_FIRST | NUMBER | |||
SYSTEM_QUANTITY_CURRENT | NUMBER | |||
SYSTEM_QUANTITY_PRIOR | NUMBER | |||
REFERENCE_FIRST | VARCHAR2 | (240) | ||
REFERENCE_CURRENT | VARCHAR2 | (240) | ||
REFERENCE_PRIOR | VARCHAR2 | (240) | ||
PRIMARY_UOM_QUANTITY_FIRST | NUMBER | |||
PRIMARY_UOM_QUANTITY_CURRENT | NUMBER | |||
PRIMARY_UOM_QUANTITY_PRIOR | NUMBER | |||
COUNT_TYPE_CODE | NUMBER | |||
TRANSACTION_REASON_ID | NUMBER | |||
REASON_NAME | VARCHAR2 | (30) | ||
REASON_DESCRIPTION | VARCHAR2 | (240) | ||
APPROVAL_TYPE | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ABC_CLASS_ID | NUMBER | Yes | ||
APPROVAL_TOLERANCE_POSITIVE | NUMBER | |||
APPROVAL_TOLERANCE_NEGATIVE | NUMBER | |||
ABC_CLASS_NAME | VARCHAR2 | (40) | Yes | |
CLASS_APP_TOL_POS | NUMBER | |||
CLASS_APP_TOL_NEG | NUMBER | |||
CLASS_COST_TOL_POS | NUMBER | |||
CLASS_COST_TOL_NEG | NUMBER | |||
APPROVAL_STATUS | NUMBER | |||
COUNT_STATUS | VARCHAR2 | (80) | Yes | |
EXPORT_FLAG | NUMBER | |||
PARENT_LPN_ID | NUMBER | |||
OUTERMOST_LPN_ID | NUMBER | |||
STANDARD_OPERATION_ID | NUMBER | |||
TASK_PRIORITY | NUMBER | |||
PARENT_LPN | VARCHAR2 | (30) | ||
OUTERMOST_LPN | VARCHAR2 | (30) | ||
CONTAINER_ITEM_ID | NUMBER | |||
CONTAINER_REVISION | VARCHAR2 | (3) | ||
CONTAINER_LOT_NUMBER | VARCHAR2 | (80) | ||
CONTAINER_SERIAL_NUMBER | VARCHAR2 | (30) | ||
COST_GROUP_ID | NUMBER | |||
COST_GROUP_NAME | VARCHAR2 | (10) | ||
CONTAINER_COST_GROUP_ID | NUMBER | |||
CONTAINER_COST_GROUP_NAME | VARCHAR2 | (10) | ||
SECONDARY_ADJUSTMENT_QUANTITY | NUMBER | |||
SECONDARY_SYSTEM_QTY_FIRST | NUMBER | |||
SECONDARY_SYSTEM_QTY_CURRENT | NUMBER | |||
SECONDARY_SYSTEM_QTY_PRIOR | NUMBER | |||
SECONDARY_UOM_QUANTITY_FIRST | NUMBER | |||
SECONDARY_UOM_QUANTITY_CURRENT | NUMBER | |||
SECONDARY_UOM_QUANTITY_PRIOR | NUMBER | |||
COUNT_SECONDARY_UOM_FIRST | VARCHAR2 | (3) | ||
COUNT_SECONDARY_UOM_CURRENT | VARCHAR2 | (3) | ||
COUNT_SECONDARY_UOM_PRIOR | VARCHAR2 | (3) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CYCLE_COUNT_ENTRY_ID
, 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
, APPROVER_EMPLOYEE_ID
, COUNT_UOM_FIRST
, COUNT_UOM_CURRENT
, COUNT_UOM_PRIOR
, COUNT_QUANTITY_FIRST
, COUNT_QUANTITY_CURRENT
, COUNT_QUANTITY_PRIOR
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, LOT_CONTROL_CODE
, REVISION_QTY_CONTROL_CODE
, RESTRICT_SUBINVENTORIES_CODE
, RESTRICT_LOCATORS_CODE
, UOM_TYPE
, PRIMARY_UOM_CODE
, LOCATION_CONTROL_CODE
, POSITIVE_MEASUREMENT_ERROR
, NEGATIVE_MEASUREMENT_ERROR
, SERIAL_NUMBER_CONTROL_CODE
, 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
, REVISION
, LOT_NUMBER
, LOT_CONTROL
, SERIAL_DETAIL
, APPROVAL_CONDITION
, APPROVAL_CONDITION_MEANING
, SERIAL_NUMBER
, 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
, REASON_NAME
, REASON_DESCRIPTION
, APPROVAL_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ABC_CLASS_ID
, APPROVAL_TOLERANCE_POSITIVE
, APPROVAL_TOLERANCE_NEGATIVE
, ABC_CLASS_NAME
, CLASS_APP_TOL_POS
, CLASS_APP_TOL_NEG
, CLASS_COST_TOL_POS
, CLASS_COST_TOL_NEG
, APPROVAL_STATUS
, COUNT_STATUS
, EXPORT_FLAG
, PARENT_LPN_ID
, OUTERMOST_LPN_ID
, STANDARD_OPERATION_ID
, TASK_PRIORITY
, PARENT_LPN
, OUTERMOST_LPN
, CONTAINER_ITEM_ID
, CONTAINER_REVISION
, CONTAINER_LOT_NUMBER
, CONTAINER_SERIAL_NUMBER
, COST_GROUP_ID
, COST_GROUP_NAME
, CONTAINER_COST_GROUP_ID
, CONTAINER_COST_GROUP_NAME
, 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 APPS.MTL_CYCLE_COUNT_ENTRIES_V;
|
|
|