DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on IC_ITEM_MST

Line 264: ic_item_mst opi,

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

Line 276: ic_item_mst opi,

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

Line 300: ic_item_mst

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);