DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 2106: mtl_customer_item_xrefs cxref,

2102: select citems.customer_item_number item,
2103: nvl(citems.customer_item_desc,sitems.description) description
2104: into v_item,v_description
2105: from mtl_customer_items citems,
2106: mtl_customer_item_xrefs cxref,
2107: mtl_system_items_vl sitems
2108: where citems.customer_item_id = cxref.customer_item_id
2109: and cxref.inventory_item_id = sitems.inventory_item_id
2110: and citems.customer_item_id = ORDERED_ITEM_ID_T