APPS.ASL_EXCEL_UTIL_PVT dependencies on MTL_ITEM_CATEGORIES

Line 192: FROM MTL_ITEM_CATEGORIES

188:
189: /*
190: CURSOR C_DOWNLOADED_INV_CATEGORY(p_org_id NUMBER, p_user_id NUMBER, p_app_id NUMBER, p_resp_id NUMBER) IS
191: SELECT DISTINCT CATEGORY_ID
192: FROM MTL_ITEM_CATEGORIES
193: WHERE ORGANIZATION_ID = p_org_id
194: AND CATEGORY_ID in
195: (SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id,p_resp_id,p_app_id)
196: FROM DUAL

Line 204: FROM MTL_ITEM_CATEGORIES

200: l_inv_categories varchar(2000) := '';
201:
202: CURSOR C_DOWNLOADED_INV_CATEGORY(p_org_id NUMBER, p_user_id NUMBER, p_app_id NUMBER, p_resp_id NUMBER) IS
203: SELECT DISTINCT CATEGORY_ID
204: FROM MTL_ITEM_CATEGORIES
205: WHERE ORGANIZATION_ID = p_org_id
206: AND INSTR(l_inv_categories, fnd_global.local_chr(39)||to_char(CATEGORY_ID)|| fnd_global.local_chr(39))>0;
207:
208: l_old_inv_catgry_rec ASL_OLD_INV_CATEGORY_REC_TYPE;