DBA Data[Home] [Help]

APPS.GML_PO_INTERFACE dependencies on MTL_SYSTEM_ITEMS

Line 244: /* Cursor to select values from mtl_system_items table */

240: SELECT release_num
241: FROM po_releases_all
242: WHERE po_release_id = v_po_release_id;
243:
244: /* Cursor to select values from mtl_system_items table */
245:
246: CURSOR mtl_vars_cur
247: IS
248: SELECT distinct substrb(segment1,1,32), substrb(description, 1,70),

Line 250: FROM mtl_system_items

246: CURSOR mtl_vars_cur
247: IS
248: SELECT distinct substrb(segment1,1,32), substrb(description, 1,70),
249: inventory_item_flag
250: FROM mtl_system_items
251: WHERE inventory_item_id = v_item_id;
252:
253: /* T.Ricci 10/15/98 added terms_name_cur for terms code fix for OPM 11.0*/
254: CURSOR terms_name_cur