機械翻訳について

MSC_AP_WD_OPERATION_OUTPUTS_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
WD_OPERATION_OUTPUT_ID OUTPUT_SEQ_NUMBER OUTPUT_TYPE OUTPUT_QUANTITY USAGE_QUANTITY UOM_CODE WORK_DEFINITION_ID WD_OPERATION_ID BILL_SEQUENCE_ID OPERATION_SEQ_NUMBER OP_EFFECTIVE_FROM_DATE ORGANIZATION_ID INVENTORY_ITEM_ID COMPL_SUBINVENTORY_CODE WORK_DEFINITION_CODE ORGANIZATION_CODE COMPONENT_TYPE ITEM_STRUCT_COMPONENT_REF_FLAG COMPONENT_NAME ASSEMBLY_NAME PRIMARY_FLAG

問合せ

SQL_Statement

SELECT wom.WD_OPERATION_OUTPUT_ID, wom.OUTPUT_SEQ_NUMBER, (CASE WHEN wom.output_type = 'PRODUCT' and wom.primary_flag = 'Y' THEN 1 WHEN wom.output_type = 'PRODUCT' and wom.primary_flag = 'N' THEN 2 WHEN wom.output_type = 'BY_PRODUCT' and wom.primary_flag = 'N' THEN 3 END)OUTPUT_TYPE, NVL(DECODE(wom.uom_code, esi1.uom_code, wom.OUTPUT_QUANTITY, DECODE(wom.OUTPUT_QUANTITY, NULL, NULL, inv_convert.inv_um_convert(esi1.inventory_item_id, 10, wom.OUTPUT_QUANTITY, wom.uom_code, esi1.uom_code, NULL, NULL) ) ), -99999) OUTPUT_QUANTITY, (NVL(DECODE(wom.uom_code, esi1.uom_code, wom.OUTPUT_QUANTITY, DECODE(wom.OUTPUT_QUANTITY, NULL, NULL, inv_convert.inv_um_convert(esi1.inventory_item_id, 10, wom.OUTPUT_QUANTITY, wom.uom_code, esi1.uom_code, NULL, NULL) ) ), -99999)/ nvl(decode(primary_output.uom_code, wob.primary_uom_code,primary_output.output_quantity, inv_convert.inv_um_convert(primary_output.inventory_item_id, 10,primary_output.output_quantity, primary_output.uom_code, wob.primary_uom_code,null, null)), -99999) ) usage_quantity, esi1.uom_code, wob.work_definition_id, wom.wd_operation_id, wob.bill_sequence_id, wob.operation_seq_number, wob.effectivity_date op_effective_from_date, wob.organization_id, wom.inventory_item_id, wom.compl_subinventory_code, wob.work_definition_code, wob.organization_code, 1 component_type, 2 item_struct_component_ref_flag, esi1.item_number component_name, wob.assembly_name, wom.primary_flag FROM msc_ap_wd_operations_v wob, wis_wd_operation_outputs wom, msc_planned_egp_system_items esi1, wis_wd_operation_outputs primary_output WHERE wob.wd_operation_id = wom.wd_operation_id AND wom.organization_id = esi1.organization_id AND wom.inventory_item_id = esi1.inventory_item_id AND wom.work_definition_id = primary_output.work_definition_id AND wob.assembly_item_id = primary_output.inventory_item_id AND primary_output.primary_flag = 'Y'