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: BOM.BOM_MIXED_MODEL_MAP_PROCESSES

Object Details

Object Name:	BOM_MIXED_MODEL_MAP_PROCESSES
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.BOM_MIXED_MODEL_MAP_PROCESSES
Subobject Name:
Status:	VALID

BOM_MIXED_MODEL_MAP_PROCESSES contains processes or line operations
and summary information for mixed model maps.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BOM_MIXED_MODEL_MAP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MIXED_MODEL_MAP_ID GROUP_NUMBER SEQUENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MIXED_MODEL_MAP_ID	NUMBER		Yes	Mixed Model Map identifier
GROUP_NUMBER	NUMBER		Yes	Processes in a Mixed Model Map are grouped together in sets of 5. This group number represents in which set the process exists.
SEQUENCE_ID	NUMBER		Yes	Specifies whether process is displayed in position 1, 2, 3, 4 or 5 within the group
OPERATION_CODE	VARCHAR2	(4)	Yes	Either the Process or Line Op name
MACHINE_WEIGHTED_TIME	NUMBER			Weighted machine time for a process
LABOR_WEIGHTED_TIME	NUMBER			Weighted labor time for a process
TOTAL_WEIGHTED_TIME	NUMBER			Weighted total time for a process
MACHINES_NEEDED	NUMBER			Number of machines needed in a process
MACHINES_ASSIGNED	NUMBER			Number of machines assigned to a process
MACHINES_NEEDED_DELTA	NUMBER			The difference between the Machines Needed for the current map and the baseline map
LABOR_NEEDED	NUMBER			Number of labor resources needed
LABOR_ASSIGNED	NUMBER			Number of labor resources assigned
LABOR_NEEDED_DELTA	NUMBER			The change between the labor needed for the current map and the baseline map
TAKT_TIME	NUMBER			Calculated time for a process or line operation
TAKT_TIME_FOR_ASSIGNED	NUMBER			Time calculated from assigned machines or labor for a process or line operation
IN_PROCESS_KANBAN	NUMBER			IPKs needed for a process
IN_PROCESS_KANBAN_DELTA	NUMBER			The change between the IPKs needed in the current map and the baseline map
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		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 MIXED_MODEL_MAP_ID
,      GROUP_NUMBER
,      SEQUENCE_ID
,      OPERATION_CODE
,      MACHINE_WEIGHTED_TIME
,      LABOR_WEIGHTED_TIME
,      TOTAL_WEIGHTED_TIME
,      MACHINES_NEEDED
,      MACHINES_ASSIGNED
,      MACHINES_NEEDED_DELTA
,      LABOR_NEEDED
,      LABOR_ASSIGNED
,      LABOR_NEEDED_DELTA
,      TAKT_TIME
,      TAKT_TIME_FOR_ASSIGNED
,      IN_PROCESS_KANBAN
,      IN_PROCESS_KANBAN_DELTA
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.BOM_MIXED_MODEL_MAP_PROCESSES;

Dependencies

[top of page]

BOM.BOM_MIXED_MODEL_MAP_PROCESSES does not reference any database object

BOM.BOM_MIXED_MODEL_MAP_PROCESSES is referenced by following:

BOM: BOM_MIXED_MODEL_MAP_PROCESSES#