APPS.BOM_GTIN_RULES dependencies on MTL_SYSTEM_ITEMS_B

Line 450: SELECT primary_uom_code INTO l_component_uom FROM mtl_system_items_b WHERE

446: l_uom_rate NUMBER;
447:
448: BEGIN
449:
450: SELECT primary_uom_code INTO l_component_uom FROM mtl_system_items_b WHERE
451: inventory_item_id = p_component_item_id AND
452: organization_id = p_organization_id;
453:
454: SELECT primary_uom_code INTO l_assembly_uom FROM mtl_system_items_b WHERE

Line 454: SELECT primary_uom_code INTO l_assembly_uom FROM mtl_system_items_b WHERE

450: SELECT primary_uom_code INTO l_component_uom FROM mtl_system_items_b WHERE
451: inventory_item_id = p_component_item_id AND
452: organization_id = p_organization_id;
453:
454: SELECT primary_uom_code INTO l_assembly_uom FROM mtl_system_items_b WHERE
455: inventory_item_id = p_assembly_item_id AND
456: organization_id = p_organization_id;
457:
458: l_uom_rate := INV_CONVERT.Inv_Um_Convert (p_component_item_id,

Line 634: FROM MTL_SYSTEM_ITEMS_B

630: BEGIN
631:
632: SELECT primary_uom_code
633: INTO l_src_uom_code
634: FROM MTL_SYSTEM_ITEMS_B
635: WHERE inventory_item_id = p_source_item_id
636: and organization_id = p_src_org_id;
637:
638: SELECT primary_uom_code

Line 640: FROM MTL_SYSTEM_ITEMS_B

636: and organization_id = p_src_org_id;
637:
638: SELECT primary_uom_code
639: INTO l_dest_uom_code
640: FROM MTL_SYSTEM_ITEMS_B
641: WHERE inventory_item_id = p_destn_item_id
642: and organization_id = p_dest_org_id;
643:
644: GET_UOM_CLASS_COMPATIBILITY(p_src_uom_code => l_src_uom_code,

Line 696: mtl_system_items_b msi

692: count(DISTINCT msi.weight_uom_code) weight_uom_code_cnt
693: FROM bom_explosions_all be,
694: ego_item_gtn_attrs_b ega,
695: ego_item_gtn_attrs_tl egal,
696: mtl_system_items_b msi
697: WHERE be.group_id = p_group_id
698: AND be.trade_item_descriptor = 'BASE_UNIT_OR_EACH'
699: AND be.component_item_id = msi.inventory_item_id
700: AND be.common_organization_id = msi.organization_id