[Home] [Help]
2123: , OEOL.ordered_quantity
2124: , OEOL.order_quantity_uom
2125: , nvl( MSYI.config_orgs , 1)
2126: , MSYI.config_match
2127: from oe_order_lines_all OEOL , bom_inventory_components BIC , mtl_system_items MSYI
2128: where ato_line_id = p_bcol_line_id
2129: and OEOL.component_sequence_id = BIC.component_sequence_id
2130: and OEOL.inventory_item_id = MSYI.inventory_item_id
2131: and MSYI.organization_id = c_organization_id
4508:
4509: BEGIN
4510: SELECT 'Y'
4511: INTO l_found
4512: FROM BOM_INVENTORY_COMPONENTS BIC,
4513: BOM_BILL_OF_MATERIALS BOM
4514: WHERE BIC.bill_sequence_id = BOM.Common_bill_sequence_id
4515: AND BOM.assembly_item_id = l_model_item_id
4516: AND BOM.Organization_id = p_organization_id
4682: is
4683: select component_item_id
4684: , component_sequence_id
4685: , bom_item_type
4686: from bom_inventory_components
4687: where bill_sequence_id = c_bill_sequence_id
4688: and ( bom_item_type = '2' OR
4689: ( bom_item_type = '1' and nvl( wip_supply_type , 6 ) <> 6 )
4690: /* check only non phantom models and option classes */
4697: v_component_item_id number ;
4698: v_component_sequence_id number ;
4699: v_element_bill_seq_id number ;
4700:
4701: v_bom_item_type bom_inventory_components.bom_item_type%type;
4702: v_stmt_number number := -1 ;
4703:
4704: x_sourcing_rule_exists varchar2(2) ;
4705: x_new_org number ;
4872: to_char(bic.bill_sequence_id),
4873: bic.item_num,
4874: xGrpId
4875: from
4876: bom_inventory_components bic,
4877: bom_bill_of_materials bbom
4878: where bbom.assembly_item_id = p_item_id
4879: and bbom.organization_id = p_org_id
4880: and bbom.alternate_bom_designator is null
4915: CTO_UTILITY_PK.Concat_Values(bet.component_code,bic.bill_sequence_id),
4916: bic.item_num,
4917: xGrpId
4918: from
4919: bom_inventory_components bic,
4920: bom_bill_of_materials bbom,
4921: bom_explosion_temp bet,
4922: mtl_system_items msi
4923: where bbom.assembly_item_id = bet.component_item_id