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_PROCESS_EFFECTIVITY

Object Details

Object Name:	MSC_PROCESS_EFFECTIVITY
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_PROCESS_EFFECTIVITY
Subobject Name:
Status:	VALID

This table stores links between the bill of material and routings and store effectivities for this process.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_PROCESS_EFFECTIVITY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID PROCESS_SEQUENCE_ID
MSC_PROCESS_EFFECTIVITY_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID SR_INSTANCE_ID ITEM_ID ORGANIZATION_ID BILL_SEQUENCE_ID ROUTING_SEQUENCE_ID LINE_ID EFFECTIVITY_DATE DISABLE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan idenfitier
PROCESS_SEQUENCE_ID	NUMBER		Yes	Process sequence identifier
ITEM_ID	NUMBER		Yes	Item identifier of the product/co-product
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
EFFECTIVITY_DATE	DATE		Yes	Effectivity date of the process
DISABLE_DATE	DATE			Disable date of the process
MINIMUM_QUANTITY	NUMBER			Minimum quantity for which the process can be used to produce the item, expressed in primary UOM
MAXIMUM_QUANTITY	NUMBER			Maximum quantity for which the process can be used to produce the item, expressed in primary UOM
PREFERENCE	NUMBER			Preference
ROUTING_SEQUENCE_ID	NUMBER			Routing sequence identifier from source appliation
BILL_SEQUENCE_ID	NUMBER			BOM identifier
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
TOTAL_PRODUCT_CYCLE_TIME	NUMBER			Total time that an assembly takes along the primary path in the operation network calculated by flow manufacturing
ITEM_PROCESS_COST	NUMBER			Cost of alternate BOM and routing
LINE_ID	NUMBER			Line unique identifier
PRIMARY_LINE_FLAG	NUMBER			Flag indicating whether the line is used for lead time calculations
PRODUCTION_LINE_RATE	NUMBER			Number of assemblies which run down the line per hour
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
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
LOAD_DISTRIBUTION_PRIORITY	NUMBER			Load distribution priority
RECIPE	VARCHAR2	(240)		Reciepe name for OPM

Query Text

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


SELECT PLAN_ID
,      PROCESS_SEQUENCE_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      MINIMUM_QUANTITY
,      MAXIMUM_QUANTITY
,      PREFERENCE
,      ROUTING_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      SR_INSTANCE_ID
,      TOTAL_PRODUCT_CYCLE_TIME
,      ITEM_PROCESS_COST
,      LINE_ID
,      PRIMARY_LINE_FLAG
,      PRODUCTION_LINE_RATE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LOAD_DISTRIBUTION_PRIORITY
,      RECIPE
FROM MSC.MSC_PROCESS_EFFECTIVITY;

Dependencies

[top of page]

MSC.MSC_PROCESS_EFFECTIVITY does not reference any database object

MSC.MSC_PROCESS_EFFECTIVITY is referenced by following:

APPS: MSC_PROCESS_EFFECTIVITY