[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
MRP.MRP_ITEM_SOURCING does not reference any database object
MRP.MRP_ITEM_SOURCING is referenced by following:
|
|
|