DBA Data[Home] [Help]

APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on FND_GRANTS

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

850: FROM MTL_SYSTEM_ITEMS_B msib, MTL_PARAMETERS mp
851: WHERE msib.STYLE_ITEM_ID = p_style_item_id
852: AND msib.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
853: AND mp.ORGANIZATION_ID = p_organization_id
854: AND NOT EXISTS (SELECT NULL FROM FND_GRANTS fg
855: WHERE fg.INSTANCE_TYPE = 'INSTANCE'
856: AND fg.INSTANCE_PK1_VALUE = TO_CHAR(msib.INVENTORY_ITEM_ID)
857: AND fg.INSTANCE_PK2_VALUE = TO_CHAR(p_organization_id)
858: AND fg.OBJECT_ID = l_object_id