eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	MSC.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_ITEM_SOURCING_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID ORGANIZATION_ID SR_INSTANCE_ID INVENTORY_ITEM_ID SOURCE_ORGANIZATION_ID SR_INSTANCE_ID2 SUPPLIER_ID SUPPLIER_SITE_ID EFFECTIVE_DATE SHIP_METHOD CUSTOMER_ID CUSTOMER_SITE_ID ZONE_ID ASSIGNMENT_SET_TYPE RANK CIRCULAR_SRC ITEM_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:

MSC: MSC_ITEM_SOURCING#