[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_CC_ENTRIES_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_CC_ENTRIES_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
The MTL_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory's Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQL concurrent program, launched by the user, processes the information in this table, inserts/updates the MTL_CYCLE_COUNT_ENTRIES table, and spawns adjustment material transactions, if necessary.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_CC_ENTRIES_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CC_ENTRY_INTERFACE_ID
|
| MTL_CC_ENTRIES_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ACTION_CODE
CYCLE_COUNT_HEADER_ID
|
| MTL_CC_ENTRIES_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ORGANIZATION_ID
INVENTORY_ITEM_ID
LOCATOR_ID
|
| MTL_CC_ENTRIES_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CYCLE_COUNT_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CC_ENTRY_INTERFACE_ID | NUMBER | (38) | Yes | Unique identifier for each row |
| ORGANIZATION_ID | NUMBER | (38) | Yes | Organization identifier |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (38) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (38) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
| CC_ENTRY_INTERFACE_GROUP_ID | NUMBER | (38) | Identifier used to group interface records into a set | |
| CYCLE_COUNT_ENTRY_ID | NUMBER | (38) | If this data record was exported, the unambiguous primary key is referenced in this column. | |
| ACTION_CODE | NUMBER | (38) | Yes | Action code identifying which user actions/APIs to perform for the current record |
| CYCLE_COUNT_HEADER_ID | NUMBER | (38) | Cycle count identifier | |
| CYCLE_COUNT_HEADER_NAME | VARCHAR2 | (30) | User visible name of this cycle count. The identifier by which each entry in the interface table is tied to a particular cycle count. | |
| COUNT_LIST_SEQUENCE | NUMBER | (38) | Input which identifies a particular open count request for the specified cycle count. If a corresponding open count request is found that matches the specified count sequence, then the item and SKU information is defaulted from the MTL_CYCLE_COUNT_ENTRIES table. Otherwise the count request in the interface table is treated as an unscheduled count and the count sequence is inserted into the table along with the rest of the count request information. In this case, the item and SKU information is required. | |
| INVENTORY_ITEM_ID | NUMBER | (38) | Unique identifier of the inventory item | |
| ITEM_SEGMENT1 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT2 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT3 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT4 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT5 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT6 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT7 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT8 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT9 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT10 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT11 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT12 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT13 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT14 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT15 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT16 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT17 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT18 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT19 | VARCHAR2 | (40) | Item Segment column | |
| ITEM_SEGMENT20 | VARCHAR2 | (40) | Item Segment column | |
| REVISION | VARCHAR2 | (3) | Revision of item if under revision control | |
| SUBINVENTORY | VARCHAR2 | (10) | Name of subinventory | |
| LOCATOR_ID | NUMBER | (38) | Unique identifier of the locator | |
| LOCATOR_SEGMENT1 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT2 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT3 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT4 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT5 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT6 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT7 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT8 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT9 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT10 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT11 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT12 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT13 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT14 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT15 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT16 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT17 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT18 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT19 | VARCHAR2 | (40) | Locator Segment column | |
| LOCATOR_SEGMENT20 | VARCHAR2 | (40) | Locator Segment column | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot number if item is under lot control | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial number if item is under serial control | |
| PRIMARY_UOM_QUANTITY | NUMBER | Quantity of count at items primary unit of measure | ||
| COUNT_UOM | VARCHAR2 | (3) | UOM code of count | |
| COUNT_UNIT_OF_MEASURE | VARCHAR2 | (25) | UOM meaning of count | |
| COUNT_QUANTITY | NUMBER | Count quantity | ||
| ADJUSTMENT_ACCOUNT_ID | NUMBER | (38) | Unique identifier of adjustment account | |
| ACCOUNT_SEGMENT1 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT2 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT3 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT4 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT5 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT6 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT7 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT8 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT9 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT10 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT11 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT12 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT13 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT14 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT15 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT16 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT17 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT18 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT19 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT20 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT21 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT22 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT23 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT24 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT25 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT26 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT27 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT28 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT29 | VARCHAR2 | (25) | Account Segment column | |
| ACCOUNT_SEGMENT30 | VARCHAR2 | (25) | Account Segment column | |
| COUNT_DATE | DATE | Count date for current count request. This date is also used as the transaction date and approval date should an adjustment transaction be necessary. If this date is NULL, sysdate is defaulted for the count date | ||
| EMPLOYEE_ID | NUMBER | (38) | Employee identifier | |
| EMPLOYEE_FULL_NAME | VARCHAR2 | (240) | Employee who performed the current count request/approval action | |
| REFERENCE | VARCHAR2 | (240) | Reference for current count request. Also used as the transaction reference should an adjustment transaction be required | |
| TRANSACTION_REASON_ID | NUMBER | (38) | Transaction reason identifier | |
| TRANSACTION_REASON | VARCHAR2 | (30) | Reason for the current row's cycle count entry as well as any necessary inventory adjustment transaction | |
| REQUEST_ID | NUMBER | (38) | Standard Who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (38) | Standard Who column | |
| PROGRAM_ID | NUMBER | (38) | Standard Who column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
| LOCK_FLAG | NUMBER | (1) | Lock Flag, 1 - LOCK, 2 - UNLOCK | |
| PROCESS_FLAG | NUMBER | (1) | Process Flag, 1 - READY, 2 - NOT READY | |
| PROCESS_MODE | NUMBER | (1) | Process Mode, 1 - Online, 2 - Concurrent, 3 - Background | |
| VALID_FLAG | NUMBER | (1) | Valid Flag, 1 - VALID, 2 - INVALID | |
| DELETE_FLAG | NUMBER | (1) | Deleted Flag, 1 - YES, 2 - NO | |
| STATUS_FLAG | NUMBER | (38) | Statu Flag, 0-successful completed, 1-successful completed with warnings,2- processed with errors, 3 marked for recounting, 4 marked for reprocessing | |
| ERROR_FLAG | NUMBER | (38) | Error Flag, 1 - YES an error occurs, 2 - NO errors, NULL - not processed | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
| PROJECT_ID | NUMBER | (38) | Project identifier for future use | |
| TASK_ID | NUMBER | (38) | Task identifier for future use | |
| SYSTEM_QUANTITY | NUMBER | System quantity. This information will be inserted, if this row is exported. | ||
| PARENT_LPN_ID | NUMBER | Parent LPN ID - Used by WMS only | ||
| OUTERMOST_LPN_ID | NUMBER | Outermost LPN ID - Used by WMS only | ||
| PARENT_LPN | VARCHAR2 | (30) | Parent LPN - Used by WMS only | |
| COST_GROUP_ID | NUMBER | Cost group ID - Used by WMS only | ||
| COST_GROUP_NAME | VARCHAR2 | (10) | Cost group name - Used by WMS only | |
| SECONDARY_COUNT_QUANTITY | NUMBER | Secondary Count Quantity | ||
| SECONDARY_SYSTEM_QUANTITY | NUMBER | Secondary System Quantity | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Secondary Unit of Measure Meaning | |
| SECONDARY_UOM | VARCHAR2 | (3) | Secondary Unit of Measure |
Cut, paste (and edit) the following text to query this object:
SELECT CC_ENTRY_INTERFACE_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CC_ENTRY_INTERFACE_GROUP_ID
, CYCLE_COUNT_ENTRY_ID
, ACTION_CODE
, CYCLE_COUNT_HEADER_ID
, CYCLE_COUNT_HEADER_NAME
, COUNT_LIST_SEQUENCE
, INVENTORY_ITEM_ID
, ITEM_SEGMENT1
, ITEM_SEGMENT2
, ITEM_SEGMENT3
, ITEM_SEGMENT4
, ITEM_SEGMENT5
, ITEM_SEGMENT6
, ITEM_SEGMENT7
, ITEM_SEGMENT8
, ITEM_SEGMENT9
, ITEM_SEGMENT10
, ITEM_SEGMENT11
, ITEM_SEGMENT12
, ITEM_SEGMENT13
, ITEM_SEGMENT14
, ITEM_SEGMENT15
, ITEM_SEGMENT16
, ITEM_SEGMENT17
, ITEM_SEGMENT18
, ITEM_SEGMENT19
, ITEM_SEGMENT20
, REVISION
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR_SEGMENT1
, LOCATOR_SEGMENT2
, LOCATOR_SEGMENT3
, LOCATOR_SEGMENT4
, LOCATOR_SEGMENT5
, LOCATOR_SEGMENT6
, LOCATOR_SEGMENT7
, LOCATOR_SEGMENT8
, LOCATOR_SEGMENT9
, LOCATOR_SEGMENT10
, LOCATOR_SEGMENT11
, LOCATOR_SEGMENT12
, LOCATOR_SEGMENT13
, LOCATOR_SEGMENT14
, LOCATOR_SEGMENT15
, LOCATOR_SEGMENT16
, LOCATOR_SEGMENT17
, LOCATOR_SEGMENT18
, LOCATOR_SEGMENT19
, LOCATOR_SEGMENT20
, LOT_NUMBER
, SERIAL_NUMBER
, PRIMARY_UOM_QUANTITY
, COUNT_UOM
, COUNT_UNIT_OF_MEASURE
, COUNT_QUANTITY
, ADJUSTMENT_ACCOUNT_ID
, ACCOUNT_SEGMENT1
, ACCOUNT_SEGMENT2
, ACCOUNT_SEGMENT3
, ACCOUNT_SEGMENT4
, ACCOUNT_SEGMENT5
, ACCOUNT_SEGMENT6
, ACCOUNT_SEGMENT7
, ACCOUNT_SEGMENT8
, ACCOUNT_SEGMENT9
, ACCOUNT_SEGMENT10
, ACCOUNT_SEGMENT11
, ACCOUNT_SEGMENT12
, ACCOUNT_SEGMENT13
, ACCOUNT_SEGMENT14
, ACCOUNT_SEGMENT15
, ACCOUNT_SEGMENT16
, ACCOUNT_SEGMENT17
, ACCOUNT_SEGMENT18
, ACCOUNT_SEGMENT19
, ACCOUNT_SEGMENT20
, ACCOUNT_SEGMENT21
, ACCOUNT_SEGMENT22
, ACCOUNT_SEGMENT23
, ACCOUNT_SEGMENT24
, ACCOUNT_SEGMENT25
, ACCOUNT_SEGMENT26
, ACCOUNT_SEGMENT27
, ACCOUNT_SEGMENT28
, ACCOUNT_SEGMENT29
, ACCOUNT_SEGMENT30
, COUNT_DATE
, EMPLOYEE_ID
, EMPLOYEE_FULL_NAME
, REFERENCE
, TRANSACTION_REASON_ID
, TRANSACTION_REASON
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LOCK_FLAG
, PROCESS_FLAG
, PROCESS_MODE
, VALID_FLAG
, DELETE_FLAG
, STATUS_FLAG
, ERROR_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROJECT_ID
, TASK_ID
, SYSTEM_QUANTITY
, PARENT_LPN_ID
, OUTERMOST_LPN_ID
, PARENT_LPN
, COST_GROUP_ID
, COST_GROUP_NAME
, SECONDARY_COUNT_QUANTITY
, SECONDARY_SYSTEM_QUANTITY
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM
FROM INV.MTL_CC_ENTRIES_INTERFACE;
INV.MTL_CC_ENTRIES_INTERFACE does not reference any database object
INV.MTL_CC_ENTRIES_INTERFACE is referenced by following:
APPS
MTL_CC_ENTRIES_INTERFACE
MTL_CC_ENTRIES_INTERFACE_T1
|
|
|
|