APPS.EGO_ITEM_COMPARE_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 38: TYPE g_item_num_table IS TABLE OF MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

34:
35: --This is used to log errors into IDC_DEBUG table. (incr programatically)
36: G_LINE_NUM PLS_INTEGER := 2000;
37:
38: TYPE g_item_num_table IS TABLE OF MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
39:
40: /*----------------------------------------------------------------------
41: IMPORTANT NOTES:
42:

Line 325: l_display_val MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;

321: p_organization_id IN NUMBER
322: )
323: RETURN VARCHAR2 IS
324:
325: l_display_val MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;
326:
327: CURSOR c_style_item_name(p_style_item_id NUMBER, p_organization_id NUMBER) IS
328: SELECT CONCATENATED_SEGMENTS
329: FROM MTL_SYSTEM_ITEMS_VL

Line 329: FROM MTL_SYSTEM_ITEMS_VL

325: l_display_val MTL_SYSTEM_ITEMS_VL.CONCATENATED_SEGMENTS%TYPE;
326:
327: CURSOR c_style_item_name(p_style_item_id NUMBER, p_organization_id NUMBER) IS
328: SELECT CONCATENATED_SEGMENTS
329: FROM MTL_SYSTEM_ITEMS_VL
330: WHERE inventory_item_id = p_style_item_id
331: AND organization_id = p_organization_id;
332:
333: BEGIN

Line 423: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_VL ';

419:
420: --Made this into bind variable SQL for 'SQL Compliance Project':11.5.9+ (5/1/2003)
421: l_dyn_sql := '';
422: l_dyn_sql := l_dyn_sql || ' SELECT '|| l_db_column;
423: l_dyn_sql := l_dyn_sql || ' FROM MTL_SYSTEM_ITEMS_VL ';
424: l_dyn_sql := l_dyn_sql || ' WHERE INVENTORY_ITEM_ID = :INVENTORY_ITEM_ID ';
425: l_dyn_sql := l_dyn_sql || ' AND ORGANIZATION_ID = :ORGANIZATION_ID ';
426:
427: --log_debug('l_dyn_sql - '||l_dyn_sql);