DBA Data[Home] [Help]

APPS.ONT_OEXOECCL_XMLP_PKG dependencies on MTL_CUSTOMER_ITEMS

Line 340: from mtl_customer_items citems,

336: elsif (item_identifier_type = 'CUST' and p_item_description in ('C','P','O')) then
337: select citems.customer_item_number item,
338: nvl(citems.customer_item_desc,sitems.description) description
339: into v_item,v_description
340: from mtl_customer_items citems,
341: mtl_customer_item_xrefs cxref,
342: mtl_system_items_vl sitems
343: where citems.customer_item_id = cxref.customer_item_id
344: and cxref.inventory_item_id = sitems.inventory_item_id