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 503: FROM msd_uom_conversions

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

Line 524: FROM msd_uom_conversions

520: MINUS
521: SELECT from_uom_class, to_uom_class,
522: from_uom_code, to_uom_code,
523: base_uom_flag, conversion_rate, sr_item_pk, item
524: FROM msd_uom_conversions
525: WHERE instance = p_instance_id and
526: nvl(instance,-999) <> 0;
527:
528:

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

525: WHERE instance = p_instance_id and
526: nvl(instance,-999) <> 0;
527:
528:
529: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;

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

526: nvl(instance,-999) <> 0;
527:
528:
529: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
534: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;

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

527:
528:
529: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
534: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
535:

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

528:
529: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
534: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
535:
536: a_from_uom_class from_uom_class_tab;

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

529: TYPE from_uom_class_tab IS TABLE OF msd_uom_conversions.from_uom_class%TYPE;
530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
534: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
535:
536: a_from_uom_class from_uom_class_tab;
537: a_to_uom_class from_uom_class_tab;

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

530: TYPE from_uom_code_tab IS TABLE OF msd_uom_conversions.from_uom_code%TYPE;
531: TYPE base_uom_flag_tab IS TABLE OF msd_uom_conversions.base_uom_flag%TYPE;
532: TYPE conversion_rate_tab IS TABLE OF msd_uom_conversions.conversion_rate%TYPE;
533: TYPE sr_item_pk_tab IS TABLE OF msd_uom_conversions.sr_item_pk%TYPE;
534: TYPE item_tab IS TABLE OF msd_uom_conversions.item%TYPE;
535:
536: a_from_uom_class from_uom_class_tab;
537: a_to_uom_class from_uom_class_tab;
538: a_from_uom_code from_uom_code_tab;

Line 589: DELETE FROM msd_uom_conversions

585: a_to_uom_code, a_base_uom_flag, a_sr_item_pk;
586: CLOSE c_delete;
587: IF (a_from_uom_class.exists(1)) THEN
588: FORALL i IN a_from_uom_class.FIRST..a_from_uom_class.LAST
589: DELETE FROM msd_uom_conversions
590: WHERE instance = p_instance_id and
591: nvl(sr_item_pk,'NULL') = nvl(a_sr_item_pk(i), 'NULL') and
592: from_uom_class = a_from_uom_class(i) and
593: to_uom_class = a_to_uom_class(i) and

Line 607: INSERT INTO msd_uom_conversions(

603: CLOSE c_insert;
604:
605: IF (a_from_uom_class.exists(1)) THEN
606: FORALL i IN a_from_uom_class.FIRST..a_from_uom_class.LAST
607: INSERT INTO msd_uom_conversions(
608: INSTANCE, SR_ITEM_PK, ITEM, FROM_UOM_CLASS, TO_UOM_CLASS,
609: FROM_UOM_CODE, TO_UOM_CODE, BASE_UOM_FLAG,
610: CONVERSION_RATE, CREATION_DATE, CREATED_BY,
611: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,