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

TABLE: INV.MTL_REPLENISH_LINES

Object Details
Object Name: MTL_REPLENISH_LINES
Object Type: TABLE
Owner: INV
FND Design Data: TableINV.MTL_REPLENISH_LINES
Subobject Name:
Status: VALID


MTL_REPLENISH_LINES stores each line information for a replenishment
header. The line information includes an item along with the count
type and count quantity. The repenishment processor automatically
populates further information such as sourcing information, reorder
quantity, and account information along with the error statuses into
this table upon the completion of processing the headers and lines.
.
.
The count types are On-hand Quantity, Order Maximum, and Order
Quantity.
.
On-hand Quantity: the entered count quantity will be treated as the
current on-hand quantity by the processor.
.
Order Maximum: users are not required to enter the count quantity.
However, the processor will automatically reorder the maximum min-max
quantity defined for the item regardless of the on-hand and supply
quantity.
.
Order Quantity: the entered count quantity is treated as the reorder
quantity.
.
However, the reorder quantity is subject to supplier constraints such
as minimum order quantity, maximum order quantity, and fixed lot
multiplier.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTL_REPLENISH_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPLENISHMENT_HEADER_ID
ColumnREPLENISHMENT_LINE_ID
Columns
Name Datatype Length Mandatory Comments
REPLENISHMENT_LINE_ID NUMBER
Yes Line identifier for a replenishment line. The id is selected from the sequence, MTL_REPLENISH_LINES_S
REPLENISHMENT_HEADER_ID NUMBER
Yes Foreign key to replenishment count interface header record
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
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
COUNT_TYPE_CODE NUMBER
Yes Type of count performed
COUNT_QUANTITY NUMBER

Quantity of item counted within subinventory specified in header. The context of this column depends on the count type
COUNT_UOM_CODE VARCHAR2 (3)
Unit of measure code of the count quantity
SUPPLY_QUANTITY NUMBER

Used by processor to store quantity expected to be received into subinventory
SOURCE_TYPE NUMBER

Used by processor to store source type
SOURCE_ORGANIZATION_ID NUMBER

Used by processor to store source organization id
SOURCE_SUBINVENTORY VARCHAR2 (10)
Used by processor to store source subinventory code
REORDER_QUANTITY NUMBER

Used by processor to store quantity of items to be reordered
EXPENSE_ACCOUNT NUMBER

Used by processor to store the expense account
ENCUMBRANCE_ACCOUNT NUMBER

Used by processor to store the encumbrance account
REFERENCE VARCHAR2 (240)
Free text describing count line
ERROR_FLAG NUMBER

The processing error, if any, of the line. This column is populated by the Replenishment Processor
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
PRIMARY_UOM_COUNT_QUANTITY NUMBER

The count quantity in primary uom code
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary uom code of the item
TASK_ID NUMBER (15)
Task identifier
LOCATOR_ID NUMBER

Locator Identifier
SECONDARY_UOM_COUNT_QUANTITY NUMBER

THE COUNT QUANTITY IN SECONDARY UOM
SECONDARY_UOM_CODE VARCHAR2 (3)
Secondary uom of the item
Query Text

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


SELECT REPLENISHMENT_LINE_ID
,      REPLENISHMENT_HEADER_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      COUNT_TYPE_CODE
,      COUNT_QUANTITY
,      COUNT_UOM_CODE
,      SUPPLY_QUANTITY
,      SOURCE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      REORDER_QUANTITY
,      EXPENSE_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      REFERENCE
,      ERROR_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRIMARY_UOM_COUNT_QUANTITY
,      PRIMARY_UOM_CODE
,      TASK_ID
,      LOCATOR_ID
,      SECONDARY_UOM_COUNT_QUANTITY
,      SECONDARY_UOM_CODE
FROM INV.MTL_REPLENISH_LINES;

Dependencies

[top of page]

INV.MTL_REPLENISH_LINES does not reference any database object

INV.MTL_REPLENISH_LINES is referenced by following:

SchemaINV
ViewMTL_REPLENISH_LINES#