DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on MTL_SYSTEM_ITEMS

Line 263: FROM mtl_system_items mti,

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)

Line 275: FROM mtl_system_items mti,

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