APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_ST_UOM_CONVERSIONS

Line 511: FROM msd_st_uom_conversions

507: INTERSECT
508: SELECT from_uom_class, to_uom_class,
509: from_uom_code, to_uom_code,
510: base_uom_flag, sr_item_pk
511: FROM msd_st_uom_conversions
512: WHERE instance = p_instance_id;
513: */
514:
515:

Line 522: FROM msd_st_uom_conversions

518: CURSOR c_insert IS
519: SELECT from_uom_class, to_uom_class,
520: from_uom_code, to_uom_code,
521: base_uom_flag, conversion_rate, sr_item_pk, item
522: FROM msd_st_uom_conversions
523: WHERE instance = p_instance_id and
524: nvl(instance,-999) <> 0
525: MINUS
526: SELECT from_uom_class, to_uom_class,

Line 571: DELETE FROM msd_st_uom_conversions

567: v_instance_id := p_instance_id;
568: retcode :=0;
569:
570: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN
571: DELETE FROM msd_st_uom_conversions
572: WHERE instance = p_instance_id;
573:
574: v_sql_stmt := 'INSERT INTO ' || p_dest_table ||
575: ' ( INSTANCE, SR_ITEM_PK, ITEM, FROM_UOM_CLASS, TO_UOM_CLASS, ' ||

Line 640: 'FROM msd_st_uom_conversions '||

636: ' base_uom_flag, '||
637: ' conversion_rate, '||
638: ' sr_item_pk, '||
639: ' item '||
640: 'FROM msd_st_uom_conversions '||
641: ' ) msuc '||
642: ' ON ( muc.from_uom_class = msuc.from_uom_class and '||
643: ' muc.to_uom_class = msuc.to_uom_class and '||
644: 'muc.from_uom_code = msuc.from_uom_code and '||