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

TABLE: MSC.MSC_ST_SOURCING_HISTORY

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

Historical information related to Sourcing

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Id
ORGANIZATION_ID NUMBER
Yes Organization Id
SR_INSTANCE_ID NUMBER
Yes sr instance Id
SOURCING_RULE_ID NUMBER
Yes Sourcing Rule/Bill of Distribution identifier
SOURCE_ORG_ID NUMBER

Source Org Id
SOURCE_SR_INSTANCE_ID NUMBER

source org sr instance Id
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
HISTORICAL_ALLOCATION NUMBER
Yes Historical Allocation
REFRESH_NUMBER NUMBER

Refresh Number
LAST_CALCULATED_DATE DATE
Yes Last Calculated Date
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
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
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      SOURCING_RULE_ID
,      SOURCE_ORG_ID
,      SOURCE_SR_INSTANCE_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      HISTORICAL_ALLOCATION
,      REFRESH_NUMBER
,      LAST_CALCULATED_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSC.MSC_ST_SOURCING_HISTORY;

Dependencies

[top of page]

MSC.MSC_ST_SOURCING_HISTORY does not reference any database object

MSC.MSC_ST_SOURCING_HISTORY is referenced by following:

SchemaMSC
ViewMSC_ST_SOURCING_HISTORY#