APPS.ONT_OEXOHOHS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 17: from mtl_system_items_vl sitems

13: if (item_identifier_type_L is null or item_identifier_type_L = 'INT')
14: or (p_flex_or_desc in ('I','D','F')) then
15: select sitems.description description
16: into v_description
17: from mtl_system_items_vl sitems
18: Where nvl(sitems.organization_id,0) = c_master_org_L
19: and sitems.inventory_item_id = inventory_item_id_L;
20: /* srw.reference (:item_flex);
21: srw.reference (:p_item_flex_code);

Line 39: mtl_system_items_vl sitems

35: nvl(citems.customer_item_desc,sitems.description) description
36: into v_item,v_description
37: from mtl_customer_items citems,
38: mtl_customer_item_xrefs cxref,
39: mtl_system_items_vl sitems
40: where citems.customer_item_id = cxref.customer_item_id
41: and cxref.inventory_item_id = sitems.inventory_item_id
42: and citems.customer_item_id = ordered_item_id_L
43: and nvl(sitems.organization_id,0) = c_master_org_L

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

Line 72: mtl_system_items_vl sitems

68: nvl(items.description,sitems.description) description
69: into v_item,v_description
70: from mtl_cross_reference_types xtypes,
71: mtl_cross_references items,
72: mtl_system_items_vl sitems
73: where xtypes.cross_reference_type =
74: items.cross_reference_type
75: and items.inventory_item_id =
76: sitems.inventory_item_id