[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_CC_ENTRIES_INTERFACE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  INV.MTL_CC_ENTRIES_INTERFACE_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) | ||
| CC_ENTRY_INTERFACE_ID | NUMBER | (38) | Yes | |
| ORGANIZATION_ID | NUMBER | (38) | Yes | |
| ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (38) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (38) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (38) | ||
| CC_ENTRY_INTERFACE_GROUP_ID | NUMBER | (38) | ||
| CYCLE_COUNT_ENTRY_ID | NUMBER | (38) | ||
| ACTION_CODE | NUMBER | (38) | Yes | |
| CYCLE_COUNT_HEADER_ID | NUMBER | (38) | ||
| CYCLE_COUNT_HEADER_NAME | VARCHAR2 | (30) | ||
| COUNT_LIST_SEQUENCE | NUMBER | (38) | ||
| INVENTORY_ITEM_ID | NUMBER | (38) | ||
| ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| ITEM_SEGMENT1 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT2 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT3 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT4 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT5 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT6 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT7 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT8 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT9 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT10 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT11 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT12 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT13 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT14 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT15 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT16 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT17 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT18 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT19 | VARCHAR2 | (40) | ||
| ITEM_SEGMENT20 | VARCHAR2 | (40) | ||
| REVISION | VARCHAR2 | (3) | ||
| SUBINVENTORY | VARCHAR2 | (10) | ||
| LOCATOR_ID | NUMBER | (38) | ||
| LOCATOR_SEGMENT1 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT2 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT3 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT4 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT5 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT6 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT7 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT8 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT9 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT10 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT11 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT12 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT13 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT14 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT15 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT16 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT17 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT18 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT19 | VARCHAR2 | (40) | ||
| LOCATOR_SEGMENT20 | VARCHAR2 | (40) | ||
| LOT_NUMBER | VARCHAR2 | (80) | ||
| SERIAL_NUMBER | VARCHAR2 | (30) | ||
| PRIMARY_UOM_QUANTITY | NUMBER | |||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| COUNT_UOM | VARCHAR2 | (3) | ||
| COUNT_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| COUNT_QUANTITY | NUMBER | |||
| SYSTEM_QUANTITY | NUMBER | |||
| ADJUSTMENT_ACCOUNT_ID | NUMBER | (38) | ||
| ACCOUNT_SEGMENT1 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT2 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT3 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT4 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT5 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT6 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT7 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT8 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT9 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT10 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT11 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT12 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT13 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT14 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT15 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT16 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT17 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT18 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT19 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT20 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT21 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT22 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT23 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT24 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT25 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT26 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT27 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT28 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT29 | VARCHAR2 | (25) | ||
| ACCOUNT_SEGMENT30 | VARCHAR2 | (25) | ||
| COUNT_DATE | DATE | |||
| EMPLOYEE_ID | NUMBER | (38) | ||
| EMPLOYEE_FULL_NAME | VARCHAR2 | (240) | ||
| REFERENCE | VARCHAR2 | (240) | ||
| TRANSACTION_REASON_ID | NUMBER | (38) | ||
| TRANSACTION_REASON | VARCHAR2 | (30) | ||
| REQUEST_ID | NUMBER | (38) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (38) | ||
| PROGRAM_ID | NUMBER | (38) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| LOCK_FLAG | NUMBER | (1) | ||
| PROCESS_FLAG | NUMBER | (1) | ||
| PROCESS_MODE | NUMBER | (1) | ||
| VALID_FLAG | NUMBER | (1) | ||
| DELETE_FLAG | NUMBER | (1) | ||
| STATUS_FLAG | NUMBER | (38) | ||
| ERROR_FLAG | NUMBER | (38) | ||
| 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) | ||
| PROJECT_ID | NUMBER | (38) | ||
| TASK_ID | NUMBER | (38) | ||
| PARENT_LPN_ID | NUMBER | |||
| PARENT_LPN | VARCHAR2 | (30) | ||
| OUTERMOST_LPN_ID | NUMBER | |||
| OUTERMOST_LPN | VARCHAR2 | (30) | ||
| COST_GROUP_ID | NUMBER | |||
| COST_GROUP_NAME | VARCHAR2 | (10) | ||
| SECONDARY_UOM | VARCHAR2 | (3) | ||
| SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| SECONDARY_COUNT_QUANTITY | NUMBER | |||
| SECONDARY_SYSTEM_QUANTITY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CC_ENTRY_INTERFACE_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, ORGANIZATION_NAME
, 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_DESCRIPTION
, 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
, PRIMARY_UOM_CODE
, COUNT_UOM
, COUNT_UNIT_OF_MEASURE
, COUNT_QUANTITY
, SYSTEM_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
, PARENT_LPN_ID
, PARENT_LPN
, OUTERMOST_LPN_ID
, OUTERMOST_LPN
, COST_GROUP_ID
, COST_GROUP_NAME
, SECONDARY_UOM
, SECONDARY_UNIT_OF_MEASURE
, SECONDARY_COUNT_QUANTITY
, SECONDARY_SYSTEM_QUANTITY
FROM APPS.MTL_CC_ENTRIES_INTERFACE_V;
APPS
HR_GENERAL
- show dependent code
HR_ORGANIZATION_UNITS
HR_SECURITY
- show dependent code
MTL_CC_ENTRIES_INTERFACE
MTL_CYCLE_COUNT_HEADERS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS
WMS_LICENSE_PLATE_NUMBERS
APPS.MTL_CC_ENTRIES_INTERFACE_V is not referenced by any database object
|
|
|
|