100: COUNT(1)
101: INTO
102: l_temp_cnt
103: FROM
104: MTL_ITEM_CATEGORIES MTL
105: WHERE
106: MTL.INVENTORY_ITEM_ID = p_res_upd_tbl(i).inventory_item_id
107: AND MTL.ORGANIZATION_ID = p_res_upd_tbl(i).organization_id;
108:
120: COUNT(1)
121: INTO
122: l_temp_cnt
123: FROM
124: MTL_ITEM_CATEGORIES MTL
125: WHERE
126: MTL.CATEGORY_ID = p_res_upd_tbl(i).category_id
127: AND MTL.CATEGORY_SET_ID = p_res_upd_tbl(i).category_set_id;
128: