APPS.CTO_WORKBENCH_UTIL_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 416: from mtl_system_items_kfv

412: -- replaced org condition with rownum
413:
414: select concatenated_segments
415: into l_item_name
416: from mtl_system_items_kfv
417: where inventory_item_id = p_config_item
418: and rownum =1;
419:
420: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then

Line 424: from mtl_system_items_kfv mtl,

420: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then
421:
422: select concatenated_segments
423: into l_item_name
424: from mtl_system_items_kfv mtl,
425: oe_order_lines_all oel
426: where oel.ato_line_id = p_ato_line_id
427: and oel.item_type_code = 'CONFIG'
428: and oel.inventory_item_id = mtl.inventory_item_id

Line 443: l_item_desc mtl_system_items_kfv.description%type;

439: p_item_type IN Varchar2,
440: p_item_desc IN Varchar2,
441: p_config_item IN Number,
442: p_ship_org_id IN Number) return Varchar2 as
443: l_item_desc mtl_system_items_kfv.description%type;
444: Begin
445: l_item_desc := p_item_desc;
446: If p_ato_line_id is not null and p_config_item is not null and p_item_type in ('MODEL','CLASS') then
447:

Line 452: from mtl_system_items_kfv

448: -- Fixed bug 5447062
449: -- replaced org condition with rownum
450: select description
451: into l_item_desc
452: from mtl_system_items_kfv
453: where inventory_item_id = p_config_item
454: and rownum = 1;
455:
456: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then

Line 460: from mtl_system_items_kfv mtl,

456: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then
457:
458: select description
459: into l_item_desc
460: from mtl_system_items_kfv mtl,
461: oe_order_lines_all oel
462: where mtl.inventory_item_id = oel.inventory_item_id
463: and mtl.organization_id = p_ship_org_id
464: and oel.ato_line_id = p_ato_line_id