[Home] [Help]
[Dependency Information]
Object Name: | MRP_SR_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MRP_SR_ASSIGNMENTS stores the assignment of sourcing rules
or bills of distribution to items, organizations, category, or
at the global level. This table is populated by the Assign
Sourcing Rules form of Oracle Supply Chain Planning.
.
This table is used by the Memory-based Snapshot to determine the
sourcing information or an item in an organization. The Memory-based
Snapshot uses the most granular ASSIGNMENT_LEVEL to determine the
sourcing for an item-organization.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SR_ASSIGNMENTS_U1 | NORMAL | UNIQUE |
![]() |
![]() |
MRP_SR_ASSIGNMENTS_U2 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
MRP_SR_ASSIGNMENTS_N1 | NORMAL | NONUNIQUE |
![]() |
![]() |
MRP_SR_ASSIGNMENTS_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
MRP_SR_ASSIGNMENTS_N3 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
MRP_SR_ASSIGNMENTS_N4 | NORMAL | NONUNIQUE |
![]() |
![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | Yes | Assignment Set identifier | |
ASSIGNMENT_TYPE | NUMBER | Yes | Assignment type | |
SOURCING_RULE_ID | NUMBER | Yes | Sourcing Rule/Bill of Distribution identifier | |
SOURCING_RULE_TYPE | NUMBER | Yes | Sourcing rule type | |
ASSIGNMENT_SET_ID | NUMBER | Yes | Assignment Set 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 | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
CUSTOMER_ID | NUMBER | Customer identifier | ||
SHIP_TO_SITE_ID | NUMBER | Ship to site identifier | ||
CATEGORY_ID | NUMBER | Category identifier | ||
CATEGORY_SET_ID | NUMBER | Category Set identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | Not currently used | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, ASSIGNMENT_TYPE
, SOURCING_RULE_ID
, SOURCING_RULE_TYPE
, ASSIGNMENT_SET_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORGANIZATION_ID
, CUSTOMER_ID
, SHIP_TO_SITE_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, INVENTORY_ITEM_ID
, SECONDARY_INVENTORY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM MRP.MRP_SR_ASSIGNMENTS;
MRP.MRP_SR_ASSIGNMENTS does not reference any database object
MRP.MRP_SR_ASSIGNMENTS is referenced by following:
|
|
|