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

VIEW: APPS.MTL_PHYSICAL_INVENTORY_TAGS_V

Object Details
Object Name: MTL_PHYSICAL_INVENTORY_TAGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_PHYSICAL_INVENTORY_TAGS_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
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
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
REVISION_QTY_CONTROL_CODE NUMBER

Revision quantity control code for the tag item
LOT_CONTROL_CODE NUMBER

Lot control code for the tag item
SERIAL_NUMBER_CONTROL_CODE NUMBER

Serial number control code for the tag item
LOCATION_CONTROL_CODE NUMBER

Stock locator control code
TAG_QUANTITY NUMBER

Tag Quantity
TAG_UOM VARCHAR2 (3)
Unit of Measure on the Tag
TAG_QUANTITY_AT_STANDARD_UOM NUMBER

Tag quantity in 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
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
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
PARENT_LPN_ID NUMBER

Parent LPN Identifier
OUTERMOST_LPN_ID NUMBER

Outermost LPN Identifier
PARENT_LPN VARCHAR2 (30)
Parent License Plate Number
OUTERMOST_LPN VARCHAR2 (30)
Outermost License Plate Number
CONTAINER_ITEM_ID NUMBER

Identifier for the container Item
CONTAINER_REVISION VARCHAR2 (3)
Container Item Revision Code
CONTAINER_LOT_NUMBER VARCHAR2 (80)
Container Item lot number
CONTAINER_SERIAL_NUMBER VARCHAR2 (30)
Container Item serial number
COST_GROUP_ID NUMBER

Cost Group Identifier - Used by WMS only
COST_GROUP_NAME VARCHAR2 (10)
Cost Group Name
CONTAINER_COST_GROUP_ID NUMBER

Container Cost Group Identifier
CONTAINER_COST_GROUP_NAME VARCHAR2 (10)
Container Cost Group Name
LOT_EXPIRATION_DATE DATE

Lot expiration date
SHELF_LIFE_DAYS NUMBER

Length of shelf life days
SHELF_LIFE_CODE NUMBER

Shelf life code
TAG_SECONDARY_QUANTITY NUMBER

Tag quantity in Secondary UOM
TAG_SECONDARY_UOM VARCHAR2 (3)
Secondary UOM on Tag
TAG_QTY_AT_STD_SECONDARY_UOM NUMBER

Tag quantity at standard secondary UOM
STANDARD_SECONDARY_UOM VARCHAR2 (3)
Standard Secondary UOM
Query Text

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


SELECT ROW_ID
,      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
,      ITEM_DESCRIPTION
,      REVISION_QTY_CONTROL_CODE
,      LOT_CONTROL_CODE
,      SERIAL_NUMBER_CONTROL_CODE
,      LOCATION_CONTROL_CODE
,      TAG_QUANTITY
,      TAG_UOM
,      TAG_QUANTITY_AT_STANDARD_UOM
,      STANDARD_UOM
,      SUBINVENTORY
,      LOCATOR_ID
,      LOT_NUMBER
,      REVISION
,      SERIAL_NUM
,      COUNTED_BY_EMPLOYEE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PARENT_LPN_ID
,      OUTERMOST_LPN_ID
,      PARENT_LPN
,      OUTERMOST_LPN
,      CONTAINER_ITEM_ID
,      CONTAINER_REVISION
,      CONTAINER_LOT_NUMBER
,      CONTAINER_SERIAL_NUMBER
,      COST_GROUP_ID
,      COST_GROUP_NAME
,      CONTAINER_COST_GROUP_ID
,      CONTAINER_COST_GROUP_NAME
,      LOT_EXPIRATION_DATE
,      SHELF_LIFE_DAYS
,      SHELF_LIFE_CODE
,      TAG_SECONDARY_QUANTITY
,      TAG_SECONDARY_UOM
,      TAG_QTY_AT_STD_SECONDARY_UOM
,      STANDARD_SECONDARY_UOM
FROM APPS.MTL_PHYSICAL_INVENTORY_TAGS_V;

Dependencies

[top of page]

APPS.MTL_PHYSICAL_INVENTORY_TAGS_V references the following:

SchemaAPPS
SynonymCST_COST_GROUPS
SynonymMTL_PHYSICAL_INVENTORY_TAGS
SynonymMTL_SYSTEM_ITEMS
SynonymWMS_LICENSE_PLATE_NUMBERS

APPS.MTL_PHYSICAL_INVENTORY_TAGS_V is not referenced by any database object