DBA Data[Home] [Help]

APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 272: FROM MTL_SYSTEM_ITEMS_B_KFV

268: IF p_organization_id IS NULL OR p_inventory_item_id IS NULL THEN
269: RETURN NULL;
270: ELSE
271: SELECT concatenated_segments INTO l_item_concatenated_segments
272: FROM MTL_SYSTEM_ITEMS_B_KFV
273: WHERE organization_id = p_organization_id
274: AND inventory_item_id = p_inventory_item_id;
275:
276: RETURN l_item_concatenated_segments;

Line 1666: SELECT count(inventory_item_id) into l_count FROM mtl_system_items_b

1662: )
1663: RETURN BOOLEAN IS
1664: l_count number;
1665: BEGIN
1666: SELECT count(inventory_item_id) into l_count FROM mtl_system_items_b
1667: WHERE organization_id = p_org_id AND inventory_item_id = p_activity_id
1668: AND eam_item_type = 2;
1669:
1670: IF l_count = 0 THEN