MSC_AP_BOM_COMPONENTS

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

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)

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)