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]

VIEW: APPS.BOM_MIXED_MODEL_MAP_CELLS_V

Object Details

Object Name:	BOM_MIXED_MODEL_MAP_CELLS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_MIXED_MODEL_MAP_CELLS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Mandatory	Comments
MIXED_MODEL_MAP_ID	NUMBER	Yes	Mixed Model Map identifier
GROUP_NUMBER	NUMBER	Yes	Each Mixed Model Map's Processes are grouped together in sets of 5. This group number represents which set the Process is in.
PRODUCT_ITEM_ID	NUMBER	Yes	Product item identifier
DEMAND	NUMBER	Yes	Amount of demand for the Product
MACHINE_TIME1	NUMBER		Machine Time for the first process
MACHINE_TIME2	NUMBER		Machine Time for the second process
MACHINE_TIME3	NUMBER		Machine Time for the third process
MACHINE_TIME4	NUMBER		Machine Time for the fourth process
MACHINE_TIME5	NUMBER		Machine Time for the fifth process
LABOR_TIME1	NUMBER		Labor Time for the first process
LABOR_TIME2	NUMBER		Labor Time for the second process
LABOR_TIME3	NUMBER		Labor Time for the third process
LABOR_TIME4	NUMBER		Labor Time for the fourth process
LABOR_TIME5	NUMBER		Labor Time for the fifth process
TOTAL_TIME1	NUMBER		Total Time for the first process
TOTAL_TIME2	NUMBER		Total Time for the second process
TOTAL_TIME3	NUMBER		Total Time for the third process
TOTAL_TIME4	NUMBER		Total Time for the fourth process
TOTAL_TIME5	NUMBER		Total Time for the fifth process
PROCESS_VOLUME1	NUMBER		Process Volume for the first process
PROCESS_VOLUME2	NUMBER		Process Volume for the second process
PROCESS_VOLUME3	NUMBER		Process Volume for the third process
PROCESS_VOLUME4	NUMBER		Process Volume for the fourth process
PROCESS_VOLUME5	NUMBER		Process Volume for the fifth process

Query Text

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


SELECT MIXED_MODEL_MAP_ID
,      GROUP_NUMBER
,      PRODUCT_ITEM_ID
,      DEMAND
,      MACHINE_TIME1
,      MACHINE_TIME2
,      MACHINE_TIME3
,      MACHINE_TIME4
,      MACHINE_TIME5
,      LABOR_TIME1
,      LABOR_TIME2
,      LABOR_TIME3
,      LABOR_TIME4
,      LABOR_TIME5
,      TOTAL_TIME1
,      TOTAL_TIME2
,      TOTAL_TIME3
,      TOTAL_TIME4
,      TOTAL_TIME5
,      PROCESS_VOLUME1
,      PROCESS_VOLUME2
,      PROCESS_VOLUME3
,      PROCESS_VOLUME4
,      PROCESS_VOLUME5
FROM APPS.BOM_MIXED_MODEL_MAP_CELLS_V;

Dependencies

[top of page]

APPS.BOM_MIXED_MODEL_MAP_CELLS_V references the following:

APPS: BOM_MIXED_MODEL_MAP_CELLS

APPS.BOM_MIXED_MODEL_MAP_CELLS_V is not referenced by any database object