DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on FND_GRANTS

Line 942: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg

938: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
939: WHERE msib.STYLE_ITEM_ID = p_style_item_id
940: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
941: AND mp.ORGANIZATION_ID = p_organization_id
942: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg
943: WHERE fg.INSTANCE_TYPE = 'INSTANCE'
944: AND fg.INSTANCE_PK1_VALUE = TO_CHAR(msib.INVENTORY_ITEM_ID)
945: AND fg.INSTANCE_PK2_VALUE = TO_CHAR(p_organization_id)
946: AND fg.OBJECT_ID = g_ego_item_object_id