APPS.MSC_PUBLISH_SAFETY_STOCK_PKG dependencies on MSC_ITEMS

Line 1110: FROM msc_items

1106:
1107: IF p_item_id IS NOT NULL THEN
1108: SELECT item_name
1109: INTO l_item_name
1110: FROM msc_items
1111: WHERE inventory_item_id = p_item_id;
1112: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
1113: END IF;
1114:

Line 1836: from msc_items

1832: select item_name,
1833: description
1834: into t_master_item_name(j),
1835: t_master_item_desc(j)
1836: from msc_items
1837: where inventory_item_id = t_item_id(j);
1838:
1839:
1840: end loop;