[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ROUTINGS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PLAN_ID1 | NUMBER | Yes | Plan Id | |
| SR_INSTANCE_ID1 | NUMBER | Yes | Instance Id | |
| ORGANIZATION_ID1 | NUMBER | Yes | Organization Id | |
| ASSEMBLY_ITEM_ID1 | NUMBER | Yes | ||
| ROUTING_SEQUENCE_ID1 | NUMBER | Yes | ||
| ROUTING_COMMENT1 | VARCHAR2 | (240) | Routing Comment | |
| ALTERNATE_ROUTING_DESIGNATOR1 | VARCHAR2 | (40) | Alternate Routing Designator | |
| OPERATION_SEQ_NUM2 | NUMBER | Yes | Operation Sequence Number | |
| RESOURCE_SEQ_NUM3 | NUMBER | Yes | Resource Sequence Number | |
| ALTERNATE_NUMBER3 | NUMBER | Yes | ||
| DEPARTMENT_ID2 | NUMBER | Yes | Department Id | |
| DEPARTMENT_CODE2 | VARCHAR2 | (10) | Department Code | |
| RESOURCE_ID3 | NUMBER | Yes | ||
| PRINCIPAL_FLAG3 | NUMBER | Yes | ||
| UOM_CODE3 | VARCHAR2 | (3) | Yes | |
| RESOURCE_UNITS3 | NUMBER | |||
| RESOURCE_USAGE3 | NUMBER | Yes | ||
| BASIS_TYPE3 | NUMBER | Yes | ||
| MAX_RESOURCE_UNITS3 | NUMBER | |||
| YIELD2 | NUMBER | |||
| SCHEDULE_FLAG4 | NUMBER | Yes | ||
| EFFECTIVITY_DATE2 | DATE | Yes | ||
| DISABLE_DATE2 | DATE | |||
| LAST_UPDATE_DATE1 | DATE | Yes | ||
| LAST_UPDATED_BY1 | NUMBER | Yes | ||
| LAST_UPDATE_DATE2 | DATE | Yes | ||
| LAST_UPDATE_BY2 | NUMBER | Yes | ||
| LAST_UPDATE_DATE3 | DATE | Yes | ||
| LAST_UPDATE_BY3 | NUMBER | Yes | ||
| LAST_UPDATE_DATE4 | DATE | Yes | ||
| LAST_UPDATE_BY4 | NUMBER | Yes | ||
| NEW_PLAN_ID2 | NUMBER | |||
| SIMULATION_SET_ID2 | NUMBER | |||
| NEW_PLAN_LIST2 | VARCHAR2 | (256) | ||
| APPLIED2 | NUMBER | |||
| PLAN_ID2 | NUMBER | Yes | ||
| OPERATION_SEQUENCE_ID2 | NUMBER | Yes | ||
| ROUTING_SEQUENCE_ID2 | NUMBER | Yes | ||
| SR_INSTANCE_ID2 | NUMBER | Yes | ||
| PLAN_ID3 | NUMBER | Yes | ||
| ROUTING_SEQUENCE_ID3 | NUMBER | Yes | ||
| OPERATION_SEQUENCE_ID3 | NUMBER | Yes | ||
| SR_INSTANCE_ID3 | NUMBER | Yes | ||
| ORGANIZATION_ID3 | NUMBER | |||
| NEW_PLAN_ID3 | NUMBER | |||
| SIMULATION_SET_ID3 | NUMBER | |||
| NEW_PLAN_LIST3 | VARCHAR2 | (256) | ||
| APPLIED3 | NUMBER | |||
| PLAN_ID4 | NUMBER | Yes | ||
| ROUTING_SEQUENCE_ID4 | NUMBER | Yes | ||
| OPERATION_SEQUENCE_ID4 | NUMBER | Yes | ||
| RESOURCE_SEQ_NUM4 | NUMBER | Yes | ||
| SR_INSTANCE_ID4 | NUMBER | Yes | ||
| NEW_PLAN_ID4 | NUMBER | |||
| SIMULATION_SET_ID4 | NUMBER | |||
| NEW_PLAN_LIST4 | VARCHAR2 | (256) | ||
| APPLIED4 | NUMBER | |||
| RESOURCE_OFFSET_PERCENT4 | NUMBER | |||
| NET_PLANNING_PERCENT2 | NUMBER | |||
| OPERATION_LEAD_TIME_PERCENT2 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID1
, SR_INSTANCE_ID1
, ORGANIZATION_ID1
, ASSEMBLY_ITEM_ID1
, ROUTING_SEQUENCE_ID1
, ROUTING_COMMENT1
, ALTERNATE_ROUTING_DESIGNATOR1
, OPERATION_SEQ_NUM2
, RESOURCE_SEQ_NUM3
, ALTERNATE_NUMBER3
, DEPARTMENT_ID2
, DEPARTMENT_CODE2
, RESOURCE_ID3
, PRINCIPAL_FLAG3
, UOM_CODE3
, RESOURCE_UNITS3
, RESOURCE_USAGE3
, BASIS_TYPE3
, MAX_RESOURCE_UNITS3
, YIELD2
, SCHEDULE_FLAG4
, EFFECTIVITY_DATE2
, DISABLE_DATE2
, LAST_UPDATE_DATE1
, LAST_UPDATED_BY1
, LAST_UPDATE_DATE2
, LAST_UPDATE_BY2
, LAST_UPDATE_DATE3
, LAST_UPDATE_BY3
, LAST_UPDATE_DATE4
, LAST_UPDATE_BY4
, NEW_PLAN_ID2
, SIMULATION_SET_ID2
, NEW_PLAN_LIST2
, APPLIED2
, PLAN_ID2
, OPERATION_SEQUENCE_ID2
, ROUTING_SEQUENCE_ID2
, SR_INSTANCE_ID2
, PLAN_ID3
, ROUTING_SEQUENCE_ID3
, OPERATION_SEQUENCE_ID3
, SR_INSTANCE_ID3
, ORGANIZATION_ID3
, NEW_PLAN_ID3
, SIMULATION_SET_ID3
, NEW_PLAN_LIST3
, APPLIED3
, PLAN_ID4
, ROUTING_SEQUENCE_ID4
, OPERATION_SEQUENCE_ID4
, RESOURCE_SEQ_NUM4
, SR_INSTANCE_ID4
, NEW_PLAN_ID4
, SIMULATION_SET_ID4
, NEW_PLAN_LIST4
, APPLIED4
, RESOURCE_OFFSET_PERCENT4
, NET_PLANNING_PERCENT2
, OPERATION_LEAD_TIME_PERCENT2
FROM APPS.MSC_ROUTINGS_V;
APPS
MSC_OPERATION_RESOURCES
MSC_OPERATION_RESOURCE_SEQS
MSC_ROUTINGS
MSC_ROUTING_OPERATIONS
APPS.MSC_ROUTINGS_V is not referenced by any database object
|
|
|
|