WIS_WD_PRODUCTS_V

Details

• Schema: FUSION

• Object owner: WIS

• Object type: VIEW

Columns

Name
WD_OPERATION_OUTPUT_ID ORGANIZATION_ID WD_OPERATION_ID WORK_DEFINITION_ID INVENTORY_ITEM_ID OUTPUT_SEQ_NUMBER OUTPUT_TYPE OUTPUT_QUANTITY UOM_CODE PRIMARY_FLAG COST_ALLOCATION_PERCENTAGE COSTING_PRIORITY PRIMARY_UOM_CODE WORK_METHOD_CODE

Query

SQL_Statement

SELECT wwoo.wd_operation_output_id, wwoo.organization_id, wwoo.wd_operation_id, wwoo.work_definition_id, wwoo.inventory_item_id, wwoo.output_seq_number, wwoo.output_type, wwoo.output_quantity, wwoo.uom_code, wwoo.primary_flag, wwoo.cost_allocation_percentage, wwoo.costing_priority, item.primary_uom_code, wwm.work_method_code FROM wis_work_definitions wd, wis_work_methods_b wwm, wis_wd_operation_outputs wwoo, egp_system_items_bv item WHERE nvl(wd.system_generated_flag, 'N') = 'N' AND wwm.work_method_id = wd.work_method_id AND wd.work_definition_id = wwoo.work_definition_id AND item.organization_id = wwoo.organization_id AND item.inventory_item_id = wwoo.inventory_item_id UNION ALL SELECT NULL AS wd_operation_output_id, wd.organization_id, NULL AS wd_operation_id, wd.work_definition_id, wd.inventory_item_id, NULL AS output_seq_number, 'PRODUCT' AS output_type, 1 AS output_quantity, item.primary_uom_code AS uom_code, 'Y' AS primary_flag, -1 AS cost_allocation_percentage, wd.costing_priority, item.primary_uom_code, wwm.work_method_code FROM wis_work_definitions wd, wis_work_methods_b wwm, egp_system_items_bv item WHERE wwm.work_method_id = wd.work_method_id AND item.organization_id = wd.organization_id AND item.inventory_item_id = wd.inventory_item_id AND wwm.work_method_code = 'DISCRETE_MANUFACTURING'