DBA Data[Home] [Help]

APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 1010: mtl_customer_item_xrefs cxref,

1006: select citems.customer_item_number item,
1007: nvl(citems.customer_item_desc,sitems.description) description
1008: into v_item,v_description
1009: from mtl_customer_items citems,
1010: mtl_customer_item_xrefs cxref,
1011: mtl_system_items_vl sitems
1012: where citems.customer_item_id = cxref.customer_item_id
1013: and cxref.inventory_item_id = sitems.inventory_item_id
1014: and citems.customer_item_id = ordered_item_id