[Home] [Help] [Dependency Information]
Object Name: | MTL_CC_SUBINVENTORIES |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_CC_SUBINVENTORIES |
Subobject Name: | |
Status: | VALID |
MTL_CC_SUBINVENTORIES stores all the subinventories that are to be
considered for cycle counting when the scope of the cycle count
is at subinventory level. The table is not used if the cycle count is
at organization level.
.
Oracle Inventory uses this information in the automatic
scheduling feature of cycle counting and for validation purpose when
schedule requests are manually entered.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_CC_SUBINVENTORIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CYCLE_COUNT_HEADER_ID
SUBINVENTORY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CYCLE_COUNT_HEADER_ID | NUMBER | Yes | Cycle count identifier | |
SUBINVENTORY | VARCHAR2 | (10) | Yes | Subinventory name |
DISABLE_FLAG | NUMBER | Flag indicating whether the cycle count subinventory will be used when exploding count requests | ||
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 | ||
NUM_COUNTS_PER_YEAR | NUMBER | Number of times a location in this subinventory should be counted per year | ||
LOC_LAST_SCHEDULE_DATE | DATE | Date location was last scheduled to be counted | ||
SCHEDULE_ORDER | NUMBER | Order in which location will be scheduled, relative to the schedule-order of other locations within this cycle count |
Cut, paste (and edit) the following text to query this object:
SELECT CYCLE_COUNT_HEADER_ID
, SUBINVENTORY
, DISABLE_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NUM_COUNTS_PER_YEAR
, LOC_LAST_SCHEDULE_DATE
, SCHEDULE_ORDER
FROM INV.MTL_CC_SUBINVENTORIES;
INV.MTL_CC_SUBINVENTORIES does not reference any database object
INV.MTL_CC_SUBINVENTORIES is referenced by following:
|
|
|