DBA Data[Home] [Help]

APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_CUSTOMER_ITEM_XREFS

Line 1018: mtl_customer_item_xrefs cxref,

1014: select citems.customer_item_number item,
1015: nvl(citems.customer_item_desc,sitems.description) description
1016: into v_item,v_description
1017: from mtl_customer_items citems,
1018: mtl_customer_item_xrefs cxref,
1019: mtl_system_items_vl sitems
1020: where citems.customer_item_id = cxref.customer_item_id
1021: and cxref.inventory_item_id = sitems.inventory_item_id
1022: and citems.customer_item_id = ordered_item_id