DBA Data[Home] [Help]

APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on AK_REGION_ITEMS

Line 234: and exists (select 'x' from ak_region_items ri

230: AND AA.ATTRIBUTE_APPLICATION_ID = FAV.APPLICATION_ID
231: and aa.attribute_code = p_ak_attribute
232: and exists (select 'x' from ak_regions r
233: where r.region_code = p_ak_region)
234: and exists (select 'x' from ak_region_items ri
235: where ri.region_code = p_ak_region
236: and ri.attribute_code = aa.attribute_code );
237:
238: /* --commented for performance issue bug#5484903

Line 240: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a

236: and ri.attribute_code = aa.attribute_code );
237:
238: /* --commented for performance issue bug#5484903
239: SELECT a.attribute_label_long
240: FROM ak_region_items ri, AK_REGIONS r, AK_ATTRIBUTES_vL a
241: WHERE ri.region_code = r.region_code
242: AND ri.attribute_code = a.attribute_code
243: AND ri.region_code = p_ak_region
244: AND ri.attribute_code = p_ak_attribute; */