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: FLM.FLM_MMM_OPERATIONS

Object Details

Object Name:	FLM_MMM_OPERATIONS
Object Type:	TABLE
Owner:	FLM
FND Design Data:	FLM.FLM_MMM_OPERATIONS
Subobject Name:
Status:	VALID

FLM_MMM_OPERATIONS table stores the mixed model map calculated result for line operations and processes.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FLM_MMM_OPERATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID PLAN_ID STANDARD_OPERATION_ID
FLM_MMM_OPERATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID PLAN_ID LINE_ID

Columns

Name	Datatype	Mandatory	Comments
PLAN_ID	NUMBER	Yes	Plan identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
STANDARD_OPERATION_ID	NUMBER	Yes	Standard operation identifier
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		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column
LINE_ID	NUMBER	Yes	Line identifier
OPERATION_TYPE	NUMBER	Yes	Type of operation: 2 for process, 3 for line operation
OPERATION_TAKT	NUMBER		Operation TAKT time
MACHINE_WEIGHTED_TIME	NUMBER		Weighted average time for machine resources for this operation
LABOR_WEIGHTED_TIME	NUMBER		Weighted average time for labor resources for this operation
ELAPSED_WEIGHTED_TIME	NUMBER		Weighted elapsed time for all resources for this operation
IPK_NEEDED	NUMBER		in process kanban needed for this operation
IPK_ASSIGNED	NUMBER		in process kanban assigned for this operation
OP_TAKT_AS_ASSIGNED	NUMBER		Operation TAKT time calculated for assigned resources
BOTTLENECK_RESOURCE_PERCENT	NUMBER		Biggest resource overcapacity percentage for all resources for this operation
PROCESS_EFFICIENCY	NUMBER		Process efficiency for this operation
RESOURCE_UNDERCAPACITY	NUMBER		Biggest resource undercapacity percentage for all resources for this operation

Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      STANDARD_OPERATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LINE_ID
,      OPERATION_TYPE
,      OPERATION_TAKT
,      MACHINE_WEIGHTED_TIME
,      LABOR_WEIGHTED_TIME
,      ELAPSED_WEIGHTED_TIME
,      IPK_NEEDED
,      IPK_ASSIGNED
,      OP_TAKT_AS_ASSIGNED
,      BOTTLENECK_RESOURCE_PERCENT
,      PROCESS_EFFICIENCY
,      RESOURCE_UNDERCAPACITY
FROM FLM.FLM_MMM_OPERATIONS;

Dependencies

[top of page]

FLM.FLM_MMM_OPERATIONS does not reference any database object

FLM.FLM_MMM_OPERATIONS is referenced by following:

FLM: FLM_MMM_OPERATIONS#