DBA Data[Home] [Help]

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_ITEMS

Line 692: FROM msc_items

688:
689: IF p_item_id IS NOT NULL THEN
690: SELECT item_name
691: INTO l_item_name
692: FROM msc_items
693: WHERE inventory_item_id = p_item_id;
694: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_ITEM',l_language_code) || ': ' || l_item_name || fnd_global.local_chr(10);
695: END IF;
696:

Line 1162: from msc_items

1158: select item_name,
1159: description
1160: into t_master_item_name(j),
1161: t_master_item_desc(j)
1162: from msc_items
1163: where inventory_item_id = t_item_id(j);
1164: exception
1165: when others then
1166: t_master_item_name(j) := t_item_name(j);