MSC_AP_ROUTING_VERSIONS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ASSEMBLY_NAME ASSEMBLY_ITEM_ID ORGANIZATION_ID ORGANIZATION_CODE WORK_DEFINITION_CODE VERSION_NUMBER EFFECTIVE_FROM_DATE EFFECTIVE_TO_DATE MIN_BATCH_QUANTITY MAX_BATCH_QUANTITY WORK_DEFINITION_ID ROW_ID

Query

SQL_Statement

SELECT esi.item_number assembly_name, esi.inventory_item_id assembly_item_id, wwv.organization_id , esi.organization_code organization_code, wdn.work_definition_code, wwv.version_number, wwv.effective_from_date, wwv.effective_to_date, wwv.minimum_batch_quantity min_batch_quantity, wwv.maximum_batch_quantity max_batch_quantity, wd.work_definition_id, wwv.rowid row_id FROM wis_work_definitions wd, wis_work_methods_b wm, wis_work_definition_names_b wdn, wis_wd_versions wwv, msc_planned_egp_system_items esi WHERE wm.work_method_id = wd.work_method_id AND wdn.work_definition_name_id = wd.work_definition_name_id AND wwv.work_definition_id = wd.work_definition_id AND esi.inventory_item_id = wd.inventory_item_id AND esi.organization_id = wd.organization_id AND wdn.used_in_planning_flag = 'Y' AND wd.status_code IN ('ACTIVE','PENDING_INACTIVE') AND wm.work_method_code ='PROCESS_MANUFACTURING'