APPS.MSC_GET_NAME dependencies on MSC_ITEMS

Line 1200: from msc_items

1196: arg_plan_id is null or
1197: arg_instance_id is null then
1198: select item_name
1199: into v_item_name
1200: from msc_items
1201: where inventory_item_id = arg_item_id;
1202: return v_item_name;
1203: end if;
1204:

Line 1219: from msc_items

1215:
1216: exception when no_data_found then
1217: select item_name
1218: into v_item_name
1219: from msc_items
1220: where inventory_item_id = arg_item_id;
1221: return v_item_name;
1222:
1223: END item_name;

Line 5255: from msc_items

5251: arg_plan_id is null or
5252: arg_instance_id is null then
5253: select description
5254: into v_item_desc
5255: from msc_items
5256: where inventory_item_id = arg_item_id;
5257: return v_item_desc;
5258: end if;
5259:

Line 5274: from msc_items

5270:
5271: exception when no_data_found then
5272: select description
5273: into v_item_desc
5274: from msc_items
5275: where inventory_item_id = arg_item_id;
5276: return v_item_desc;
5277:
5278: END get_equipment_desc;