MSC_BOM_COMPONENTS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

PLAN_ID COMPONENT_SEQUENCE_ID ORGANIZATION_ID BILL_SEQUENCE_ID OPERATION_SEQ_NUM INVENTORY_ITEM_ID USING_ASSEMBLY_ID COMPONENT_TYPE SCALING_TYPE CHANGE_NOTICE REVISION UOM_CODE USAGE_QUANTITY COMPONENT_YIELD_FACTOR EFFECTIVITY_DATE DISABLE_DATE FROM_UNIT_NUMBER TO_UNIT_NUMBER USE_UP_CODE SUGGESTED_EFFECTIVITY_DATE DRIVING_ITEM_ID OPERATION_OFFSET_PERCENT OPTIONAL_COMPONENT OLD_EFFECTIVITY_DATE WIP_SUPPLY_TYPE PLANNING_FACTOR ATP_FLAG COMMON_BILL_SEQUENCE_ID SCALE_MULTIPLE SCALE_ROUNDING_VARIANCE ROUNDING_DIRECTION PRIMARY_FLAG CONTRIBUTE_TO_STEP_QTY OLD_COMPONENT_SEQUENCE_ID IMPLEMENTATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY

Query

SQL_Statement

SELECT -1 PLAN_ID, bc.COMPONENT_SEQUENCE_ID, bom.ORGANIZATION_ID, bom.BILL_SEQUENCE_ID, bc.OPERATION_SEQ_NUM, bc.pk1_value INVENTORY_ITEM_ID, bom.ASSEMBLY_ITEM_ID USING_ASSEMBLY_ID, bc.Bom_Item_Type COMPONENT_TYPE, bc.BASIS_TYPE SCALING_TYPE, NULL CHANGE_NOTICE, NULL REVISION, NULL UOM_CODE, decode(bc.Component_Quantity/decode(bc.Component_Quantity,null,1,0,1, abs(bc.Component_Quantity)),1, (bc.Component_Quantity/bc.Component_Yield_Factor)* bc.planning_factor/100.0 , (bc.Component_Quantity*bc.Component_Yield_Factor)* bc.planning_factor/100.0 ) USAGE_QUANTITY, bc.COMPONENT_YIELD_FACTOR, bc.EFFECTIVITY_DATE, bc.DISABLE_DATE, bc.From_End_Item_Unit_Number FROM_UNIT_NUMBER, bc.To_End_Item_Unit_Number TO_UNIT_NUMBER, NULL USE_UP_CODE, NULL SUGGESTED_EFFECTIVITY_DATE, NULL DRIVING_ITEM_ID, bc.Operation_Lead_Time_Percent OPERATION_OFFSET_PERCENT, bc.Optional OPTIONAL_COMPONENT, NULL OLD_EFFECTIVITY_DATE, bc.WIP_SUPPLY_TYPE, bc.PLANNING_FACTOR, bc.Check_ATP ATP_FLAG, bom.common_Bill_Sequence_ID, NULL SCALE_MULTIPLE, NULL SCALE_ROUNDING_VARIANCE, decode(nvl(bc.enforce_int_requirements,3),0,3,1,2,2,1,3) ROUNDING_DIRECTION, NULL PRIMARY_FLAG, NULL CONTRIBUTE_TO_STEP_QTY, bc.OLD_COMPONENT_SEQUENCE_ID, bc.IMPLEMENTATION_DATE, bc.LAST_UPDATE_DATE, bc.LAST_UPDATED_BY, bc.CREATION_DATE, bc.CREATED_BY FROM EGP_COMPONENTS_B bc, MSC_BOMS_V bom WHERE bom.common_Bill_Sequence_ID = bc.Bill_Sequence_ID