eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_CATALOG_MIGRATION dependencies on MTL_CATEGORY_SETS

Line 185: from MTL_CATEGORY_SETS C where C.category_set_id = l_category_set_id;

181: BEGIN
182: -- Get structure id corresponding to Product Catalog
183: select C.structure_id,C.control_level,C.mult_item_cat_assign_flag
184: into l_structure_id, l_control_level, l_mult_item_cat_assign_flag
185: from MTL_CATEGORY_SETS C where C.category_set_id = l_category_set_id;
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to Product Catalog');

Line 533: from MTL_CATEGORY_SETS

529: PROCEDURE Retrieve_Category_Set(x_category_set_id OUT NOCOPY NUMBER,
530: x_warning_flag OUT NOCOPY VARCHAR2) IS
531: CURSOR C_Get_Cat_Set_Id IS
532: select category_set_id, hierarchy_enabled
533: from MTL_CATEGORY_SETS
534: where category_set_name = G_SME_CATEGORY_SET_NAME;
535:
536: CURSOR C_Check_Functional_Area(c_category_set_id NUMBER) IS
537: select 1

Line 538: from MTL_CATEGORY_SETS S, MTL_DEFAULT_CATEGORY_SETS D

534: where category_set_name = G_SME_CATEGORY_SET_NAME;
535:
536: CURSOR C_Check_Functional_Area(c_category_set_id NUMBER) IS
537: select 1
538: from MTL_CATEGORY_SETS S, MTL_DEFAULT_CATEGORY_SETS D
539: where S.category_set_id = D.category_set_id
540: and D.functional_area_id = G_FUNCTIONAL_AREA
541: and D.category_set_id = c_category_set_id;
542:

Line 591: from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS C

587: end if;
588:
589: -- Get structure id and control level associated with functional area 11
590: select C.structure_id, C.control_level into l_structure_id, l_control_level
591: from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS C
592: where D.functional_area_id = G_FUNCTIONAL_AREA and D.category_set_id = C.category_set_id;
593:
594: select MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
595:

Line 594: select MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

590: select C.structure_id, C.control_level into l_structure_id, l_control_level
591: from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS C
592: where D.functional_area_id = G_FUNCTIONAL_AREA and D.category_set_id = C.category_set_id;
593:
594: select MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
595:
596: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
597: X_ROWID => l_row_id,
598: X_CATEGORY_SET_ID => l_next_val,

Line 596: MTL_CATEGORY_SETS_PKG.INSERT_ROW (

592: where D.functional_area_id = G_FUNCTIONAL_AREA and D.category_set_id = C.category_set_id;
593:
594: select MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
595:
596: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
597: X_ROWID => l_row_id,
598: X_CATEGORY_SET_ID => l_next_val,
599: X_CATEGORY_SET_NAME => G_SME_CATEGORY_SET_NAME,
600: X_DESCRIPTION => G_SME_CATEGORY_SET_NAME,

Line 715: Update Mtl_Category_Sets

711: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
712: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Making SME set hierarchical');
713: end if;
714:
715: Update Mtl_Category_Sets
716: set hierarchy_enabled = 'Y'
717: where category_set_id = p_category_set_id;
718: END Make_SME_Set_Hierarchical;
719:

Line 1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));

1380:
1381: /* For testing purposes we can use the following statements.
1382: delete from mtl_categories_tl where category_id in
1383: (select category_id from mtl_categories_b where structure_id in
1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));
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');

Line 1386: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog');

1382: delete from mtl_categories_tl where category_id in
1383: (select category_id from mtl_categories_b where structure_id in
1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));
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');

Line 1388: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');

1384: (select structure_id from mtl_category_sets where category_set_name='SME Product Catalog'));
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');

Line 1390: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');

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;
1394: */

Line 1392: (select category_set_id from mtl_category_sets where category_set_name='SME Product Catalog');

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;
1394: */
1395:
1396: END AS_CATALOG_MIGRATION;