APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_ITEMS

Line 702: FROM msc_items

698:
699: IF p_item_id IS NOT NULL THEN
700: SELECT item_name
701: INTO l_item_name
702: FROM msc_items
703: WHERE inventory_item_id = p_item_id;
704: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
705: END IF;
706:

Line 795: from msc_items

791: IF (l_item_list is not null) THEN
792: begin
793: select inventory_item_id
794: into l_item_id
795: from msc_items
796: where item_name = l_item_list;
797: exception
798: when no_data_found then
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item not found: ' || l_item_list);

Line 1628: from msc_items

1624: select item_name,
1625: description
1626: into t_master_item_name(j),
1627: t_master_item_desc(j)
1628: from msc_items
1629: where inventory_item_id = t_item_id(j);
1630:
1631: t_supp_item_name.EXTEND;
1632: t_supp_item_desc.EXTEND;

Line 1718: from msc_items

1714: BEGIN
1715: select item_name, description
1716: into t_base_item_name(j),
1717: t_base_item_desc(j)
1718: from msc_items
1719: where inventory_item_id = t_base_item_id(j);
1720: EXCEPTION
1721: WHEN OTHERS THEN
1722: t_base_item_name(j) := null;