DBA Data[Home] [Help]

APPS.GMF_MEMO_INTERFACE dependencies on MTL_SYSTEM_ITEMS

Line 154: FROM mtl_system_items msi

150: t_rctt_attribute10 ra_cust_trx_types_all.attribute10%type;
151:
152: CURSOR get_item_no(t_item_id in NUMBER) IS
153: SELECT msi.segment1
154: FROM mtl_system_items msi
155: WHERE msi.inventory_item_id=t_inventory_item_id;
156:
157: t_item_no mtl_system_items.segment1%TYPE;
158:

Line 157: t_item_no mtl_system_items.segment1%TYPE;

153: SELECT msi.segment1
154: FROM mtl_system_items msi
155: WHERE msi.inventory_item_id=t_inventory_item_id;
156:
157: t_item_no mtl_system_items.segment1%TYPE;
158:
159: CURSOR get_item_ind(i_item_no VARCHAR2) IS
160: SELECT dualum_ind, lot_ctl
161: FROM ic_item_mst