DBA Data[Home] [Help]

APPS.BOM_GLOBALS dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

1646:
1647: FUNCTION Get_Item_Name(p_item_id IN NUMBER,p_org_id IN NUMBER)
1648: RETURN VARCHAR2
1649: IS
1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1651: BEGIN
1652: SELECT concatenated_segments
1653: INTO l_item_name
1654: FROM mtl_system_items_kfv

Line 1654: FROM mtl_system_items_kfv

1650: l_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1651: BEGIN
1652: SELECT concatenated_segments
1653: INTO l_item_name
1654: FROM mtl_system_items_kfv
1655: WHERE inventory_item_id = p_item_id
1656: AND organization_id = p_org_id;
1657: RETURN l_item_name;
1658: EXCEPTION