APPS.AS_CATALOG_MIGRATION dependencies on MTL_ITEM_CATEGORIES

Line 726: d) MTL_ITEM_CATEGORIES

722: It creates/updates records in following MTL tables:
723: a) MTL_CATEGORIES_B
724: b) MTL_CATEGORIES_TL
725: c) MTL_CATEGORY_SET_VALID_CATS
726: d) MTL_ITEM_CATEGORIES
727: */
728: PROCEDURE Process_Categories(p_int_typ_cod_id IN NUMBER,
729: p_structure_id IN NUMBER,
730: p_old_structure_id IN NUMBER,

Line 761: MTL_ITEM_CATEGORIES MIC

757: and DECODE(c_interest_level,0,MC.SEGMENT1,1,MC.SEGMENT2,2,MC.SEGMENT3,NULL) = c_type_code_id
758: and DECODE(c_interest_level,0,MC.SEGMENT2,1,MC.SEGMENT3,NULL) IS NULL
759: and DECODE(c_interest_level,0,MC.SEGMENT3,NULL) IS NULL
760: ) MC1,
761: MTL_ITEM_CATEGORIES MIC
762: where MIC.CATEGORY_ID = MC1.CATEGORY_ID;
763:
764: CURSOR C_Valid_Cat_Exists(c_category_set_id Number, c_category_id Number) IS
765: select 1

Line 1063: -- Create Legacy Records in MTL_ITEM_CATEGORIES

1059: IF p_interest_level = 2 THEN
1060: Cleanup_Legacy_Categories(p_category_set_id, l_out_legacy_category_id);
1061: END IF;
1062:
1063: -- Create Legacy Records in MTL_ITEM_CATEGORIES
1064: FOR scr in C_Get_Items(p_old_structure_id, p_int_typ_cod_id, p_interest_level)
1065: LOOP
1066:
1067: Assign_Item_To_Category(p_category_set_id=>p_category_set_id,

Line 1136: FROM mtl_item_categories

1132: , p_category_set_id NUMBER
1133: , p_category_id NUMBER
1134: ) IS
1135: SELECT COUNT( category_id ), COUNT( DECODE(category_id, p_category_id,1, NULL) )
1136: FROM mtl_item_categories
1137: WHERE
1138: inventory_item_id = p_inventory_item_id
1139: AND organization_id = p_organization_id
1140: AND category_set_id = p_category_set_id;

Line 1164: -- Update MTL_ITEM_CATEGORIES

1160: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Associating item ' || p_inventory_item_id || ' with category ' || p_category_id || ' for org id ' || p_organization_id || ' and set id ' || p_category_set_id);
1161: end if;
1162:
1163: /*
1164: -- Update MTL_ITEM_CATEGORIES
1165: Update MTL_ITEM_CATEGORIES
1166: Set category_id = p_category_id
1167: where category_set_id = p_category_set_id
1168: and organization_id = p_organization_id

Line 1165: Update MTL_ITEM_CATEGORIES

1161: end if;
1162:
1163: /*
1164: -- Update MTL_ITEM_CATEGORIES
1165: Update MTL_ITEM_CATEGORIES
1166: Set category_id = p_category_id
1167: where category_set_id = p_category_set_id
1168: and organization_id = p_organization_id
1169: and inventory_item_id = p_inventory_item_id;

Line 1238: DELETE FROM mtl_item_categories

1234: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting existing item associations');
1236: end if;
1237:
1238: DELETE FROM mtl_item_categories
1239: WHERE organization_id = p_organization_id
1240: AND inventory_item_id = p_inventory_item_id
1241: AND category_set_id = p_category_set_id;
1242: END IF;

Line 1366: update mtl_item_categories

1362: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb','Deleting unused legacy category with id:' || scr.category_id || ' and name:' || scr.category_name);
1364: end if;
1365: -- No need to update transaction tables since they are handled in a seperate migration program.
1366: update mtl_item_categories
1367: set category_id=p_category_id
1368: where category_id=scr.category_id
1369: and category_set_id=p_category_set_id;
1370: delete from ego_product_cat_set_ext

Line 1389: delete from mtl_item_categories where category_set_id in

1385: delete from mtl_categories_b where structure_id in
1386: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog');
1387: delete from mtl_category_set_valid_cats where category_set_id in
1388: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1389: delete from mtl_item_categories where category_set_id in
1390: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1391: delete from EGO_PRODUCT_CAT_SET_EXT where category_set_id in
1392: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');
1393: commit;