DBA Data[Home] [Help] [Dependency Information]

TABLE: INV.MTL_CYCLE_COUNT_HEADERS

Object Details
Object Name: MTL_CYCLE_COUNT_HEADERS
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_CYCLE_COUNT_HEADERS
Subobject Name:
Status: VALID


MTL_CYCLE_COUNT_HEADERS stores information about cycle count names.
.
Oracle Inventory uses this information to keep track of all cycle
count names defined, to indicate tolerance/approval limits, cycle
count calendar and exception set, ABC initialization information,
scheduling options, and recount options.
.
A cycle count name is also a management entity, whose purpose is to
be the repository of cycle count requirements for a specific
application. A cycle count name is used in performance reports,
accuracy reports, and in grouping scheduling requests, count requests,
count entries and approvals.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_CYCLE_COUNT_HEADERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCYCLE_COUNT_HEADER_ID
MTL_CYCLE_COUNT_HEADERS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCYCLE_COUNT_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
CYCLE_COUNT_HEADER_ID NUMBER
Yes Cycle count identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CYCLE_COUNT_HEADER_NAME VARCHAR2 (30) Yes User-visible name of this cycle count
INVENTORY_ADJUSTMENT_ACCOUNT NUMBER
Yes GL account to which to post adjustment transactions
ORIENTATION_CODE NUMBER
Yes Scope of cycle count: organization-wide, or subset of subinventories
ABC_ASSIGNMENT_GROUP_ID NUMBER

ABC group from which item-classification was initialized
ONHAND_VISIBLE_FLAG NUMBER

Whether or not to display onhand quantity during count entry
DAYS_UNTIL_LATE NUMBER

Number of days after a count is scheduled that it is considered late
AUTOSCHEDULE_ENABLED_FLAG NUMBER
Yes Whether or not count-scheduling should be done automatically by Oracle Inventory
SCHEDULE_INTERVAL_TIME NUMBER

Time interval between two consecutive scheduling runs
ZERO_COUNT_FLAG NUMBER

Whether or not cycle counts should be requested for SKU's with system quantity of zero
HEADER_LAST_SCHEDULE_DATE DATE

Date of last scheduling run for this cycle count
HEADER_NEXT_SCHEDULE_DATE DATE

Date that this cycle count should next be scheduled
DISABLE_DATE DATE

Date this cycle count becomes inactive
APPROVAL_OPTION_CODE NUMBER

Approval required for adjustment transactions
AUTOMATIC_RECOUNT_FLAG NUMBER

Whether or not to automatically order a recount when a count is out of tolerance
NEXT_USER_COUNT_SEQUENCE NUMBER

Next sequence-number for the Count List Report
UNSCHEDULED_COUNT_ENTRY NUMBER

Whether or not to allow unscheduled counts to be entered
CYCLE_COUNT_CALENDAR VARCHAR2 (10)
Manufacturing calendar used by the cycle count scheduler
CALENDAR_EXCEPTION_SET NUMBER

Exception-set for the cycle count manufacturing calendar
APPROVAL_TOLERANCE_POSITIVE NUMBER

Positive percent tolerance, above which an adjustment transaction requires explicit approval
APPROVAL_TOLERANCE_NEGATIVE NUMBER

Negative percent tolerance, below which an adjustment transaction requires explicit approval
COST_TOLERANCE_POSITIVE NUMBER

Positive currency tolerance, above which an adjustment transaction requires explicit approval
COST_TOLERANCE_NEGATIVE NUMBER

Negative currency tolerance, below which an adjustment transaction requires explicit approval
HIT_MISS_TOLERANCE_POSITIVE NUMBER

Positive percent tolerance used for hit/miss analysis
HIT_MISS_TOLERANCE_NEGATIVE NUMBER

Negative percent tolerance used for hit/miss analysis
ABC_INITIALIZATION_STATUS NUMBER

Processing status of the item-initialization process
DESCRIPTION VARCHAR2 (240)
Description of this cycle count
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
MAXIMUM_AUTO_RECOUNTS NUMBER

Maximum number of recounts Oracle Inventory will automatically order
SERIAL_COUNT_OPTION NUMBER

Options for including serial controlled items in the count generation
SERIAL_DETAIL_OPTION NUMBER

Detail level for counting serial controlled items
SERIAL_ADJUSTMENT_OPTION NUMBER

Adjustment options for adjustment in serial controlled items
SERIAL_DISCREPANCY_OPTION NUMBER

"Allow/Do not allow" discrepancy while counting serial controlled items
CONTAINER_ADJUSTMENT_OPTION NUMBER

Container Adjustment Option - Used by WMS only
CONTAINER_DISCREPANCY_OPTION NUMBER

Container Discrepancy Option - Used by WMS only
CONTAINER_ENABLED_FLAG NUMBER

Container Option Enabled Flag - Used by WMS only
CYCLE_COUNT_TYPE NUMBER

Type of cycle count
SCHEDULE_EMPTY_LOCATIONS NUMBER

Schedule Empty Locations
DEFAULT_NUM_COUNTS_PER_YEAR NUMBER

Number of times a location in this subinventory should be counted per year at header level.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CYCLE_COUNT_HEADER_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CYCLE_COUNT_HEADER_NAME
,      INVENTORY_ADJUSTMENT_ACCOUNT
,      ORIENTATION_CODE
,      ABC_ASSIGNMENT_GROUP_ID
,      ONHAND_VISIBLE_FLAG
,      DAYS_UNTIL_LATE
,      AUTOSCHEDULE_ENABLED_FLAG
,      SCHEDULE_INTERVAL_TIME
,      ZERO_COUNT_FLAG
,      HEADER_LAST_SCHEDULE_DATE
,      HEADER_NEXT_SCHEDULE_DATE
,      DISABLE_DATE
,      APPROVAL_OPTION_CODE
,      AUTOMATIC_RECOUNT_FLAG
,      NEXT_USER_COUNT_SEQUENCE
,      UNSCHEDULED_COUNT_ENTRY
,      CYCLE_COUNT_CALENDAR
,      CALENDAR_EXCEPTION_SET
,      APPROVAL_TOLERANCE_POSITIVE
,      APPROVAL_TOLERANCE_NEGATIVE
,      COST_TOLERANCE_POSITIVE
,      COST_TOLERANCE_NEGATIVE
,      HIT_MISS_TOLERANCE_POSITIVE
,      HIT_MISS_TOLERANCE_NEGATIVE
,      ABC_INITIALIZATION_STATUS
,      DESCRIPTION
,      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
,      MAXIMUM_AUTO_RECOUNTS
,      SERIAL_COUNT_OPTION
,      SERIAL_DETAIL_OPTION
,      SERIAL_ADJUSTMENT_OPTION
,      SERIAL_DISCREPANCY_OPTION
,      CONTAINER_ADJUSTMENT_OPTION
,      CONTAINER_DISCREPANCY_OPTION
,      CONTAINER_ENABLED_FLAG
,      CYCLE_COUNT_TYPE
,      SCHEDULE_EMPTY_LOCATIONS
,      DEFAULT_NUM_COUNTS_PER_YEAR
FROM INV.MTL_CYCLE_COUNT_HEADERS;

Dependencies

[top of page]

INV.MTL_CYCLE_COUNT_HEADERS does not reference any database object

INV.MTL_CYCLE_COUNT_HEADERS is referenced by following:

SchemaAPPS
SynonymMTL_CYCLE_COUNT_HEADERS