eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: INV.MTL_REPLENISH_LINES_INT

Object Details

Object Name:	MTL_REPLENISH_LINES_INT
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_REPLENISH_LINES_INT
Subobject Name:
Status:	VALID

This is the open interface table to load replenishment requests lines from
external systems into Oracle Inventory's Replenishment Lines table.
A record for each item included in the count header must be inserted into
this table.
Scope: public
Lifecycle: active
Display Name: Replenishment Lines Open Interface
Product: INV
Category: BUSINESS_ENTITY INV_REPLENISHMENT

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_REPLENISH_LINES_INT_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REPLENISHMENT_HEADER_ID REPLENISHMENT_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPLENISHMENT_HEADER_ID	NUMBER		Yes	Foreign key to replenishment count interface header record
REPLENISHMENT_LINE_ID	NUMBER		Yes	Line identifier for a replenishment line
ORGANIZATION_ID	NUMBER			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			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
REFERENCE	VARCHAR2	(240)		Free text comments about the count line
ERROR_FLAG	NUMBER			The processing error, if any, of the line. This column is populated by the Replenishment Validator
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
SEGMENT1	VARCHAR2	(40)		Item key flexfield segment column. Users can either populate an inventory item id or the item segments.
SEGMENT2	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT3	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT4	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT5	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT6	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT7	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT8	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT9	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT10	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT11	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT12	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT13	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT14	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT15	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT16	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT17	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT18	VARCHAR2	(40)		Item Key flexfield segment column
SEGMENT19	VARCHAR2	(40)		Item key flexfield segment column
SEGMENT20	VARCHAR2	(40)		Item key flexfield segment column
COUNT_UNIT_OF_MEASURE	VARCHAR2	(25)		The long name of unit of measure of the count quantity. Users can either enter the long name of the unit of measure or the short name uom code
COUNT_UOM_CODE	VARCHAR2	(3)		Short name of the unit of measure of the count quantity. Users can either enter the long name, unit of measure, or the short name
TASK_ID	NUMBER	(15)		Task identifier
LOCATOR_ID	NUMBER			Locator Identifier
LOCATOR_SEGMENT1	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT2	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT3	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT4	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT5	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT6	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT7	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT8	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT9	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT10	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT11	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT12	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT13	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT14	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT15	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT16	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT17	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT18	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT19	VARCHAR2	(40)		Locator Key flexfield Segment
LOCATOR_SEGMENT20	VARCHAR2	(40)		Locator Key flexfield Segment

Query Text

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


SELECT REPLENISHMENT_HEADER_ID
,      REPLENISHMENT_LINE_ID
,      ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      COUNT_TYPE_CODE
,      COUNT_QUANTITY
,      REFERENCE
,      ERROR_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      COUNT_UNIT_OF_MEASURE
,      COUNT_UOM_CODE
,      TASK_ID
,      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
FROM INV.MTL_REPLENISH_LINES_INT;

Dependencies

[top of page]

INV.MTL_REPLENISH_LINES_INT does not reference any database object

INV.MTL_REPLENISH_LINES_INT is referenced by following:

INV: MTL_REPLENISH_LINES_INT#