[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_PROC_V is not referenced by any database object
|
|
|