APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_ITEMS

Line 685: FROM msc_items

681:
682: IF p_item_id IS NOT NULL THEN
683: SELECT item_name
684: INTO l_item_name
685: FROM msc_items
686: WHERE inventory_item_id = p_item_id;
687: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
688: END IF;
689:

Line 778: from msc_items

774: IF (l_item_list is not null) THEN
775: begin
776: select inventory_item_id
777: into l_item_id
778: from msc_items
779: where item_name = l_item_list;
780: exception
781: when no_data_found then
782: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item not found: ' || l_item_list);

Line 1611: from msc_items

1607: select item_name,
1608: description
1609: into t_master_item_name(j),
1610: t_master_item_desc(j)
1611: from msc_items
1612: where inventory_item_id = t_item_id(j);
1613:
1614: t_supp_item_name.EXTEND;
1615: t_supp_item_desc.EXTEND;

Line 1701: from msc_items

1697: BEGIN
1698: select item_name, description
1699: into t_base_item_name(j),
1700: t_base_item_desc(j)
1701: from msc_items
1702: where inventory_item_id = t_base_item_id(j);
1703: EXCEPTION
1704: WHEN OTHERS THEN
1705: t_base_item_name(j) := null;