DBA Data[Home] [Help] [Dependency Information]


TABLE: MSC.MSC_ITEM_SOURCING

Object Details
Object Name: MSC_ITEM_SOURCING
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ITEM_SOURCING
Subobject Name:
Status: VALID


This table stores sourcing information for an item used in Oracle Advanced Planning and Scheduling. This table is also used to store Sourcing information for in line vehicle sequencing (ILVS) in the supply chain hub product.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_ITEM_SOURCING_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLAN_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnSOURCE_ORGANIZATION_ID
ColumnSR_INSTANCE_ID2
ColumnSUPPLIER_ID
ColumnSUPPLIER_SITE_ID
ColumnEFFECTIVE_DATE
ColumnSHIP_METHOD
ColumnCUSTOMER_ID
ColumnCUSTOMER_SITE_ID
ColumnZONE_ID
ColumnASSIGNMENT_SET_TYPE
ColumnRANK
ColumnCIRCULAR_SRC
ColumnITEM_TYPE_VALUE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Instance Id of the destination organzation
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
SR_INSTANCE_ID2 NUMBER

Instance id of the source organization
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_SITE_ID NUMBER

Source supplier identifier
EFFECTIVE_DATE DATE

Effective date of this source
DISABLE_DATE DATE

Disable date of the source
ALLOCATION_PERCENT NUMBER

Percent allocated to the source
RANK NUMBER

Rank of the source
SOURCE_TYPE NUMBER

Source type
AVG_TRANSIT_LEAD_TIME NUMBER

Intransit lead time between two organizations
CONVERSION_FACTOR NUMBER

Conversion factor
SOURCING_RULE_ID NUMBER

Sourcing rule or bill of distribution identifier
ASSIGNMENT_ID NUMBER
Yes Assignment identifier
ASSIGNMENT_SET_ID NUMBER
Yes Assignment set identifier
ASSIGNMENT_TYPE NUMBER
Yes Sourcing assignment type
SOURCING_RULE_TYPE NUMBER
Yes Sourcing rule type
SHIP_METHOD VARCHAR2 (30)
Ship method
HISTORICAL_ALLOC_QTY NUMBER

Total historical allocation to supplier for item
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_TYPE NUMBER

Transfer type
TRANSFER_LOT_MULTIPLE NUMBER

Transfer lot multiple
FIXED_TRANSFER_QTY NUMBER

Fixed transfer quantity
CUSTOMER_ID NUMBER

Customer id used for Customer level sourcing
CUSTOMER_SITE_ID NUMBER

Customer site id used for Customer site level sourcing
ZONE_ID NUMBER

Zone id for zone level sourcing
ASSIGNMENT_SET_TYPE NUMBER

Assignment set type
CIRCULAR_SRC NUMBER

The flag indicates whether circular sourcing is enabled for this sourcing rule or not.
ITEM_TYPE_VALUE NUMBER

The flag indicates whether this sourcing rule is for a usable part (1) or a defective part(2)
REGION_ID NUMBER

Region Identifier (if the sourcing rule is defined at region level)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SOURCE_ORGANIZATION_ID
,      SR_INSTANCE_ID2
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      ALLOCATION_PERCENT
,      RANK
,      SOURCE_TYPE
,      AVG_TRANSIT_LEAD_TIME
,      CONVERSION_FACTOR
,      SOURCING_RULE_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_SET_ID
,      ASSIGNMENT_TYPE
,      SOURCING_RULE_TYPE
,      SHIP_METHOD
,      HISTORICAL_ALLOC_QTY
,      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_TYPE
,      TRANSFER_LOT_MULTIPLE
,      FIXED_TRANSFER_QTY
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ZONE_ID
,      ASSIGNMENT_SET_TYPE
,      CIRCULAR_SRC
,      ITEM_TYPE_VALUE
,      REGION_ID
FROM MSC.MSC_ITEM_SOURCING;

Dependencies

[top of page]

MSC.MSC_ITEM_SOURCING does not reference any database object

MSC.MSC_ITEM_SOURCING is referenced by following:

SchemaMSC
ViewMSC_ITEM_SOURCING#