3843: bic.wip_supply_type,
3844: bic.component_sequence_id
3845: into p_t_bcol(v_item).wip_supply_type,
3846: p_t_bcol(v_item).component_sequence_id
3847: from bom_bill_of_materials bbom,
3848: bom_inventory_components bic
3849: where bbom.bill_sequence_id =
3850: (select common_bill_sequence_id
3851: from bom_bill_of_materials
3847: from bom_bill_of_materials bbom,
3848: bom_inventory_components bic
3849: where bbom.bill_sequence_id =
3850: (select common_bill_sequence_id
3851: from bom_bill_of_materials
3852: where assembly_item_id = p_t_bcol(v_parent_item).inventory_item_id
3853: and alternate_bom_designator is null
3854: and rownum = 1)
3855: and bbom.common_bill_sequence_id = bic.bill_sequence_id