APPS.CTO_WORKBENCH_UTIL_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 429: from mtl_system_items_kfv

425: -- replaced org condition with rownum
426:
427: select concatenated_segments
428: into l_item_name
429: from mtl_system_items_kfv
430: where inventory_item_id = p_config_item
431: and rownum =1;
432:
433: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then

Line 437: from mtl_system_items_kfv mtl,

433: elsif p_ato_line_id is not null and p_config_item is null and p_item_type in ('MODEL','CLASS') then
434:
435: select concatenated_segments
436: into l_item_name
437: from mtl_system_items_kfv mtl,
438: oe_order_lines_all oel
439: where oel.ato_line_id = p_ato_line_id
440: and oel.item_type_code = 'CONFIG'
441: and oel.inventory_item_id = mtl.inventory_item_id

Line 456: l_item_desc mtl_system_items_kfv.description%type;

452: p_item_type IN Varchar2,
453: p_item_desc IN Varchar2,
454: p_config_item IN Number,
455: p_ship_org_id IN Number) return Varchar2 as
456: l_item_desc mtl_system_items_kfv.description%type;
457: Begin
458:
459: -- Commenting as part of bugfix 8453372
460: -- l_item_desc := p_item_desc;

Line 469: from mtl_system_items_kfv

465: -- Fixed bug 5447062
466: -- replaced org condition with rownum
467: /*select description
468: into l_item_desc
469: from mtl_system_items_kfv
470: where inventory_item_id = p_config_item
471: and rownum = 1;*/
472:
473: select description

Line 485: from mtl_system_items_kfv mtl,

481:
482: -- Changed this sql as part of bugfix 8453372. The sql now picks up data from tl table.
483: /*select description
484: into l_item_desc
485: from mtl_system_items_kfv mtl,
486: oe_order_lines_all oel
487: where mtl.inventory_item_id = oel.inventory_item_id
488: and mtl.organization_id = p_ship_org_id
489: and oel.ato_line_id = p_ato_line_id

Line 665: l_item_id mtl_system_items_kfv.inventory_item_id%type;

661: l_line_id Number;
662:
663: --Bugfix 13554996: New variable and cursor.
664: l_order_uom oe_order_lines_all.order_quantity_uom%type;
665: l_item_id mtl_system_items_kfv.inventory_item_id%type;
666:
667: cursor c_on_hand_qty(x_line_id number, x_order_uom varchar2, x_item_id number) is
668: select CTO_UTILITY_PK.convert_uom
669: (primary_uom_code,