MSC_AP_BOM_COMPONENTS_CONFIG_V
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: VIEW
Columns
Name |
---|
COMPONENT_SEQUENCE_ID BILL_SEQUENCE_ID ORGANIZATION_ID ORGANIZATION_CODE OPERATION_SEQ_NO FIND_NUMBER INVENTORY_ITEM_ID COMPONENT_NAME CONFIG_ITEM_ID ASSEMBLY_NAME COMPONENT_TYPE BASIS_TYPE UOM_CODE USAGE_QTY COMPONENT_YIELD_FACTOR EFFECTIVITY_DATE DISABLE_DATE OPTIONAL_COMPONENT WIP_SUPPLY_TYPE PLANNING_FACTOR ATP_FLAG ROUNDING_DIRECTION REVISION_ID COMPONENT_ITEM_HIERARCHY |
Query
SQL_Statement |
---|
SELECT CTO.COMPONENT_SEQUENCE_ID, CTO.BILL_SEQUENCE_ID, CTO.ORGANIZATION_ID, ITEM1.ORGANIZATION_CODE, 1 AS OPERATION_SEQ_NO, 1 AS FIND_NUMBER, CTO.INVENTORY_ITEM_ID, ITEM1.ITEM_NUMBER AS COMPONENT_NAME, CTO.CONFIG_ITEM_ID, ITEM2.ITEM_NUMBER AS ASSEMBLY_NAME, CTO.COMPONENT_TYPE, CTO.BASIS_TYPE, CTO.UOM_CODE, CTO.USAGE_QTY, CTO.COMPONENT_YIELD_FACTOR, CTO.EFFECTIVITY_DATE, CTO.DISABLE_DATE, DECODE(CTO.OPTIONAL_COMPONENT,'Y',1,'N',2,2) OPTIONAL_COMPONENT, NVL(CTO.WIP_SUPPLY_TYPE,ITEM1.WIP_SUPPLY_TYPE) AS WIP_SUPPLY_TYPE, CTO.PLANNING_FACTOR, CTO.CHECK_ATP AS ATP_FLAG, CTO.ROUNDING_DIRECTION, CTO.REVISION_ID, CTO.COMPONENT_ITEM_HIERARCHY FROM cto_complete_instance_v cto, msc_planned_egp_system_items item1, msc_planned_egp_system_items item2 WHERE item1.inventory_item_id = cto.inventory_item_id AND item2.inventory_item_id = cto.config_item_id AND item1.organization_id = cto.organization_id AND item2.organization_id = cto.organization_id AND cto.component_type = -1 |