APPS.INVIDIT1 dependencies on MTL_ITEM_CATEGORIES

Line 652: FROM mtl_item_categories

648:
649: CURSOR csr_Folder_Category
650: IS
651: SELECT category_id, NULL
652: FROM mtl_item_categories
653: WHERE
654: inventory_item_id = X_item_id
655: AND organization_id = X_org_id
656: AND category_set_id = p_Folder_Category_Set_id;

Line 1490: l_category_row_stmt := '(SELECT MIC.INVENTORY_ITEM_ID FROM MTL_ITEM_CATEGORIES MIC ' ||

1486:
1487: -- Start Item Category Query Building.
1488: IF p_category_set.COUNT <> 0 THEN
1489: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1490: l_category_row_stmt := '(SELECT MIC.INVENTORY_ITEM_ID FROM MTL_ITEM_CATEGORIES MIC ' ||
1491: ' WHERE MIC.CATEGORY_SET_ID = :category_set' || l_category_bind ||
1492: ' AND MIC.CATEGORY_ID = :category_id' || l_category_bind ||
1493: ' AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID)';
1494: l_category_bind := l_category_bind + 1;