APPS.MSD_TRANSLATE_FACT_DATA dependencies on MSD_ST_UOM_CONVERSIONS

Line 509: FROM msd_st_uom_conversions

505: INTERSECT
506: SELECT from_uom_class, to_uom_class,
507: from_uom_code, to_uom_code,
508: base_uom_flag, sr_item_pk
509: FROM msd_st_uom_conversions
510: WHERE instance = p_instance_id;
511:
512: /* Cursor for insert */
513: CURSOR c_insert IS

Line 517: FROM msd_st_uom_conversions

513: CURSOR c_insert IS
514: SELECT from_uom_class, to_uom_class,
515: from_uom_code, to_uom_code,
516: base_uom_flag, conversion_rate, sr_item_pk, item
517: FROM msd_st_uom_conversions
518: WHERE instance = p_instance_id and
519: nvl(instance,-999) <> 0
520: MINUS
521: SELECT from_uom_class, to_uom_class,

Line 566: DELETE FROM msd_st_uom_conversions

562: v_instance_id := p_instance_id;
563: retcode :=0;
564:
565: IF p_dest_table = MSD_COMMON_UTILITIES.UOM_STAGING_TABLE THEN
566: DELETE FROM msd_st_uom_conversions
567: WHERE instance = p_instance_id;
568:
569: v_sql_stmt := 'INSERT INTO ' || p_dest_table ||
570: ' ( INSTANCE, SR_ITEM_PK, ITEM, FROM_UOM_CLASS, TO_UOM_CLASS, ' ||