[Home] [Help] [Dependency Information]
Object Name: | MSC_ASSIGNMENT_SETS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ASSIGNMENT_SETS |
Subobject Name: | |
Status: | VALID |
This table stores the assignment of sourcing rules (or bills of distribution) to item, organization, category, or at the global level.
This table stores data which are created at planning server and source applications.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ASSIGNMENT_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_SET_ID |
MSC_ASSIGNMENT_SETS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_SET_NAME |
MSC_ASSIGNMENTS_SETS_U3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SR_INSTANCE_ID
SR_ASSIGNMENT_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_SET_ID | NUMBER | Yes | Assignment set identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Source application identifier | |
ASSIGNMENT_SET_NAME | VARCHAR2 | (34) | Yes | Assignment set name |
DESCRIPTION | VARCHAR2 | (80) | Description | |
SR_ASSIGNMENT_SET_ID | NUMBER | Yes | Assignment set identifier from source application instance | |
DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted | ||
REFRESH_NUMBER | NUMBER | Refresh number | ||
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 | ||
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 | |
COLLECTED_FLAG | NUMBER | Flag to indicate whether the row is collected from application instance. | ||
ASSIGNMENT_ASSOCIATION_TYPE | NUMBER | 1 - for SRP, 2 - for Non-SRP |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_SET_ID
, SR_INSTANCE_ID
, ASSIGNMENT_SET_NAME
, DESCRIPTION
, SR_ASSIGNMENT_SET_ID
, DELETED_FLAG
, REFRESH_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, COLLECTED_FLAG
, ASSIGNMENT_ASSOCIATION_TYPE
FROM MSC.MSC_ASSIGNMENT_SETS;
MSC.MSC_ASSIGNMENT_SETS does not reference any database object
MSC.MSC_ASSIGNMENT_SETS is referenced by following:
|
|
|