[Home] [Help] [Dependency Information]
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 |
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.
Name | Datatype | Length | 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 |
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;
APPS.BOM_MIXED_MODEL_MAP_CELLS_V is not referenced by any database object
|
|
|