APPS.EGO_ITEM_WS_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1533: SELECT ITEM_CATALOG_GROUP_ID INTO l_item_catalog_group_id FROM MTL_SYSTEM_ITEMS_VL

1529: LOOP
1530: IF(j.item_id IS NOT NULL AND j.org_id IS NOT NULL AND j.rev_id IS NOT null)
1531: THEN
1532: --Finding which ICC is associated ot the item.
1533: SELECT ITEM_CATALOG_GROUP_ID INTO l_item_catalog_group_id FROM MTL_SYSTEM_ITEMS_VL
1534: WHERE INVENTORY_ITEM_ID = j.item_id AND ORGANIZATION_ID = j.org_id ;
1535:
1536: IF(l_item_catalog_group_id IS NULL ) THEN
1537: NULL;