[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BOM_MIXED_MODEL_MAP_PROC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  BOM.BOM_MIXED_MODEL_MAP_PROC_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. | |
| OPERATION_CODE1 | VARCHAR2 | (4) | Yes | Process or Line Op name shown in the first column of the map |
| OPERATION_CODE2 | VARCHAR2 | (4) | Process or Line Op name shown in the second column of the map | |
| OPERATION_CODE3 | VARCHAR2 | (4) | Process or Line Op name shown in the third column of the map | |
| OPERATION_CODE4 | VARCHAR2 | (4) | Process or Line Op name shown in the fourth column of the map | |
| OPERATION_CODE5 | VARCHAR2 | (4) | Process or Line Op name shown in the fifth column of the map | |
| MACHINE_WEIGHTED_TIME1 | NUMBER | Weighted machine time for the first process | ||
| MACHINE_WEIGHTED_TIME2 | NUMBER | Weighted machine time for the second process | ||
| MACHINE_WEIGHTED_TIME3 | NUMBER | Weighted machine time for the third process | ||
| MACHINE_WEIGHTED_TIME4 | NUMBER | Weighted machine time for the fourth process | ||
| MACHINE_WEIGHTED_TIME5 | NUMBER | Weighted machine time for the fifth process | ||
| LABOR_WEIGHTED_TIME1 | NUMBER | Weighted labor time for the first process | ||
| LABOR_WEIGHTED_TIME2 | NUMBER | Weighted labor time for the second process | ||
| LABOR_WEIGHTED_TIME3 | NUMBER | Weighted labor time for the third process | ||
| LABOR_WEIGHTED_TIME4 | NUMBER | Weighted labor time for the fourth process | ||
| LABOR_WEIGHTED_TIME5 | NUMBER | Weighted labor time for the fifth process | ||
| TOTAL_WEIGHTED_TIME1 | NUMBER | Weighted total time for the first process | ||
| TOTAL_WEIGHTED_TIME2 | NUMBER | Weighted total time for the second process | ||
| TOTAL_WEIGHTED_TIME3 | NUMBER | Weighted total time for the third process | ||
| TOTAL_WEIGHTED_TIME4 | NUMBER | Weighted total time for the fourth process | ||
| TOTAL_WEIGHTED_TIME5 | NUMBER | Weighted total time for the fifth process | ||
| MACHINES_NEEDED1 | NUMBER | Number of machines needed for the first process | ||
| MACHINES_NEEDED2 | NUMBER | Number of machines needed for the second process | ||
| MACHINES_NEEDED3 | NUMBER | Number of machines needed for the third process | ||
| MACHINES_NEEDED4 | NUMBER | Number of machines needed for the fourth process | ||
| MACHINES_NEEDED5 | NUMBER | Number of machines needed for the fifth process | ||
| MACHINES_ASSIGNED1 | NUMBER | Number of machines assigned for the first process | ||
| MACHINES_ASSIGNED2 | NUMBER | Number of machines assigned for the second process | ||
| MACHINES_ASSIGNED3 | NUMBER | Number of machines assigned for the third process | ||
| MACHINES_ASSIGNED4 | NUMBER | Number of machines assigned for the fourth process | ||
| MACHINES_ASSIGNED5 | NUMBER | Number of machines assigned for the fifth process | ||
| LABOR_NEEDED1 | NUMBER | Number of labor resources needed for the first process | ||
| LABOR_NEEDED2 | NUMBER | Number of labor resources needed for the second process | ||
| LABOR_NEEDED3 | NUMBER | Number of labor resources needed for the third process | ||
| LABOR_NEEDED4 | NUMBER | Number of labor resources needed for the fourth process | ||
| LABOR_NEEDED5 | NUMBER | Number of labor resources needed for the fifth process | ||
| LABOR_ASSIGNED1 | NUMBER | Number of labor resources assigned for the first process | ||
| LABOR_ASSIGNED2 | NUMBER | Number of labor resources assigned for the second process | ||
| LABOR_ASSIGNED3 | NUMBER | Number of labor resources assigned for the third process | ||
| LABOR_ASSIGNED4 | NUMBER | Number of labor resources assigned for the fourth process | ||
| LABOR_ASSIGNED5 | NUMBER | Number of labor resources assigned for the fifth process | ||
| TAKT_TIME1 | NUMBER | TAKT time for the first process | ||
| TAKT_TIME2 | NUMBER | TAKT time for the second process | ||
| TAKT_TIME3 | NUMBER | TAKT time for the third process | ||
| TAKT_TIME4 | NUMBER | TAKT time for the fourth process | ||
| TAKT_TIME5 | NUMBER | TAKT time for the fifth process | ||
| TAKT_TIME_FOR_ASSIGNED1 | NUMBER | TAKT time from assigned labor or machines for the first process | ||
| TAKT_TIME_FOR_ASSIGNED2 | NUMBER | TAKT time from assigned labor or machines for the second process | ||
| TAKT_TIME_FOR_ASSIGNED3 | NUMBER | TAKT time from assigned labor or machines for the third process | ||
| TAKT_TIME_FOR_ASSIGNED4 | NUMBER | TAKT time from assigned labor or machines for the fourth process | ||
| TAKT_TIME_FOR_ASSIGNED5 | NUMBER | TAKT time from assigned labor or machines for the fifth process | ||
| IN_PROCESS_KANBAN1 | NUMBER | IPKs Needed for the first process | ||
| IN_PROCESS_KANBAN2 | NUMBER | IPKs Needed for the second process | ||
| IN_PROCESS_KANBAN3 | NUMBER | IPKs Needed for the third process | ||
| IN_PROCESS_KANBAN4 | NUMBER | IPKs Needed for the fourth process | ||
| IN_PROCESS_KANBAN5 | NUMBER | IPKs Needed for the fifth process | ||
| MACHINES_NEEDED_DELTA1 | NUMBER | Machines needed delta value between the current map and the baseline map for the first process | ||
| MACHINES_NEEDED_DELTA2 | NUMBER | Machines needed delta value between the current map and the baseline map for the second process | ||
| MACHINES_NEEDED_DELTA3 | NUMBER | Machines needed delta value between the current map and the baseline map for the third process | ||
| MACHINES_NEEDED_DELTA4 | NUMBER | Machines needed delta value between the current map and the baseline map for the fourth process | ||
| MACHINES_NEEDED_DELTA5 | NUMBER | Machines needed delta value between the current map and the baseline map for the fifth process | ||
| LABOR_NEEDED_DELTA1 | NUMBER | Labor needed delta value between the current map and the baseline map for the first process | ||
| LABOR_NEEDED_DELTA2 | NUMBER | Labor needed delta value between the current map and the baseline map for the second process | ||
| LABOR_NEEDED_DELTA3 | NUMBER | Labor needed delta value between the current map and the baseline map for the third process | ||
| LABOR_NEEDED_DELTA4 | NUMBER | Labor needed delta value between the current map and the baseline map for the fourth process | ||
| LABOR_NEEDED_DELTA5 | NUMBER | Labor needed delta value between the current map and the baseline map for the fifth process | ||
| IN_PROCESS_KANBAN_DELTA1 | NUMBER | IPKs needed delta value between the current map and the baseline map for the first process | ||
| IN_PROCESS_KANBAN_DELTA2 | NUMBER | IPKs needed delta value between the current map and the baseline map for the second process | ||
| IN_PROCESS_KANBAN_DELTA3 | NUMBER | IPKs needed delta value between the current map and the baseline map for the second process | ||
| IN_PROCESS_KANBAN_DELTA4 | NUMBER | IPKs needed delta value between the current map and the baseline map for the fourth process | ||
| IN_PROCESS_KANBAN_DELTA5 | NUMBER | IPKs needed delta value between the current map and the baseline map for the fifth process |
Cut, paste (and edit) the following text to query this object:
SELECT MIXED_MODEL_MAP_ID
, GROUP_NUMBER
, OPERATION_CODE1
, OPERATION_CODE2
, OPERATION_CODE3
, OPERATION_CODE4
, OPERATION_CODE5
, MACHINE_WEIGHTED_TIME1
, MACHINE_WEIGHTED_TIME2
, MACHINE_WEIGHTED_TIME3
, MACHINE_WEIGHTED_TIME4
, MACHINE_WEIGHTED_TIME5
, LABOR_WEIGHTED_TIME1
, LABOR_WEIGHTED_TIME2
, LABOR_WEIGHTED_TIME3
, LABOR_WEIGHTED_TIME4
, LABOR_WEIGHTED_TIME5
, TOTAL_WEIGHTED_TIME1
, TOTAL_WEIGHTED_TIME2
, TOTAL_WEIGHTED_TIME3
, TOTAL_WEIGHTED_TIME4
, TOTAL_WEIGHTED_TIME5
, MACHINES_NEEDED1
, MACHINES_NEEDED2
, MACHINES_NEEDED3
, MACHINES_NEEDED4
, MACHINES_NEEDED5
, MACHINES_ASSIGNED1
, MACHINES_ASSIGNED2
, MACHINES_ASSIGNED3
, MACHINES_ASSIGNED4
, MACHINES_ASSIGNED5
, LABOR_NEEDED1
, LABOR_NEEDED2
, LABOR_NEEDED3
, LABOR_NEEDED4
, LABOR_NEEDED5
, LABOR_ASSIGNED1
, LABOR_ASSIGNED2
, LABOR_ASSIGNED3
, LABOR_ASSIGNED4
, LABOR_ASSIGNED5
, TAKT_TIME1
, TAKT_TIME2
, TAKT_TIME3
, TAKT_TIME4
, TAKT_TIME5
, TAKT_TIME_FOR_ASSIGNED1
, TAKT_TIME_FOR_ASSIGNED2
, TAKT_TIME_FOR_ASSIGNED3
, TAKT_TIME_FOR_ASSIGNED4
, TAKT_TIME_FOR_ASSIGNED5
, IN_PROCESS_KANBAN1
, IN_PROCESS_KANBAN2
, IN_PROCESS_KANBAN3
, IN_PROCESS_KANBAN4
, IN_PROCESS_KANBAN5
, MACHINES_NEEDED_DELTA1
, MACHINES_NEEDED_DELTA2
, MACHINES_NEEDED_DELTA3
, MACHINES_NEEDED_DELTA4
, MACHINES_NEEDED_DELTA5
, LABOR_NEEDED_DELTA1
, LABOR_NEEDED_DELTA2
, LABOR_NEEDED_DELTA3
, LABOR_NEEDED_DELTA4
, LABOR_NEEDED_DELTA5
, IN_PROCESS_KANBAN_DELTA1
, IN_PROCESS_KANBAN_DELTA2
, IN_PROCESS_KANBAN_DELTA3
, IN_PROCESS_KANBAN_DELTA4
, IN_PROCESS_KANBAN_DELTA5
FROM APPS.BOM_MIXED_MODEL_MAP_PROC_V;
APPS
BOM_MIXED_MODEL_MAP_PROCESSES
APPS.BOM_MIXED_MODEL_MAP_PROC_V is not referenced by any database object
|
|
|
|