View: MSC_PROCESS_EFFECTIVITY_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_PROCESS_EFFECTIVITY_V

View Text

SELECT MPE.PLAN_ID
, MPE.ORGANIZATION_ID
, MPE.SR_INSTANCE_ID
, MSI.ORGANIZATION_CODE
, MPE.ITEM_ID
, MSI.ITEM_NAME
, MPE.PROCESS_SEQUENCE_ID
, MPE.EFFECTIVITY_DATE
, MPE.DISABLE_DATE
, MPE.MINIMUM_QUANTITY
, MPE.MAXIMUM_QUANTITY
, MPE.PREFERENCE
, MPE.ROUTING_SEQUENCE_ID
, MR.ALTERNATE_ROUTING_DESIGNATOR
, MPE.BILL_SEQUENCE_ID
, BOM.ALTERNATE_BOM_DESIGNATOR
, MPE.TOTAL_PRODUCT_CYCLE_TIME
, MPE.ITEM_PROCESS_COST
, MPE.LINE_ID
, DEPT.DEPARTMENT_CODE
, MPE.PRIMARY_LINE_FLAG
, MPE.PRODUCTION_LINE_RATE
FROM MSC_SYSTEM_ITEMS MSI
, MSC_ROUTINGS MR
, MSC_BOMS BOM
, MSC_DEPARTMENT_RESOURCES DEPT
, MSC_PROCESS_EFFECTIVITY MPE
WHERE MSI.PLAN_ID = MPE.PLAN_ID
AND MSI.SR_INSTANCE_ID = MPE.SR_INSTANCE_ID
AND MSI.ORGANIZATION_ID = MPE.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MPE.ITEM_ID
AND DEPT.DEPARTMENT_ID(+) = MPE.LINE_ID
AND DEPT.PLAN_ID(+) = MPE.PLAN_ID
AND DEPT.SR_INSTANCE_ID (+)= MPE.SR_INSTANCE_ID
AND DEPT.ORGANIZATION_ID(+) = MPE.ORGANIZATION_ID
AND DEPT.LINE_FLAG(+) = 1
AND BOM.BILL_SEQUENCE_ID(+) = MPE.BILL_SEQUENCE_ID
AND BOM.PLAN_ID(+) = MPE.PLAN_ID
AND BOM.SR_INSTANCE_ID(+) = MPE.SR_INSTANCE_ID
AND MR.ROUTING_SEQUENCE_ID(+) = MPE.ROUTING_SEQUENCE_ID
AND MR.PLAN_ID(+) = MPE.PLAN_ID
AND MR.SR_INSTANCE_ID(+) = MPE.SR_INSTANCE_ID

Columns