DBA Data[Home] [Help]

APPS.ONT_OEXOHOHS_XMLP_PKG dependencies on MTL_CUSTOMER_ITEMS

Line 37: from mtl_customer_items citems,

33: elsif (item_identifier_type_L = 'CUST' and p_flex_or_desc in ('C','P','O')) then
34: select citems.customer_item_number item,
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