[Home] [Help]
2121: , OEOL.ordered_quantity
2122: , OEOL.order_quantity_uom
2123: , nvl( MSYI.config_orgs , 1)
2124: , MSYI.config_match
2125: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2126: where ato_line_id = p_bcol_line_id
2127: and OEOL.component_sequence_id = BIC.component_sequence_id
2128: and OEOL.inventory_item_id = MSYI.inventory_item_id
2129: and MSYI.organization_id = c_organization_id
4484:
4485: BEGIN
4486: SELECT 'Y'
4487: INTO l_found
4488: FROM BOM_INVENTORY_COMPONENTS BIC,
4489: BOM_BILL_OF_MATERIALS BOM
4490: WHERE BIC.bill_sequence_id = BOM.Common_bill_sequence_id
4491: AND BOM.assembly_item_id = l_model_item_id
4492: AND BOM.Organization_id = p_organization_id
4658: is
4659: select component_item_id
4660: , component_sequence_id
4661: , bom_item_type
4662: from bom_inventory_components
4663: where bill_sequence_id = c_bill_sequence_id
4664: and ( bom_item_type = '2' OR
4665: ( bom_item_type = '1' and nvl( wip_supply_type , 6 ) <> 6 )
4666: /* check only non phantom models and option classes */
4673: v_component_item_id number ;
4674: v_component_sequence_id number ;
4675: v_element_bill_seq_id number ;
4676:
4677: v_bom_item_type bom_inventory_components.bom_item_type%type;
4678: v_stmt_number number := -1 ;
4679:
4680: x_sourcing_rule_exists varchar2(2) ;
4681: x_new_org number ;
4848: to_char(bic.bill_sequence_id),
4849: bic.item_num,
4850: xGrpId
4851: from
4852: bom_inventory_components bic,
4853: bom_bill_of_materials bbom
4854: where bbom.assembly_item_id = p_item_id
4855: and bbom.organization_id = p_org_id
4856: and bbom.alternate_bom_designator is null
4891: CTO_UTILITY_PK.Concat_Values(bet.component_code,bic.bill_sequence_id),
4892: bic.item_num,
4893: xGrpId
4894: from
4895: bom_inventory_components bic,
4896: bom_bill_of_materials bbom,
4897: bom_explosion_temp bet,
4898: mtl_system_items msi
4899: where bbom.assembly_item_id = bet.component_item_id