DBA Data[Home] [Help]

APPS.OKL_RESI_CAT_SETS_PVT dependencies on MTL_ITEM_CATEGORIES

Line 104: MTL_ITEM_CATEGORIES MTL

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:

Line 124: MTL_ITEM_CATEGORIES MTL

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: