[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MTL_PHYSICAL_INVENTORY_TAGS |
|---|---|
| Object Type: | TABLE |
| Owner: | INV |
| FND Design Data: |  INV.MTL_PHYSICAL_INVENTORY_TAGS
|
| Subobject Name: | |
| Status: | VALID |
MTL_PHYSICAL_INVENTORY_TAGS stores information regarding physical
inventory tags, including tag number, SKU information, tag-quantity,
and a pointer to the corresponding adjustment in
MTL_PHYSICAL_ADJUSTMENTS. A change to this table may require a
corresponding change to MTL_PHYSICAL_ADJUSTMENTS to ensure that the
information therein remains consistent with its tags.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MTL_PHYSICAL_INVENTORY_TAGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TAG_ID
|
| MTL_PHYSICAL_INVENTORY_TAGS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
PHYSICAL_INVENTORY_ID
TAG_NUMBER
|
| MTL_PHYSICAL_INVENTORY_TAGS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PHYSICAL_INVENTORY_ID
|
| MTL_PHYSICAL_INVENTORY_TAGS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADJUSTMENT_ID
PHYSICAL_INVENTORY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TAG_ID | NUMBER | Yes | Tag identifier | |
| PHYSICAL_INVENTORY_ID | NUMBER | Yes | Physical inventory 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 | ||
| VOID_FLAG | NUMBER | Yes | Whether or not this tag has been voided | |
| TAG_NUMBER | VARCHAR2 | (40) | Yes | Tag number |
| ADJUSTMENT_ID | NUMBER | Identifier of adjustment corresponding to this tag's SKU | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| TAG_QUANTITY | NUMBER | Tag quantity | ||
| TAG_UOM | VARCHAR2 | (3) | Unit of measure on tag | |
| TAG_QUANTITY_AT_STANDARD_UOM | NUMBER | Tag quantity at standard UOM | ||
| STANDARD_UOM | VARCHAR2 | (3) | Standard unit of measure at tag entry time | |
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory of SKU counted on this tag | |
| LOCATOR_ID | NUMBER | Identifier of locator of SKU counted on this tag | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot number for item | |
| LOT_EXPIRATION_DATE | DATE | Lot expiration date | ||
| REVISION | VARCHAR2 | (3) | Inventory item revision code | |
| SERIAL_NUM | VARCHAR2 | (30) | Item serial number | |
| COUNTED_BY_EMPLOYEE_ID | NUMBER | (9) | Identifier of employee who made this count | |
| LOT_SERIAL_CONTROLS | VARCHAR2 | (1) | Dummy column required by AOL for protected descriptive flexfield | |
| 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 | |
| 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 | ||
| PARENT_LPN_ID | NUMBER | Parent LPN Identifier | ||
| OUTERMOST_LPN_ID | NUMBER | Outermost LPN Identifier | ||
| COST_GROUP_ID | NUMBER | Cost Group Identifier - Used by WMS only | ||
| TAG_SECONDARY_QUANTITY | NUMBER | Tag quantity in Secondary Quantity | ||
| TAG_SECONDARY_UOM | VARCHAR2 | (3) | Secondary UOM on Tag | |
| TAG_QTY_AT_STD_SECONDARY_UOM | NUMBER | Tag QTY at standard secondary UOM | ||
| STANDARD_SECONDARY_UOM | VARCHAR2 | (3) | Standard Secondary UOM |
Cut, paste (and edit) the following text to query this object:
SELECT TAG_ID
, PHYSICAL_INVENTORY_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, VOID_FLAG
, TAG_NUMBER
, ADJUSTMENT_ID
, INVENTORY_ITEM_ID
, TAG_QUANTITY
, TAG_UOM
, TAG_QUANTITY_AT_STANDARD_UOM
, STANDARD_UOM
, SUBINVENTORY
, LOCATOR_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, REVISION
, SERIAL_NUM
, COUNTED_BY_EMPLOYEE_ID
, LOT_SERIAL_CONTROLS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PARENT_LPN_ID
, OUTERMOST_LPN_ID
, COST_GROUP_ID
, TAG_SECONDARY_QUANTITY
, TAG_SECONDARY_UOM
, TAG_QTY_AT_STD_SECONDARY_UOM
, STANDARD_SECONDARY_UOM
FROM INV.MTL_PHYSICAL_INVENTORY_TAGS;
INV.MTL_PHYSICAL_INVENTORY_TAGS does not reference any database object
INV.MTL_PHYSICAL_INVENTORY_TAGS is referenced by following:
INV
MTL_PHYSICAL_INVENTORY_TAGS#
|
|
|
|