1. Tables and Views for SCM
  2. MSC_AP_BOMS_CONFIG_V

MSC_AP_BOMS_CONFIG_V

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: VIEW

Columns

Name

BILL_SEQUENCE_ID

ORGANIZATION_ID

ORGANIZATION_CODE

ITEM_NUMBER

ASSEMBLY_TYPE

ALTERNATE_BOM_DESIGNATOR

PRIMARY_FLAG

Query

SQL_Statement

SELECT

bsb.bill_sequence_id,

bsb.pk2_value organization_id ,

itm.organization_code,

itm.item_number,

1 as assembly_type,

'Primary' as alternate_bom_designator,

1 AS primary_flag

FROM cto_match_headers cto,

egp_structures_b bsb,

msc_planned_egp_system_items itm

WHERE bsb.pk1_value = TO_CHAR(cto.base_model_id)

AND cto.config_item_id = itm.inventory_item_id

AND TO_NUMBER(bsb.pk2_value) = itm.organization_id

AND bsb.alternate_bom_designator = 'Primary'