APPS.MSD_DEM_COLLECT_UOMS dependencies on MSD_DEM_ENTITIES_INUSE

Line 239: from msd_dem_entities_inuse

235: as
236:
237: cursor get_uom_metadata is
238: select table_name, column_name
239: from msd_dem_entities_inuse
240: where ebs_entity = 'UOM'
241: and demantra_entity = 'DISPLAY_UNIT'
242: and internal_name = p_uom_code;
243:

Line 302: msd_dem_entities_inuse

298: as
299:
300: cursor verify_entities_inuse is
301: select 1 from
302: msd_dem_entities_inuse
303: where internal_name = p_uom_code
304: and ebs_entity = 'UOM';
305:
306: type c_get_new_uom_display_unit is ref cursor;

Line 354: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''UOM'' )' ||

350: ' select distinct display_units_id from ' || get_lookup_value('MSD_DEM_TABLES', 'DCM_PRODUCTS_UNITS') || ' ' || ')' ||
351: ' and data_field in ' ||
352: ' (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where data_field like ''EBSUOM%'' ' ||
353: ' minus ' ||
354: ' select column_name from msd_dem_entities_inuse where ebs_entity = ''UOM'' )' ||
355: ' and rownum < 2';
356:
357: msd_dem_common_utilities.log_debug(l_stmt_new_uom_display_unit);
358: -- syenamar

Line 372: l_stmt := 'insert into msd_dem_entities_inuse(

368: end if;
369: close get_new_uom_display_unit;
370:
371:
372: l_stmt := 'insert into msd_dem_entities_inuse(
373: ebs_entity
374: ,demantra_entity
375: ,internal_name
376: ,table_name

Line 469: l_stmt := 'update msd_dem_entities_inuse set table_name = (select data_table from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||

465: -- syenamar
466:
467: else
468: l_stmt := null;
469: l_stmt := 'update msd_dem_entities_inuse set table_name = (select data_table from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :1)' ||
470: ', column_name = (select data_field from ' || get_lookup_value('MSD_DEM_TABLES', 'DISPLAY_UNITS') || ' where display_units = :2)' ||
471: 'where ebs_entity = ''UOM'' and demantra_entity = ''DISPLAY_UNIT'' and internal_name = :3';
472:
473: msd_dem_common_utilities.log_debug(l_stmt);