APPS.ONT_OEXOESOS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 17: from mtl_system_items_vl sitems

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

Line 40: mtl_system_items_vl sitems

36: nvl(citems.customer_item_desc,sitems.description) description
37: into v_item,v_description
38: from mtl_customer_items citems,
39: mtl_customer_item_xrefs cxref,
40: mtl_system_items_vl sitems
41: where citems.customer_item_id = cxref.customer_item_id
42: and cxref.inventory_item_id = sitems.inventory_item_id
43: and citems.customer_item_id = ordered_item_id_L
44: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 54: mtl_system_items_vl sitems

50: nvl(items.description,sitems.description) description
51: into v_item,v_description
52: from mtl_cross_reference_types xtypes,
53: mtl_cross_references items,
54: mtl_system_items_vl sitems
55: where xtypes.cross_reference_type = items.cross_reference_type
56: and items.inventory_item_id = sitems.inventory_item_id
57: and items.cross_reference = ordered_item_L
58: and items.cross_reference_type = item_identifier_type_L