[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_SEGMENT_ALLOCATIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| Subobject Name: | |
| Status: | VALID |
Table for storing mapping between producing supplies or supplies segment to consuming supplies or supplies segments. Allocation type in this tables specifies whether this mapping is at supplies level or ar supply segment level
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRODUCER_TRANS_ID | NUMBER | Yes | From supply transaction Id.Fk to msc_supplies | |
| CONSUMER_TRANS_ID | NUMBER | Yes | Consumer supply transaction id. Fk to msc_supplies | |
| PLAN_ID | NUMBER | Yes | Plan identifier | |
| PRODUCER_SR_INSTANCE_ID | NUMBER | Yes | Producer source instance id | |
| CONSUMER_SR_INSTANCE_ID | NUMBER | Yes | Consumer source instance id | |
| SEGMENT_START_DATE | DATE | Segment supply Start date | ||
| SEGMENT_END_DATE | DATE | Segment supply End date | ||
| SEGMENT_QUANTITY | NUMBER | Segment supply quantity | ||
| CONSUMER_START_DATE | DATE | Consumer start date | ||
| CONSUMER_END_DATE | DATE | Consumer end date | ||
| FROM_ROUTING_SEQUENCE_ID | NUMBER | Routing used in from supply | ||
| TO_ROUTING_SEQUENCE_ID | NUMBER | Routing used in to supply | ||
| PRODUCER_OP_SEQ_ID | NUMBER | Operation sequence id of a consumer | ||
| PRODUCER_OP_SEQ_NUM | NUMBER | Operation sequence number of a producer | ||
| PRODUCER_RES_SEQ_NUM | NUMBER | Operation sequence number of a producer | ||
| CONSUMER_OP_SEQ_ID | NUMBER | Operation sequence id of a consumer | ||
| CONSUMER_OP_SEQ_NUM | NUMBER | Operation sequence number of a consumer | ||
| CONSUMER_RES_SEQ_NUM | NUMBER | Operation sequence number of a consumer | ||
| ALLOCATION_TYPE | NUMBER | 1 supply , 2 segment supply | ||
| 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 segment. | |
| 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. | |
| REFRESH_NUMBER | NUMBER | Refresh Number | ||
| FROM_RES_TRANSACTION_ID | NUMBER | From Resource Transaction Identifier | ||
| TO_RES_TRANSACTION_ID | NUMBER | To Resource Transaction Identifier | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Id | ||
| MAXIMUM_TIME_OFFSET | NUMBER | Maximum Time Offset | ||
| MINIMUM_TIME_OFFSET | NUMBER | Minimum Time Offset | ||
| ACTUAL_TIME_OFFSET | NUMBER | Actual Time Offset | ||
| MINIMUM_TRANSFER_QTY | NUMBER | Minimum Transfer Qty | ||
| DEPENDENCY_TYPE | NUMBER | Dependency Type |
Cut, paste (and edit) the following text to query this object:
SELECT PRODUCER_TRANS_ID
, CONSUMER_TRANS_ID
, PLAN_ID
, PRODUCER_SR_INSTANCE_ID
, CONSUMER_SR_INSTANCE_ID
, SEGMENT_START_DATE
, SEGMENT_END_DATE
, SEGMENT_QUANTITY
, CONSUMER_START_DATE
, CONSUMER_END_DATE
, FROM_ROUTING_SEQUENCE_ID
, TO_ROUTING_SEQUENCE_ID
, PRODUCER_OP_SEQ_ID
, PRODUCER_OP_SEQ_NUM
, PRODUCER_RES_SEQ_NUM
, CONSUMER_OP_SEQ_ID
, CONSUMER_OP_SEQ_NUM
, CONSUMER_RES_SEQ_NUM
, ALLOCATION_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
, REFRESH_NUMBER
, FROM_RES_TRANSACTION_ID
, TO_RES_TRANSACTION_ID
, INVENTORY_ITEM_ID
, MAXIMUM_TIME_OFFSET
, MINIMUM_TIME_OFFSET
, ACTUAL_TIME_OFFSET
, MINIMUM_TRANSFER_QTY
, DEPENDENCY_TYPE
FROM MSC.MSC_SEGMENT_ALLOCATIONS;
MSC.MSC_SEGMENT_ALLOCATIONS does not reference any database object
MSC.MSC_SEGMENT_ALLOCATIONS is referenced by following:
APPS
MSC_SEGMENT_ALLOCATIONS
|
|
|
|