APPS.ONT_OEXPRPRD_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 20: from mtl_system_items_vl sitems

16: sitems.description description
17: into
18: -- v_item,
19: v_description
20: from mtl_system_items_vl sitems
21: where
22: sitems.customer_order_enabled_flag = 'Y' and
23: sitems.bom_item_type in (1,4)
24: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 48: mtl_system_items_vl sitems

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

Line 62: mtl_system_items_vl sitems

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