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