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.MSD_TRANSLATE_FACT_DATA dependencies on MSD_UOM_CONVERSIONS

Line 505: FROM msd_uom_conversions

501: /* CURSOR c_delete IS
502: SELECT from_uom_class, to_uom_class,
503: from_uom_code, to_uom_code,
504: base_uom_flag, sr_item_pk
505: FROM msd_uom_conversions
506: WHERE instance = p_instance_id
507: INTERSECT
508: SELECT from_uom_class, to_uom_class,
509: from_uom_code, to_uom_code,

Line 529: FROM msd_uom_conversions

525: MINUS
526: SELECT from_uom_class, to_uom_class,
527: from_uom_code, to_uom_code,
528: base_uom_flag, conversion_rate, sr_item_pk, item
529: FROM msd_uom_conversions
530: WHERE instance = p_instance_id and
531: nvl(instance,-999) <> 0;
532:
533:

Line 534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;

530: WHERE instance = p_instance_id and
531: nvl(instance,-999) <> 0;
532:
533:
534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;

Line 535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;

531: nvl(instance,-999) <> 0;
532:
533:
534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;

Line 536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;

532:
533:
534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
540:

Line 537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;

533:
534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
540:
541: a_from_uom_class from_uom_class_tab;

Line 538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;

534: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
540:
541: a_from_uom_class from_uom_class_tab;
542: a_to_uom_class from_uom_class_tab;

Line 539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;

535: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
536: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
537: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
538: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
539: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
540:
541: a_from_uom_class from_uom_class_tab;
542: a_to_uom_class from_uom_class_tab;
543: a_from_uom_code from_uom_code_tab;

Line 596: DELETE FROM msd_uom_conversions

592: a_to_uom_code, a_base_uom_flag, a_sr_item_pk;
593: CLOSE c_delete;
594: IF (a_from_uom_class.exists(1)) THEN
595: FORALL i IN a_from_uom_class.FIRST..a_from_uom_class.LAST
596: DELETE FROM msd_uom_conversions
597: WHERE instance = p_instance_id and
598: nvl(sr_item_pk,'NULL') = nvl(a_sr_item_pk(i), 'NULL') and
599: from_uom_class = a_from_uom_class(i) and
600: to_uom_class = a_to_uom_class(i) and

Line 615: INSERT INTO msd_uom_conversions(

611: CLOSE c_insert;
612:
613: IF (a_from_uom_class.exists(1)) THEN
614: FORALL i IN a_from_uom_class.FIRST..a_from_uom_class.LAST
615: INSERT INTO msd_uom_conversions(
616: INSTANCE, SR_ITEM_PK, ITEM, FROM_UOM_CLASS, TO_UOM_CLASS,
617: FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG,
618: CONVERSION_RATE, CREATION_DATE, CREATED_BY,
619: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,

Line 631: v_sql_stmt := ' MERGE INTO msd_uom_conversions muc '||

627: END IF;
628:
629: */
630:
631: v_sql_stmt := ' MERGE INTO msd_uom_conversions muc '||
632: ' USING (SELECT from_uom_class, '||
633: ' to_uom_class, '||
634: ' from_uom_code, '||
635: ' to_uom_code, '||