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)
268: and mti.organization_id = p_org_id
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
280: AND opi.item_no = mti.segment1
296: CURSOR Get_Loct_Ctl IS
297: SELECT
298: loct_ctl
299: FROM
300: ic_item_mst
301: WHERE
302: item_id = p_item_id;
303:
304: l_loct_ctl NUMBER(1);