DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 797: FROM icx_cat_categories_tl cat

793: --Get all the categories that have atleast one searchable attributes
794: --and has atleast one item loaded in the current internal_request_id
795: CURSOR getCategoriesCsr(p_internal_request_id NUMBER) IS
796: SELECT cat.rt_category_id
797: FROM icx_cat_categories_tl cat
798: WHERE cat.type = 2
799: AND cat.language = (SELECT language_code FROM fnd_languages WHERE installed_flag = 'B')
800: AND EXISTS (SELECT 'atleast one searchable descriptor'
801: FROM icx_cat_attributes_tl att