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 1480: l_category_row_stmt := '(SELECT MIC.INVENTORY_ITEM_ID FROM MTL_ITEM_CATEGORIES MIC ' ||

1476:
1477: -- Start Item Category Query Building.
1478: IF p_category_set.COUNT <> 0 THEN
1479: FOR i IN p_category_set.FIRST .. p_category_set.LAST LOOP
1480: l_category_row_stmt := '(SELECT MIC.INVENTORY_ITEM_ID FROM MTL_ITEM_CATEGORIES MIC ' ||
1481: ' WHERE MIC.CATEGORY_SET_ID = :category_set' || l_category_bind ||
1482: ' AND MIC.CATEGORY_ID = :category_id' || l_category_bind ||
1483: ' AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID)';
1484: l_category_bind := l_category_bind + 1;