MSC_COMPONENT_SUBSTITUTES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID BILL_SEQUENCE_ID USAGE_QUANTITY PRIORITY ROUNDING_DIRECTION ORGANIZATION_ID SUBSTITUTE_ITEM_ID COMPONENT_SEQUENCE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY

Query

SQL_Statement

SELECT -1 PLAN_ID, bom.BILL_SEQUENCE_ID, decode(bsc.Substitute_Item_Quantity/decode(bsc.Substitute_Item_Quantity,0,1,abs(bsc.Substitute_Item_Quantity)),1, (bsc.Substitute_Item_Quantity/bc.Component_Yield_Factor)* bc.planning_factor/100.0, (bsc.Substitute_Item_Quantity*bc.Component_Yield_Factor)* bc.planning_factor/100.0 ) USAGE_QUANTITY, NULL PRIORITY, bc.ROUNDING_DIRECTION, bom.ORGANIZATION_ID, bsc.Substitute_Component_ID SUBSTITUTE_ITEM_ID, bsc.COMPONENT_SEQUENCE_ID, bsc.LAST_UPDATE_DATE, bsc.LAST_UPDATED_BY, bsc.CREATION_DATE, bsc.CREATED_BY FROM EGP_SUBSTITUTE_COMPONENTS bsc, msc_bom_components_v bc, msc_boms_v bom WHERE bsc.COMPONENT_SEQUENCE_ID = bc.COMPONENT_SEQUENCE_ID AND bc.BILL_SEQUENCE_ID = bom.BILL_SEQUENCE_ID AND ((bsc.acd_type IS NULL or bsc.acd_type = 1) AND (bc.disable_date IS NULL OR bc.disable_date >= trunc(sysdate) OR bc.Implementation_Date IS NULL))