[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_SR_SOURCE_ORG |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_SR_SOURCE_ORG
|
| Subobject Name: | |
| Status: | VALID |
MSC_SR_SOURCE_ORG stores the source organizations or source suppliers
for Sourcing Rules or Bills of distribution. This table is a child of
MSC_SR_RECEIPT_ORG.
This table is populated by the Define Sourcing Rules and Define
Bills of distribution form of Oracle Supply Chain Planning at planning server.
This table also stores the sourcing information defined from source
applications.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_SR_SOURCE_ORG_N1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 SR_INSTANCE_ID
SR_SR_SOURCE_ID
|
| MSC_SR_SOURCE_ORG_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SR_SOURCE_ID
|
| MSC_SR_SOURCE_ORG_U3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SR_RECEIPT_ID
SOURCE_ORGANIZATION_ID
SOURCE_ORG_INSTANCE_ID
SOURCE_PARTNER_ID
SOURCE_PARTNER_SITE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SR_SOURCE_ID | NUMBER | Yes | Unique identifier for a row | |
| SR_SR_SOURCE_ID | NUMBER | Unique identifier for a row from the source application instance | ||
| SR_RECEIPT_ID | NUMBER | Yes | Identifier from the sourcing rule receipt org | |
| SOURCE_PARTNER_ID | NUMBER | Source supplier identifier | ||
| SOURCE_PARTNER_SITE_ID | NUMBER | Source supplier site identifier | ||
| ALLOCATION_PERCENT | NUMBER | Percent of supply allocated to this source | ||
| RANK | NUMBER | Rank of source | ||
| SHIP_METHOD | VARCHAR2 | (30) | Specify the shipping method | |
| SOURCE_TYPE | NUMBER | Flag indicating the source type | ||
| SR_INSTANCE_ID | NUMBER | Source instance id for the source organization | ||
| DELETED_FLAG | NUMBER | Flag to indicate whether the row is no longer valid. SYS_YES means the row will be deleted | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
| SOURCE_ORG_INSTANCE_ID | NUMBER | Source intance identifier of the source organization identifier | ||
| REFRESH_NUMBER | NUMBER | Refresh number assigned by collection proram | ||
| REPLENISHMENT_TYPE | NUMBER | Indicate type of replenishment. Null/0 = Force Transfer; 1 = Partial transfer; 2 = Full transfer | ||
| 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 | |
| MIN_TRANSFER_QTY | NUMBER | Minimum transfer quantity | ||
| MAX_TRANSFER_QTY | NUMBER | Maximum transfer quantity | ||
| TRANSFER_LOT_MULTIPLE | NUMBER | Transfer lot multiple | ||
| FIXED_TRANSFER_QTY | NUMBER | Fixed transfer quantity | ||
| TRANSFER_TYPE | NUMBER | Transfer type | ||
| COLLECTED_FLAG | NUMBER | Flag indicates whether the row is collected from source | ||
| CIRCULAR_SRC | VARCHAR2 | (1) | Y if sourcing rule is a circular sourcing rule | |
| FROM_REGION_ID | NUMBER | From region id | ||
| CIRCULAR_SRC_RANK | NUMBER | Circular Source Rank |
Cut, paste (and edit) the following text to query this object:
SELECT SR_SOURCE_ID
, SR_SR_SOURCE_ID
, SR_RECEIPT_ID
, SOURCE_PARTNER_ID
, SOURCE_PARTNER_SITE_ID
, ALLOCATION_PERCENT
, RANK
, SHIP_METHOD
, SOURCE_TYPE
, SR_INSTANCE_ID
, DELETED_FLAG
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
, REFRESH_NUMBER
, REPLENISHMENT_TYPE
, 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
, MIN_TRANSFER_QTY
, MAX_TRANSFER_QTY
, TRANSFER_LOT_MULTIPLE
, FIXED_TRANSFER_QTY
, TRANSFER_TYPE
, COLLECTED_FLAG
, CIRCULAR_SRC
, FROM_REGION_ID
, CIRCULAR_SRC_RANK
FROM MSC.MSC_SR_SOURCE_ORG;
MSC.MSC_SR_SOURCE_ORG does not reference any database object
MSC.MSC_SR_SOURCE_ORG is referenced by following:
MSC
MSC_SR_SOURCE_ORG#
|
|
|
|