DBA Data[Home] [Help]

APPS.OKL_DEAL_CREATE_PUB dependencies on AK_REGION_ITEMS

Line 40: from ak_region_items ri, ak_regions r, ak_attributes_vl a

36:
37: CURSOR ak_prompt_csr(p_ak_region VARCHAR2, p_ak_attribute VARCHAR2) IS
38: --start modified abhsaxen for performance SQLID 20562566
39: select a.attribute_label_long
40: from ak_region_items ri, ak_regions r, ak_attributes_vl a
41: where ri.region_code = r.region_code
42: and ri.region_application_id = r.region_application_id
43: and ri.attribute_code = a.attribute_code
44: and ri.attribute_application_id = a.attribute_application_id