APPS.EGO_DOM_SECURITY_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 586: ' from fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||

582: ' fnd_menus_tl granted_menu_tl ' ||
583: ' WHERE granted_menu.menu_id = grants.menu_id ' ||
584: ' AND grants.instance_type = ''SET'' AND grants.instance_pk1_value = ''*NULL*''' ||
585: ' AND grants.instance_set_id IN ( select instance_set.instance_set_id ' ||
586: ' from fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||
587: ' where instance_set.object_id = grants.object_id and ' ||
588: ' (instance_set.instance_set_name = ''EGO_ORG_ITEM_'' || ' ||
589: ' to_char(item.organization_id) or instance_set.instance_set_name = ''EGO_ORG_CAT_ITEM_'' || ' ||
590: ' to_char(item.organization_id) || ''_'' || to_char(item.ITEM_CATALOG_GROUP_ID)) ' ||

Line 636: ' fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||

632: ' fnd_menus_tl granted_menu_tl ' ||
633: ' WHERE grants.menu_id = granted_menu.menu_id ' ||
634: ' AND grants.instance_type= ''SET'' AND grants.instance_pk1_value = ''*NULL*'' AND ' ||
635: ' grants.instance_set_id IN ( select instance_set.instance_set_id from ' ||
636: ' fnd_object_instance_sets instance_set, mtl_system_items_b item ' ||
637: ' where instance_set.object_id = grants.object_id and (instance_set.instance_set_name = ''EGO_ORG_ITEM_'' || to_char(item.organization_id) ' ||
638: ' or instance_set.instance_set_name = ''EGO_ORG_CAT_ITEM_'' || to_char(item.organization_id) || ''_'' || to_char(item.ITEM_CATALOG_GROUP_ID)) ' ||
639: ' and obj.obj_name = ''EGO_ITEM'' AND item.inventory_item_id = ' || l_pk1_value || ' AND item.organization_id = ' || l_pk2_value ||
640: ' AND grants.grantee_type = ''GROUP'' ' ||

Line 1010: mtl_system_items_b

1006: l_item_catalog_group_id,
1007: l_lifecycle_id,
1008: l_lifecycle_id
1009: FROM
1010: mtl_system_items_b
1011: WHERE
1012: inventory_item_id = p_pk2_value AND
1013: organization_id = p_pk1_value;
1014: ENG_CHANGE_POLICY_PKG.GetChangePolicy