DBA Data[Home] [Help]

APPS.EGO_TRANSACTION_ATTRS_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 2683: SELECT ITEM_CATALOG_GROUP_ID INTO l_item_catalog_group_id FROM MTL_SYSTEM_ITEMS_VL

2679: IF(p_inventory_item_id IS NOT NULL AND p_organization_id IS NOT NULL AND p_revision_id IS NOT null)
2680: THEN
2681: x_is_inherited := 'Y';
2682: --Finding which ICC is associated ot the item.
2683: SELECT ITEM_CATALOG_GROUP_ID INTO l_item_catalog_group_id FROM MTL_SYSTEM_ITEMS_VL
2684: WHERE INVENTORY_ITEM_ID = p_inventory_item_id AND ORGANIZATION_ID = p_organization_id ;
2685:
2686: IF(l_ITEM_CATALOG_GROUP_ID IS NULL ) THEN
2687: RAISE l_exception ;