APPS.ONT_OEXOEUBK_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 19: from mtl_system_items_vl sitems

15: or (p_print_description in ('I','D','F')) then
16: select sitems.concatenated_segments item,
17: sitems.description description
18: into v_item,v_description
19: from mtl_system_items_vl sitems
20: where sitems.customer_order_enabled_flag = 'Y'
21:
22: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
23: and sitems.inventory_item_id = inventory_item_id_L;

Line 45: mtl_system_items_vl sitems

41: nvl(citems.customer_item_desc,sitems.description) description
42: into v_item,v_description
43: from mtl_customer_items citems,
44: mtl_customer_item_xrefs cxref,
45: mtl_system_items_vl sitems
46: where citems.customer_item_id = cxref.customer_item_id
47: and cxref.inventory_item_id = sitems.inventory_item_id
48: and citems.customer_item_id = ordered_item_id_L
49: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 60: mtl_system_items_vl sitems

56: nvl(items.description,sitems.description) description
57: into v_item,v_description
58: from mtl_cross_reference_types xtypes,
59: mtl_cross_references items,
60: mtl_system_items_vl sitems
61: where xtypes.cross_reference_type = items.cross_reference_type
62: and items.inventory_item_id = sitems.inventory_item_id
63: and items.cross_reference = ordered_item_L
64: and items.cross_reference_type = item_identifier_type_L

Line 78: mtl_system_items_vl sitems

74: nvl(items.description,sitems.description) description
75: into v_item,v_description
76: from mtl_cross_reference_types xtypes,
77: mtl_cross_references items,
78: mtl_system_items_vl sitems
79: where xtypes.cross_reference_type =
80: items.cross_reference_type
81: and items.inventory_item_id =
82: sitems.inventory_item_id