eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.MSC_ROUTINGS_V

Source

View Text - Preformatted


SELECT routing.PLAN_ID as PLAN_ID1, routing.SR_INSTANCE_ID as SR_INSTANCE_ID1, routing.ORGANIZATION_ID as ORGANIZATION_ID1, routing.ASSEMBLY_ITEM_ID as ASSEMBLY_ITEM_ID1, routing.ROUTING_SEQUENCE_ID as ROUTING_SEQUENCE_ID1, routing.ROUTING_COMMENT as ROUTING_COMMENT1, routing.ALTERNATE_ROUTING_DESIGNATOR as ALTERNATE_ROUTING_DESIGNATOR1, operation.OPERATION_SEQ_NUM as OPERATION_SEQ_NUM2, opResource.RESOURCE_SEQ_NUM as RESOURCE_SEQ_NUM3, opResource.ALTERNATE_NUMBER as ALTERNATE_NUMBER3, operation.DEPARTMENT_ID as DEPARTMENT_ID2, operation.DEPARTMENT_CODE as DEPARTMENT_CODE2, opResource.RESOURCE_ID as RESOURCE_ID3, opResource.PRINCIPAL_FLAG as PRINCIPAL_FLAG3, opResource.UOM_CODE as UOM_CODE3, opResource.RESOURCE_UNITS as RESOURCE_UNITS3, opResource.RESOURCE_USAGE as RESOURCE_USAGE3, opResource.BASIS_TYPE as BASIS_TYPE3, opResource.MAX_RESOURCE_UNITS as MAX_RESOURCE_UNITS3, operation.YIELD as YIELD2, activity.SCHEDULE_FLAG as SCHEDULE_FLAG4, operation.EFFECTIVITY_DATE as EFFECTIVITY_DATE2, operation.DISABLE_DATE as DISABLE_DATE2, routing.LAST_UPDATE_DATE as LAST_UPDATE_DATE1, routing.LAST_UPDATED_BY as LAST_UPDATED_BY1, operation.LAST_UPDATE_DATE as LAST_UPDATE_DATE2, operation.LAST_UPDATED_BY as LAST_UPDATED_BY2, opResource.LAST_UPDATE_DATE as LAST_UPDATE_DATE3, opResource.LAST_UPDATED_BY as LAST_UPDATED_BY3, activity.LAST_UPDATE_DATE as LAST_UPDATE_DATE4, activity.LAST_UPDATED_BY as LAST_UPDATED_BY4, operation.NEW_PLAN_ID as NEW_PLAN_ID2, operation.SIMULATION_SET_ID as SIMULATION_SET_ID2, operation.NEW_PLAN_LIST as NEW_PLAN_LIST2, operation.APPLIED as APPLIED2, operation.PLAN_ID AS PLAN_ID2, operation.OPERATION_SEQUENCE_ID as OPERATION_SEQUENCE_ID2, operation.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID2, operation.SR_INSTANCE_ID AS SR_INSTANCE_ID2, opResource.PLAN_ID AS PLAN_ID3, opResource.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID3, opResource.OPERATION_SEQUENCE_ID AS OPERATION_SEQUENCE_ID3, opResource.SR_INSTANCE_ID AS SR_INSTANCE_ID3, opResource.ORGANIZATION_ID as ORGANIZATION_ID3, opResource.NEW_PLAN_ID AS NEW_PLAN_ID3, opResource.SIMULATION_SET_ID AS SIMULATION_SET_ID3, opResource.NEW_PLAN_LIST AS NEW_PLAN_LIST3, opResource.APPLIED AS APPLIED3, activity.PLAN_ID AS PLAN_ID4, activity.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID4, activity.OPERATION_SEQUENCE_ID AS OPERATION_SEQUENCE_ID4, activity.RESOURCE_SEQ_NUM AS RESOURCE_SEQ_NUM4, activity.SR_INSTANCE_ID AS SR_INSTANCE_ID4, activity.NEW_PLAN_ID AS NEW_PLAN_ID4, activity.SIMULATION_SET_ID AS SIMULATION_SET_ID4, activity.NEW_PLAN_LIST AS NEW_PLAN_LIST4, activity.APPLIED AS APPLIED4, activity.RESOURCE_OFFSET_PERCENT as RESOURCE_OFFSET_PERCENT4, operation.NET_PLANNING_PERCENT as NET_PLANNING_PERCENT2, operation.OPERATION_LEAD_TIME_PERCENT as OPERATION_LEAD_TIME_PERCENT2 FROM MSC_ROUTINGS routing, MSC_ROUTING_OPERATIONS operation, MSC_OPERATION_RESOURCES opResource, MSC_OPERATION_RESOURCE_SEQS activity WHERE routing.SR_INSTANCE_ID = operation.SR_INSTANCE_ID AND routing.ROUTING_SEQUENCE_ID = operation.ROUTING_SEQUENCE_ID (+) AND operation.PLAN_ID = opResource.PLAN_ID AND operation.SR_INSTANCE_ID = opResource.SR_INSTANCE_ID AND operation.OPERATION_SEQUENCE_ID = opResource.OPERATION_SEQUENCE_ID AND operation.ROUTING_SEQUENCE_ID = opResource.ROUTING_SEQUENCE_ID(+) AND opResource.PLAN_ID = activity.PLAN_ID AND opResource.SR_INSTANCE_ID = activity.SR_INSTANCE_ID AND opResource.ROUTING_SEQUENCE_ID = activity.ROUTING_SEQUENCE_ID AND opResource.OPERATION_SEQUENCE_ID = activity.OPERATION_SEQUENCE_ID(+) AND opResource.RESOURCE_SEQ_NUM = activity.RESOURCE_SEQ_NUM AND ( ( operation.simulation_set_id is not null and operation.simulation_set_id = opResource.simulation_set_id and opResource.simulation_set_id =activity.simulation_set_id) OR (operation.simulation_set_id is null and opResource.simulation_set_id is null and activity.simulation_set_id is null) )

View Text - HTML Formatted

SELECT ROUTING.PLAN_ID AS PLAN_ID1
, ROUTING.SR_INSTANCE_ID AS SR_INSTANCE_ID1
, ROUTING.ORGANIZATION_ID AS ORGANIZATION_ID1
, ROUTING.ASSEMBLY_ITEM_ID AS ASSEMBLY_ITEM_ID1
, ROUTING.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID1
, ROUTING.ROUTING_COMMENT AS ROUTING_COMMENT1
, ROUTING.ALTERNATE_ROUTING_DESIGNATOR AS ALTERNATE_ROUTING_DESIGNATOR1
, OPERATION.OPERATION_SEQ_NUM AS OPERATION_SEQ_NUM2
, OPRESOURCE.RESOURCE_SEQ_NUM AS RESOURCE_SEQ_NUM3
, OPRESOURCE.ALTERNATE_NUMBER AS ALTERNATE_NUMBER3
, OPERATION.DEPARTMENT_ID AS DEPARTMENT_ID2
, OPERATION.DEPARTMENT_CODE AS DEPARTMENT_CODE2
, OPRESOURCE.RESOURCE_ID AS RESOURCE_ID3
, OPRESOURCE.PRINCIPAL_FLAG AS PRINCIPAL_FLAG3
, OPRESOURCE.UOM_CODE AS UOM_CODE3
, OPRESOURCE.RESOURCE_UNITS AS RESOURCE_UNITS3
, OPRESOURCE.RESOURCE_USAGE AS RESOURCE_USAGE3
, OPRESOURCE.BASIS_TYPE AS BASIS_TYPE3
, OPRESOURCE.MAX_RESOURCE_UNITS AS MAX_RESOURCE_UNITS3
, OPERATION.YIELD AS YIELD2
, ACTIVITY.SCHEDULE_FLAG AS SCHEDULE_FLAG4
, OPERATION.EFFECTIVITY_DATE AS EFFECTIVITY_DATE2
, OPERATION.DISABLE_DATE AS DISABLE_DATE2
, ROUTING.LAST_UPDATE_DATE AS LAST_UPDATE_DATE1
, ROUTING.LAST_UPDATED_BY AS LAST_UPDATED_BY1
, OPERATION.LAST_UPDATE_DATE AS LAST_UPDATE_DATE2
, OPERATION.LAST_UPDATED_BY AS LAST_UPDATED_BY2
, OPRESOURCE.LAST_UPDATE_DATE AS LAST_UPDATE_DATE3
, OPRESOURCE.LAST_UPDATED_BY AS LAST_UPDATED_BY3
, ACTIVITY.LAST_UPDATE_DATE AS LAST_UPDATE_DATE4
, ACTIVITY.LAST_UPDATED_BY AS LAST_UPDATED_BY4
, OPERATION.NEW_PLAN_ID AS NEW_PLAN_ID2
, OPERATION.SIMULATION_SET_ID AS SIMULATION_SET_ID2
, OPERATION.NEW_PLAN_LIST AS NEW_PLAN_LIST2
, OPERATION.APPLIED AS APPLIED2
, OPERATION.PLAN_ID AS PLAN_ID2
, OPERATION.OPERATION_SEQUENCE_ID AS OPERATION_SEQUENCE_ID2
, OPERATION.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID2
, OPERATION.SR_INSTANCE_ID AS SR_INSTANCE_ID2
, OPRESOURCE.PLAN_ID AS PLAN_ID3
, OPRESOURCE.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID3
, OPRESOURCE.OPERATION_SEQUENCE_ID AS OPERATION_SEQUENCE_ID3
, OPRESOURCE.SR_INSTANCE_ID AS SR_INSTANCE_ID3
, OPRESOURCE.ORGANIZATION_ID AS ORGANIZATION_ID3
, OPRESOURCE.NEW_PLAN_ID AS NEW_PLAN_ID3
, OPRESOURCE.SIMULATION_SET_ID AS SIMULATION_SET_ID3
, OPRESOURCE.NEW_PLAN_LIST AS NEW_PLAN_LIST3
, OPRESOURCE.APPLIED AS APPLIED3
, ACTIVITY.PLAN_ID AS PLAN_ID4
, ACTIVITY.ROUTING_SEQUENCE_ID AS ROUTING_SEQUENCE_ID4
, ACTIVITY.OPERATION_SEQUENCE_ID AS OPERATION_SEQUENCE_ID4
, ACTIVITY.RESOURCE_SEQ_NUM AS RESOURCE_SEQ_NUM4
, ACTIVITY.SR_INSTANCE_ID AS SR_INSTANCE_ID4
, ACTIVITY.NEW_PLAN_ID AS NEW_PLAN_ID4
, ACTIVITY.SIMULATION_SET_ID AS SIMULATION_SET_ID4
, ACTIVITY.NEW_PLAN_LIST AS NEW_PLAN_LIST4
, ACTIVITY.APPLIED AS APPLIED4
, ACTIVITY.RESOURCE_OFFSET_PERCENT AS RESOURCE_OFFSET_PERCENT4
, OPERATION.NET_PLANNING_PERCENT AS NET_PLANNING_PERCENT2
, OPERATION.OPERATION_LEAD_TIME_PERCENT AS OPERATION_LEAD_TIME_PERCENT2
FROM MSC_ROUTINGS ROUTING
, MSC_ROUTING_OPERATIONS OPERATION
, MSC_OPERATION_RESOURCES OPRESOURCE
, MSC_OPERATION_RESOURCE_SEQS ACTIVITY
WHERE ROUTING.SR_INSTANCE_ID = OPERATION.SR_INSTANCE_ID
AND ROUTING.ROUTING_SEQUENCE_ID = OPERATION.ROUTING_SEQUENCE_ID (+)
AND OPERATION.PLAN_ID = OPRESOURCE.PLAN_ID
AND OPERATION.SR_INSTANCE_ID = OPRESOURCE.SR_INSTANCE_ID
AND OPERATION.OPERATION_SEQUENCE_ID = OPRESOURCE.OPERATION_SEQUENCE_ID
AND OPERATION.ROUTING_SEQUENCE_ID = OPRESOURCE.ROUTING_SEQUENCE_ID(+)
AND OPRESOURCE.PLAN_ID = ACTIVITY.PLAN_ID
AND OPRESOURCE.SR_INSTANCE_ID = ACTIVITY.SR_INSTANCE_ID
AND OPRESOURCE.ROUTING_SEQUENCE_ID = ACTIVITY.ROUTING_SEQUENCE_ID
AND OPRESOURCE.OPERATION_SEQUENCE_ID = ACTIVITY.OPERATION_SEQUENCE_ID(+)
AND OPRESOURCE.RESOURCE_SEQ_NUM = ACTIVITY.RESOURCE_SEQ_NUM
AND ( ( OPERATION.SIMULATION_SET_ID IS NOT NULL
AND OPERATION.SIMULATION_SET_ID = OPRESOURCE.SIMULATION_SET_ID
AND OPRESOURCE.SIMULATION_SET_ID =ACTIVITY.SIMULATION_SET_ID) OR (OPERATION.SIMULATION_SET_ID IS NULL
AND OPRESOURCE.SIMULATION_SET_ID IS NULL
AND ACTIVITY.SIMULATION_SET_ID IS NULL) )