DBA Data[Home] [Help]

APPS.ONT_OEXOEORS_XMLP_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 749: mtl_customer_item_xrefs cxref,

745: select citems.customer_item_number item,
746: nvl(citems.customer_item_desc,sitems.description) description
747: into v_item,v_description
748: from mtl_customer_items citems,
749: mtl_customer_item_xrefs cxref,
750: mtl_system_items_vl sitems
751: where citems.customer_item_id = cxref.customer_item_id
752: and cxref.inventory_item_id = sitems.inventory_item_id
753: and citems.customer_item_id = ordered_item_id