APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_LEVEL_VALUES

Line 485: msd_level_values lvl

481: CURSOR new_item_c1 IS
482: SELECT lvl.sr_level_pk,
483: lvl.level_value
484: FROM msd_item_relationships rel,
485: msd_level_values lvl
486: WHERE lvl.instance = rel.instance_id
487: AND lvl.sr_level_pk = rel.inventory_item_id
488: AND lvl.level_id = 1
489: AND rel.inventory_item_id not in (SELECT re2.related_item_id

Line 499: msd_level_values lvl

495: CURSOR new_item_c1 IS
496: SELECT lvl.sr_level_pk,
497: lvl.level_value, rel.start_date, rel.end_date /*--Bug#4707819--*/
498: FROM msd_item_relationships rel,
499: msd_level_values lvl
500: WHERE lvl.instance = rel.instance_id
501: AND lvl.sr_level_pk = rel.inventory_item_id
502: AND lvl.level_id = 1
503: AND rel.instance_id = to_char(p_instance_id)

Line 522: FROM msd_level_values

518: AND instance_id = p_instance_id;
519:
520: CURSOR chk_item_exists (p_related_item_id in varchar2) IS
521: SELECT count(*)
522: FROM msd_level_values
523: WHERE instance = p_instance_id
524: AND sr_level_pk = p_related_item_id
525: AND level_id = 1;
526:

Line 590: FROM msd_level_values

586: l_count := 0;
587: /*
588: SELECT 1
589: INTO l_count
590: FROM msd_level_values
591: WHERE instance = p_instance_id
592: AND sr_level_pk = l_related_item_id
593: AND level_id = 1;
594: */