MSC_BOMS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID ASSEMBLY_TYPE ALTERNATE_BOM_DESIGNATOR SPECIFIC_ASSEMBLY_COMMENT PENDING_FROM_ECN SCALING_TYPE ASSEMBLY_QUANTITY UOM ORGANIZATION_ID ASSEMBLY_ITEM_ID BILL_SEQUENCE_ID COMMON_BILL_SEQUENCE_ID YIELDING_OP_SEQ_NUM LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY

Query

SQL_Statement

SELECT -1 PLAN_ID, structure_type_id ASSEMBLY_TYPE, bom.ALTERNATE_BOM_DESIGNATOR, bom.SPECIFIC_ASSEMBLY_COMMENT, NULL PENDING_FROM_ECN, NULL SCALING_TYPE, NULL ASSEMBLY_QUANTITY, NULL UOM, mp.ORGANIZATION_ID, bom.pk1_value ASSEMBLY_ITEM_ID, bom.BILL_SEQUENCE_ID, bom.COMMON_BILL_SEQUENCE_ID, NULL yielding_op_seq_num, bom.LAST_UPDATE_DATE, bom.LAST_UPDATED_BY, bom.CREATION_DATE, bom.CREATED_BY FROM egp_structures_b bom, msc_parameters mp where bom.obj_name = 'EGO_ITEM' and mp.organization_id = bom.pk2_value and bom.structure_type_id = 1 AND nvl(bom.EFFECTIVITY_CONTROL,-1) <> 4