APPS.INV_GEN_LOC_KFV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

    SELECT application_column_name
      FROM fnd_id_flex_segments ffs
    WHERE application_id = 401 -- 'INV'
        AND id_flex_code = 'MTLL'
        AND id_flex_num = 101    -- 'STOCK_LOCATORS'
        AND enabled_flag = 'Y'
        AND display_flag = 'Y'
        AND (application_column_name not in ('SEGMENT19','SEGMENT20')
             OR p_compatibility = G_compatibility_mode_1158) --Added for bug#4345239
    ORDER BY segment_num;

Line: 33

    SELECT concatenated_segment_delimiter
    FROM fnd_id_flex_structures
    WHERE id_flex_code = 'MTLL'
    AND ROWNUM = 1;

Line: 46

   l_view_text := 'CREATE OR REPLACE VIEW WMS_ITEM_LOCATIONS_KFV AS SELECT';

Line: 52

   l_view_text := l_view_text||' PROGRAM_ID, PROGRAM_UPDATE_DATE, PROJECT_ID, TASK_ID, PHYSICAL_LOCATION_ID, PICK_UOM_CODE, DIMENSION_UOM_CODE, LENGTH, WIDTH, HEIGHT, LOCATOR_STATUS, ';

Line: 54

   l_view_text := l_view_text||' SUGGESTED_CUBIC_AREA, SUGGESTED_WEIGHT, LOCATION_SUGGESTED_UNITS, EMPTY_FLAG, MIXED_ITEMS_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,';