DBA Data[Home] [Help]

APPS.ONT_OEXOEORD_XMLP_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 595: mtl_customer_item_xrefs cxref,

591: select citems.customer_item_number item,
592: nvl(citems.customer_item_desc,sitems.description) description
593: into v_item,v_description
594: from mtl_customer_items citems,
595: mtl_customer_item_xrefs cxref,
596: mtl_system_items_vl sitems
597: where citems.customer_item_id = cxref.customer_item_id
598: and cxref.inventory_item_id = sitems.inventory_item_id
599: and citems.customer_item_id = ordered_item_id