1. Tables and Views for SCM
  2. MSC_AP_BOM_COMPONENTS_CONFIG_V

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