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' |