259:
260: OPEN x_mo_item_lov FOR
261:
262: SELECT DISTINCT opi.item_no, opi.item_desc1, opi.item_id, mti.inventory_item_id
263: FROM mtl_system_items mti,
264: ic_item_mst opi,
265: ic_txn_request_lines l
266: WHERE opi.item_no = mti.segment1
267: and opi.item_no LIKE (p_item_no)
271:
272: UNION
273:
274: SELECT DISTINCT opi.item_no, opi.item_desc1, opi.item_id, mti.inventory_item_id
275: FROM mtl_system_items mti,
276: ic_item_mst opi,
277: mtl_cross_references mcr
278: WHERE
279: mti.organization_id = p_org_id