APPS.INV_STATUS_LOVS SQL Statements

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

Line: 20

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE zone_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;

Line: 33

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE locator_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;

Line: 46

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE lot_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;

Line: 59

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE serial_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;

Line: 73

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE onhand_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;

Line: 90

        SELECT mms.status_code, mms.status_id
        FROM mtl_material_statuses_vl mms, mtl_status_transaction_control mstc
        WHERE mms.status_id = mstc.status_id
          and mms.lot_control = 1
          and mms.enabled_flag = 1
          and mms.status_code like (p_status_code)
          and mstc.is_allowed = 1
          and mstc.transaction_type_id = p_trx_type_id
        order by mms.status_code;

Line: 101

        SELECT status_code, status_id
        FROM mtl_material_statuses_vl
        WHERE lot_control = 1
          and enabled_flag = 1
          and status_code like (p_status_code)
        order by status_code;