1. Tables and Views for SCM
  2. MSC_AP_BOMS_V

MSC_AP_BOMS_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ASSEMBLY_TYPE

ALTERNATE_BOM_DESIGNATOR

SPECIFIC_ASSEMBLY_COMMENT

ORGANIZATION_ID

ORGANIZATION_CODE

ASSEMBLY_ITEM_ID

ASSEMBLY_NAME

COMMON_BILL_SEQUENCE_ID

BILL_SEQUENCE_ID

PRIMARY_FLAG

BOM_ROWID

Query

SQL_Statement

SELECT

Bom.structure_type_id assembly_type,

bom.alternate_bom_designator,

bom.specific_assembly_comment,

bom.pk2_value organization_id,

itm.organization_code organization_code,

bom.pk1_value assembly_item_id,

itm.item_number assembly_name,

bom.common_bill_sequence_id,

bom.bill_sequence_id,

DECODE(bom.alternate_bom_designator, 'Primary', 1 ,2) primary_flag,

bom.rowid bom_rowid

FROM egp_structures_b bom,

msc_planned_egp_system_items itm

WHERE bom.obj_name = 'EGO_ITEM'

AND bom.structure_type_id = 1

AND NVL(bom.effectivity_control,-1) <> 4

AND itm.organization_id = TO_NUMBER(bom.pk2_value)

AND itm.inventory_item_id = TO_NUMBER(bom.pk1_value)