APPS.GML_AUDIT_REPORTS dependencies on MTL_SYSTEM_ITEMS

Line 231: l_ofi_itm mtl_system_items.segment1%TYPE;

227: FUNCTION chk_ofi_gms_poln_itm( p_olid NUMBER,
228: p_glid NUMBER) RETURN VARCHAR2 IS
229:
230: l_gms_itm ic_item_mst.item_no%TYPE;
231: l_ofi_itm mtl_system_items.segment1%TYPE;
232:
233: CURSOR gms_itm_cur IS
234: SELECT a.item_no
235: FROM ic_item_mst a,

Line 243: mtl_system_items b

239:
240: CURSOR ofi_itm_cur IS
241: SELECT segment1
242: FROM po_lines_all a,
243: mtl_system_items b
244: WHERE a.item_id=b.inventory_item_id
245: AND a.po_line_id=p_olid;
246: BEGIN
247: OPEN gms_itm_cur;