MSC_WIS_WD_OPERATION_OUTPUTS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
WD_OPERATION_OUTPUT_ID OUTPUT_SEQ_NUMBER OUTPUT_TYPE WORK_DEFINITION_ID WD_OPERATION_ID INVENTORY_ITEM_ID ORGANIZATION_ID PRIMARY_FLAG COMPL_SUBINVENTORY_CODE OUTPUT_QUANTITY UOM_CODE ORGANIZATION_CODE ITEM_NUMBER PRIMARY_UOM_CODE COMPONENT_SEQUENCE_ID FIND_NUMBER COMP_EFFECTIVITY_DATE COMP_DISABLE_DATE PRODUCT_YIELD BASIS_TYPE

Query

SQL_Statement

SELECT wwoo.wd_operation_output_id, wwoo.output_seq_number, wwoo.output_type, wwoo.work_definition_id, wwoo.wd_operation_id, wwoo.inventory_item_id, wwoo.organization_id, wwoo.primary_flag, wwoo.compl_subinventory_code, wwoo.output_quantity, wwoo.uom_code, opitem.organization_code, opitem.item_number, opitem.uom_code primary_uom_code, null component_sequence_id, null find_number, null comp_effectivity_date, null comp_disable_date, null product_yield, null basis_type FROM wis_wd_operation_outputs wwoo, msc_planned_egp_system_items opitem WHERE wwoo.organization_id = opitem.organization_id AND wwoo.inventory_item_id = opitem.inventory_item_id AND wwoo.component_sequence_id IS NULL UNION ALL SELECT wwoo.wd_operation_output_id, wwoo.output_seq_number, wwoo.output_type, wwoo.work_definition_id, wwoo.wd_operation_id, wwoo.inventory_item_id, wwoo.organization_id, wwoo.primary_flag, wwoo.compl_subinventory_code, wwoo.output_quantity, wwoo.uom_code, opitem.organization_code, opitem.item_number, opitem.uom_code primary_uom_code, comp.component_sequence_id, comp.operation_seq_num find_number, comp.effectivity_date comp_effectivity_date, comp.disable_date comp_disable_date, comp.component_yield_factor product_yield, comp.basis_type FROM wis_wd_operation_outputs wwoo, egp_components_b comp, msc_planned_egp_system_items opitem WHERE wwoo.organization_id = opitem.organization_id AND wwoo.inventory_item_id = opitem.inventory_item_id AND wwoo.component_sequence_id = comp.component_sequence_id AND wwoo.inventory_item_id = comp.pk1_value AND comp.pk1_value = opitem.inventory_item_id AND comp.pk2_value = opitem.organization_id