[Home] [Help] [Dependency Information]
Object Name: | MRP_SOURCING_HISTORY |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_SOURCING_HISTORY |
Subobject Name: | |
Status: | VALID |
MRP_SOURCING_HISTORY stores historical sourcing information which is used by the planner to determine planned order allocation to different sources. It is populated and updated by the planner.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SOURCING_HISTORY_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SOURCING_RULE_ID
INVENTORY_ITEM_ID ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
SOURCING_RULE_ID | NUMBER | Yes | Sourcing Rule Id | |
SOURCE_ORG_ID | NUMBER | Source Org Id | ||
VENDOR_ID | NUMBER | Vendor Id | ||
VENDOR_SITE_ID | NUMBER | Vendor Site Id | ||
HISTORICAL_ALLOCATION | NUMBER | Yes | Historical Allocation | |
LAST_CALCULATED_DATE | DATE | Yes | Last Calculated Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
REQUEST_ID | NUMBER | Request Id | ||
PROGRAM_APPLICATION_ID | NUMBER | Program Application Id | ||
PROGRAM_ID | NUMBER | Program Id | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SOURCING_RULE_ID
, SOURCE_ORG_ID
, VENDOR_ID
, VENDOR_SITE_ID
, HISTORICAL_ALLOCATION
, LAST_CALCULATED_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MRP.MRP_SOURCING_HISTORY;
MRP.MRP_SOURCING_HISTORY does not reference any database object
MRP.MRP_SOURCING_HISTORY is referenced by following:
|
|
|