DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 263: FROM mtl_system_items_kfv

259:
260:
261: CURSOR get_item_data (v_itemorg NUMBER, v_item_id NUMBER) IS
262: select concatenated_segments item_number, description item_description
263: FROM mtl_system_items_kfv
264: WHERE
265: organization_id = v_itemorg
266: AND inventory_item_id = v_item_id;
267:

Line 268: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;

264: WHERE
265: organization_id = v_itemorg
266: AND inventory_item_id = v_item_id;
267:
268: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
269: l_item_desc mtl_system_items_kfv.description%TYPE;
270:
271: CURSOR get_meaning (v_code VARCHAR2) IS
272: SELECT meaning

Line 269: l_item_desc mtl_system_items_kfv.description%TYPE;

265: organization_id = v_itemorg
266: AND inventory_item_id = v_item_id;
267:
268: l_item_number mtl_system_items_kfv.concatenated_segments%TYPE;
269: l_item_desc mtl_system_items_kfv.description%TYPE;
270:
271: CURSOR get_meaning (v_code VARCHAR2) IS
272: SELECT meaning
273: FROM gem_lookups