[Home] [Help] [Dependency Information]
Object Name: | MRP_SR_ASSIGNMENTS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_SR_ASSIGNMENTS |
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: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SR_ASSIGNMENTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ID |
MRP_SR_ASSIGNMENTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_SET_ID
ASSIGNMENT_TYPE ORGANIZATION_ID CUSTOMER_ID SHIP_TO_SITE_ID SOURCING_RULE_TYPE INVENTORY_ITEM_ID CATEGORY_ID |
MRP_SR_ASSIGNMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_TYPE |
MRP_SR_ASSIGNMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CUSTOMER_ID
SHIP_TO_SITE_ID ASSIGNMENT_SET_ID ASSIGNMENT_TYPE |
MRP_SR_ASSIGNMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ASSIGNMENT_TYPE ASSIGNMENT_SET_ID ORGANIZATION_ID |
MRP_SR_ASSIGNMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCING_RULE_ID |
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:
|
|
|