APPS.OKC_PRICE_PUB dependencies on OKX_ITEM_CATEGORIES_V

Line 2184: FROM OKX_ITEM_CATEGORIES_V ic,

2180: -- Bug 2304008 skekkar
2181: SELECT ic.id1
2182: BULK COLLECT
2183: INTO x_category_ids
2184: FROM OKX_ITEM_CATEGORIES_V ic,
2185: MTL_CATEGORIES_B c,
2186: FND_ID_FLEX_STRUCTURES fs
2187: WHERE c.category_id = ic.category_id
2188: AND c.structure_id = fs.id_flex_num

Line 2197: FROM OKX_ITEM_CATEGORIES_V

2193: /*
2194: SELECT ID1
2195: BULK COLLECT
2196: INTO x_category_ids
2197: FROM OKX_ITEM_CATEGORIES_V
2198: WHERE inventory_item_id = p_inventory_item_id
2199: AND organization_id = p_org_id;
2200: */
2201: /********************************************************