DBA Data[Home] [Help]

APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_CUSTOMER_ITEMS

Line 2109: from mtl_customer_items citems,

2105: elsif (ITEM_IDENTIFIER_TYPE = 'CUST' and P_PRINT_DESCRIPTION in ('C','P','O')) then
2106: select citems.customer_item_number item,
2107: nvl(citems.customer_item_desc,sitems.description) description
2108: into v_item,v_description
2109: from mtl_customer_items citems,
2110: mtl_customer_item_xrefs cxref,
2111: mtl_system_items_vl sitems
2112: where citems.customer_item_id = cxref.customer_item_id
2113: and cxref.inventory_item_id = sitems.inventory_item_id