DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on MTL_SYSTEM_ITEMS_TL

Line 475: from mtl_system_items_tl

471: and rownum = 1;*/
472:
473: select description
474: into l_item_desc
475: from mtl_system_items_tl
476: where inventory_item_id = p_config_item
477: and language = userenv('LANG')
478: and rownum = 1;
479:

Line 494: from mtl_system_items_tl mtl,

490: and oel.item_type_code = 'CONFIG';*/
491:
492: select description
493: into l_item_desc
494: from mtl_system_items_tl mtl,
495: oe_order_lines_all oel
496: where mtl.inventory_item_id = oel.inventory_item_id
497: and mtl.organization_id = p_ship_org_id
498: and mtl.language = userenv('LANG')

Line 508: from mtl_system_items_tl mtl,

504: --Adding INCLUDED item type code for SUN ER#9793792
505: elsif p_ato_line_id is not null and p_item_type in ('STANDARD', 'OPTION', 'INCLUDED') then
506: select description
507: into l_item_desc
508: from mtl_system_items_tl mtl,
509: oe_order_lines_all oel
510: where mtl.inventory_item_id = oel.inventory_item_id
511: and mtl.organization_id = p_ship_org_id
512: and oel.ato_line_id = p_ato_line_id