DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on MTL_ITEM_CATEGORIES

Line 5716: mtl_item_categories MIC

5712: CURSOR get_category(p_item_id NUMBER)
5713: IS
5714: SELECT MIC.CATEGORY_ID
5715: FROM MTL_DEFAULT_CATEGORY_SETS MDCS,
5716: mtl_item_categories MIC
5717: WHERE MDCS.FUNCTIONAL_AREA_ID=7
5718: AND MDCS.CATEGORY_SET_ID=MIC.CATEGORY_SET_ID
5719: AND MIC.INVENTORY_ITEM_ID=p_item_id
5720: and MIC.organization_id = cs_std.get_item_valdn_orgzn_Id;