DBA Data[Home] [Help]

APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 223: from mtl_system_items_vl sitems

219: or (p_print_description in ('I','D','F')) then
220: select sitems.concatenated_segments item,
221: sitems.description description
222: into v_item,v_description
223: from mtl_system_items_vl sitems
224: where
225: -- sitems.customer_order_enabled_flag = 'Y' --> Commented for the bug 2864636
226: -- and sitems.bom_item_type in (1,4)
227: nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 239: mtl_system_items_vl sitems

235: nvl(citems.customer_item_desc,sitems.description) description
236: into v_item,v_description
237: from mtl_customer_items citems,
238: mtl_customer_item_xrefs cxref,
239: mtl_system_items_vl sitems
240: where citems.customer_item_id = cxref.customer_item_id
241: and cxref.inventory_item_id = sitems.inventory_item_id
242: and citems.customer_item_id = ordered_item_id
243: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

Line 254: mtl_system_items_vl sitems

250: nvl(items.description,sitems.description) description
251: into v_item,v_description
252: from mtl_cross_reference_types xtypes,
253: mtl_cross_references items,
254: mtl_system_items_vl sitems
255: where xtypes.cross_reference_type = items.cross_reference_type
256: and items.inventory_item_id = sitems.inventory_item_id
257: and items.cross_reference = ordered_item
258: and items.cross_reference_type = item_identifier_type

Line 272: mtl_system_items_vl sitems

268: nvl(items.description,sitems.description) description
269: into v_item,v_description
270: from mtl_cross_reference_types xtypes,
271: mtl_cross_references items,
272: mtl_system_items_vl sitems
273: where xtypes.cross_reference_type =
274: items.cross_reference_type
275: and items.inventory_item_id =
276: sitems.inventory_item_id