MSC_AP_BOM_COMPONENTS_V
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: VIEW
Columns
Name |
---|
ALTERNATE_BOM_DESIGNATOR COMPONENT_SEQUENCE_ID ORGANIZATION_ID BILL_SEQUENCE_ID OPERATION_SEQ_NUM FIND_NUMBER INVENTORY_ITEM_ID COMPONENT_NAME USING_ASSEMBLY_ID ASSEMBLY_NAME COMPONENT_TYPE BASIS_TYPE REVISION UOM_CODE USAGE_QUANTITY COMPONENT_YIELD_FACTOR EFFECTIVITY_DATE DISABLE_DATE OPERATION_OFFSET_PERCENT OPTIONAL_COMPONENT WIP_SUPPLY_TYPE ATP_FLAG ORGANIZATION_CODE PLANNING_FACTOR ROUNDING_DIRECTION |
Query
SQL_Statement |
---|
SELECT bom.alternate_bom_designator, bc.component_sequence_id, bom.pk2_value organization_id, bom.bill_sequence_id, 1 operation_seq_num, bc.operation_seq_num find_number, bc.pk1_value inventory_item_id, item.item_number component_name, bom.pk1_value using_assembly_id, esib.item_number assembly_name, bc.bom_item_type component_type, bc.basis_type basis_type, null revision, item.uom_code uom_code, NVL(decode(item.uom_code, bc.primary_uom_code, bc.Component_Quantity, DECODE(bc.Component_Quantity, NULL, NULL, inv_convert.inv_um_convert( item.inventory_item_id, 10, bc.Component_Quantity, bc.primary_uom_code, item.uom_code, null, null)) ), -99999) USAGE_QUANTITY, bc.component_yield_factor, bc.effectivity_date, bc.disable_date, bc.Operation_Lead_Time_Percent operation_offset_percent, bc.Optional optional_component, bc.wip_supply_type, bc.check_atp atp_flag, item.organization_code, bc.planning_factor, nvl(bc.enforce_int_requirements,0) rounding_direction FROM egp_components_b bc, egp_structures_b bom, MSC_PLANNED_EGP_SYSTEM_ITEMS item, MSC_PLANNED_EGP_SYSTEM_ITEMS esib WHERE bom.common_bill_sequence_id = bc.bill_sequence_id AND TO_NUMBER(bom.pk2_value) = item.organization_id AND bom.obj_name = 'EGO_ITEM' AND bom.structure_type_id = 1 AND NVL(bom.effectivity_control,-1) <> 4 AND TO_NUMBER(bc.pk1_value) = item.inventory_item_id AND bc.implementation_date IS NOT NULL AND esib.inventory_item_id = TO_NUMBER(bom.pk1_value) AND esib.organization_id = TO_NUMBER(bom.pk2_value) |