VIEW: APPS.MSC_PROCESS_EFFECTIVITY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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