APPS.JMF_SHIKYU_RPT_UTIL SQL Statements

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

Line: 93

    SELECT segment1
          ,segment2
          ,segment3
          ,segment4
          ,segment5
          ,segment6
          ,segment7
          ,segment8
          ,segment9
          ,segment10
          ,segment11
          ,segment12
          ,segment13
          ,segment14
          ,segment15
          ,segment16
          ,segment17
          ,segment18
          ,segment19
          ,segment20
      INTO l_segs1(1)
          ,l_segs1(2)
          ,l_segs1(3)
          ,l_segs1(4)
          ,l_segs1(5)
          ,l_segs1(6)
          ,l_segs1(7)
          ,l_segs1(8)
          ,l_segs1(9)
          ,l_segs1(10)
          ,l_segs1(11)
          ,l_segs1(12)
          ,l_segs1(13)
          ,l_segs1(14)
          ,l_segs1(15)
          ,l_segs1(16)
          ,l_segs1(17)
          ,l_segs1(18)
          ,l_segs1(19)
          ,l_segs1(20)
      FROM mtl_system_items
     WHERE organization_id = p_organization_id
       AND inventory_item_id = p_inventory_item_id;

Line: 215

    SELECT segment1
          ,segment2
          ,segment3
          ,segment4
          ,segment5
          ,segment6
          ,segment7
          ,segment8
          ,segment9
          ,segment10
          ,segment11
          ,segment12
          ,segment13
          ,segment14
          ,segment15
          ,segment16
          ,segment17
          ,segment18
          ,segment19
          ,segment20
      INTO l_segs1(1)
          ,l_segs1(2)
          ,l_segs1(3)
          ,l_segs1(4)
          ,l_segs1(5)
          ,l_segs1(6)
          ,l_segs1(7)
          ,l_segs1(8)
          ,l_segs1(9)
          ,l_segs1(10)
          ,l_segs1(11)
          ,l_segs1(12)
          ,l_segs1(13)
          ,l_segs1(14)
          ,l_segs1(15)
          ,l_segs1(16)
          ,l_segs1(17)
          ,l_segs1(18)
          ,l_segs1(19)
          ,l_segs1(20)
      FROM mtl_system_items
     WHERE organization_id = p_organization_id
       AND inventory_item_id = p_inventory_item_id;

Line: 301

      SELECT UOM_CODE
        INTO l_uom_code
        FROM MTL_UNITS_OF_MEASURE_TL
       WHERE LANGUAGE = USERENV('LANG')
         AND UNIT_OF_MEASURE = p_unit_of_measure;

Line: 311

        SELECT UOM_CODE
          INTO l_uom_code
          FROM MTL_UNITS_OF_MEASURE_TL
         WHERE LANGUAGE = 'US'
           AND UNIT_OF_MEASURE = p_unit_of_measure;

Line: 370

      SELECT unit_of_measure
        INTO l_current_uom
        FROM mtl_units_of_measure_vl
       WHERE uom_code = p_current_uom_code;

Line: 382

    SELECT uom_code
      INTO l_primary_uom_code
      FROM mtl_units_of_measure_vl
     WHERE unit_of_measure = l_primary_uom;

Line: 415

    SELECT unit_of_measure
      INTO l_current_uom
      FROM mtl_units_of_measure_vl
     WHERE uom_code = p_current_uom_code;

Line: 467

      SELECT UNIT_OF_MEASURE
        INTO l_from_unit_name
        FROM MTL_UNITS_OF_MEASURE_TL
       WHERE LANGUAGE = USERENV('LANG')
         AND UOM_CODE = p_from_unit;

Line: 473

      SELECT UNIT_OF_MEASURE
        INTO l_to_unit_name
        FROM MTL_UNITS_OF_MEASURE_TL
       WHERE LANGUAGE = USERENV('LANG')
         AND UOM_CODE = p_to_unit;

Line: 483

          SELECT UNIT_OF_MEASURE
            INTO l_from_unit_name
            FROM MTL_UNITS_OF_MEASURE_TL
           WHERE LANGUAGE = 'US'
             AND UOM_CODE = p_from_unit;

Line: 489

          SELECT UNIT_OF_MEASURE
            INTO l_to_unit_name
            FROM MTL_UNITS_OF_MEASURE_TL
           WHERE LANGUAGE = 'US'
             AND UOM_CODE = p_to_unit;

Line: 779

         /*--insert into table,for debug only--
         INSERT INTO jmf_shikyu_cfr_rpt_temp
           (rpt_mode
           ,rpt_data_type
           ,attribute10
           ,attribute11
           ,attribute12)
         VALUES
           ('FND_FILE.LOG'
           ,-999
           ,p_api_name
           ,p_message
           ,to_char(SYSDATE,'YYYY-MM-DD HH:MM:SS'));