1. Tables and Views for SCM
  2. MSC_AP_WD_OP_OUT_CONFIG_V

MSC_AP_WD_OP_OUT_CONFIG_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

WD_OPERATION_OUTPUT_ID

OUTPUT_SEQ_NUMBER

OUTPUT_TYPE

OUTPUT_QUANTITY

UOM_CODE

WORK_DEFINITION_ID

WD_OPERATION_ID

OPERATION_SEQ_NUMBER

OP_EFFECTIVE_FROM_DATE

ORGANIZATION_ID

INVENTORY_ITEM_ID

WORK_DEFINITION_CODE

ORGANIZATION_CODE

COMPONENT_NAME

ASSEMBLY_NAME

Query

SQL_Statement

SELECT /*+ leading (wd wob wom) */

wom.wd_operation_material_id wd_operation_output_id,

wom.material_seq_number output_seq_number,

(CASE

WHEN wom.material_type = 'PRODUCT' and wom.item_struct_comp_ref_flag = 'Y'

THEN 1

WHEN wom.material_type = 'PRODUCT' and wom.item_struct_comp_ref_flag = 'N'

THEN 2

WHEN wom.material_type = 'BY_PRODUCT' and wom.item_struct_comp_ref_flag = 'N'

THEN 3

END) output_type,

NVL(DECODE(wom.uom_code, comp_esi.uom_code, wom.material_quantity,

DECODE(wom.material_quantity, NULL, NULL,

inv_convert.inv_um_convert(comp_esi.inventory_item_id,

10,

wom.material_quantity,

wom.uom_code,

comp_esi.uom_code,

NULL,

NULL)

)

), -99999) output_quantity,

comp_esi.uom_code,

wd.work_definition_id,

wom.wd_operation_id,

wom.operation_seq_number,

wob.effective_from_date op_effective_from_date,

wd.organization_id,

wom.inventory_item_id,

wd.work_definition_code,

assy_esi.organization_code,

comp_esi.item_number component_name,

assy_esi.item_number assembly_name

FROM

msc_api_wd_operation wob,

msc_api_wd_op_materials wom,

msc_api_work_def_header wd,

msc_planned_egp_system_items comp_esi,

msc_planned_egp_system_items assy_esi

WHERE wd.work_definition_id = wob.work_definition_id

AND wd.organization_id = wob.organization_id

AND wd.config_item_id = wob.config_item_id

AND wob.wd_operation_id = wom.wd_operation_id

AND wob.organization_id = wom.organization_id

AND wob.work_definition_id = wom.supply_locator_id

AND wom.inventory_item_id = comp_esi.inventory_item_id

AND wom.organization_id = comp_esi.organization_id

AND wob.config_item_id = assy_esi.inventory_item_id

AND wob.organization_id = assy_esi.organization_id

AND wom.config_item_id = wob.config_item_id

AND wom.material_type IN ('PRODUCT', 'BY_PRODUCT')

AND wom.item_struct_comp_ref_flag = 'N'