APPS.BOM_GTIN_RULES dependencies on MTL_SYSTEM_ITEMS_B

Line 453: SELECT primary_uom_code INTO l_component_uom FROM mtl_system_items_b WHERE

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

Line 457: SELECT primary_uom_code INTO l_assembly_uom FROM mtl_system_items_b WHERE

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

Line 637: FROM MTL_SYSTEM_ITEMS_B

633: BEGIN
634:
635: SELECT primary_uom_code
636: INTO l_src_uom_code
637: FROM MTL_SYSTEM_ITEMS_B
638: WHERE inventory_item_id = p_source_item_id
639: and organization_id = p_src_org_id;
640:
641: SELECT primary_uom_code

Line 643: FROM MTL_SYSTEM_ITEMS_B

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

Line 699: mtl_system_items_b msi

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