DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on FND_ID_FLEX_STRUCTURES

Line 2186: FND_ID_FLEX_STRUCTURES fs

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
2189: AND fs.id_flex_structure_code = 'ITEM_CATEGORIES'
2190: AND ic.inventory_item_id = p_inventory_item_id