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: MRP.MRP_ITEM_SOURCING

Object Details

Object Name:	MRP_ITEM_SOURCING
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_ITEM_SOURCING
Subobject Name:
Status:	VALID

MRP_ITEM_SOURCING stores the effective sourcing information for
planned items within a MPS, MRP, or DRP plan. Each row identifies a
valid effective source, which can be a supplier, another organization,
or the current planned organization, for example, make.
.
This table is populated by the Memory-based Snapshot. The Memory-based
Snapshot looks at the hierarchy of Global, Category of Items, Item,
Organization, Category of Item-Organizations, and Item-Organization
level assigments within the assignment set used for the plan to
determine the highest level assignment for each item-organization.
SOURCING_RULE_ID identifies the highest level Sourcing Rule or Bill of
Distribution that will be used for determining the sourcing
information for a planned item.
.
The information in this table is displayed in Sources and Destination
windows of the Supply Chain Planner Workbench and in the Supply
Chain Planning Detail Report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_ITEM_SOURCING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	COMPILE_DESIGNATOR ORGANIZATION_ID INVENTORY_ITEM_ID SOURCE_ORGANIZATION_ID VENDOR_ID VENDOR_SITE_ID EFFECTIVE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
SOURCE_ORGANIZATION_ID	NUMBER			Source organization identifier
VENDOR_ID	NUMBER			Source supplier
VENDOR_SITE_ID	NUMBER			Source supplier site
EFFECTIVE_DATE	DATE			Effective date of source
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
DISABLE_DATE	DATE			Disable date of source
ALLOCATION_PERCENT	NUMBER			Percent allocated to source
RANK	NUMBER			Rank of source
QUANTITY	NUMBER			Not currently used
SOURCE_TYPE	NUMBER			Not currently used
AVG_TRANSIT_LEAD_TIME	NUMBER			Intransit lead time between two organizations
SOURCING_RULE_ID	NUMBER			Sourcing rule/Bill of Distribution identifier
ASSIGNMENT_ID	NUMBER		Yes	Assignment identifier
ASSIGNMENT_SET_ID	NUMBER		Yes	Assignment Set identifier
ASSIGNMENT_TYPE	NUMBER		Yes	Sourcing assignment type
SOURCING_RULE_TYPE	NUMBER		Yes	Sourcing rule type
SHIP_METHOD	VARCHAR2	(30)		Ship method
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
HISTORICAL_ALLOC_QTY	NUMBER	(30)		Holds the historical allocation of the item to the Supplier

Query Text

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


SELECT COMPILE_DESIGNATOR
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_ORGANIZATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      EFFECTIVE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      DISABLE_DATE
,      ALLOCATION_PERCENT
,      RANK
,      QUANTITY
,      SOURCE_TYPE
,      AVG_TRANSIT_LEAD_TIME
,      SOURCING_RULE_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_TYPE
,      SOURCING_RULE_TYPE
,      SHIP_METHOD
,      LAST_UPDATE_LOGIN
,      HISTORICAL_ALLOC_QTY
FROM MRP.MRP_ITEM_SOURCING;

Dependencies

[top of page]

MRP.MRP_ITEM_SOURCING does not reference any database object

MRP.MRP_ITEM_SOURCING is referenced by following:

MRP: MRP_ITEM_SOURCING#